ProcessMaker code contributions

Moderators: ArturoRobles, ArturoRobles

By HeshanKaru1994
#824302
Hi, How to generate dropdown values(array variable ) from using pm tables. (Working sample would be nice)

Thank you
User avatar
By amosbatto
#824326
Can't you figure it out from the example in the documentation?
Code: Select all
@=varDataSource = array();
$result = executeQuery("SELECT MY_VALUE_FIELD, MY_LABEL_FIELD FROM PMT_MY_TABLE");

if (is_array($result)) {
    foreach ($result as $row) {
        @=varDataSource[] = array($row['MY_VALUE_FIELD'], $row['MY_LABEL_FIELD']);
    }
}
User avatar
By amosbatto
#824327
Also, please post these types of questions in the "Developing processes & programming" forum.

This forum is "Community Contributions > Code" and it is for contributing code to the ProcessMaker source code.
disable value in dropdown

Check box is more helpful rather than drop down op[…]

Timeout Not Sending Email

I would like to thank you for the efforts you have[…]

use 'insert into' in a trigger

Is your syntax correct? Shouldn't you be using s[…]

issue with processmaker 3.2

You mean the code in the trigger below? That is t[…]