Questions and discussion about using ProcessMaker 2: user interface, running cases and functionality

Moderator: amosbatto

Forum rules: Please search to see if a question has already been asked before posting. Please don't ask the same question in multiple forums.
By minhvoice
#813918
hi

i created a new menu according to my process and want to modified advanced search according to my fields

i want to apply filter on my custom fields as i build a new dynaform for advanced search with my custom fields and wanted to fetch data from db


how i fetch data from db and which files to be modified according to my filter


thanks in advance
By amosbatto
#813921
If you want to modify advanced search, you can modify the code of the Applications::getAll() function defined in workflow/engine/classes/class.applications.php.

Look in the code where $search is used.

To do a query in the database, you can use this code:
Code: Select all
$g = new G()
$g->LoadClass('pmFunctions');

//set to the ID of your database connection if using an external database
$db = '1234567890abcdef1234567890abcdef';
 
$aRows = executeQuery("SELECT FIELD1, FIELD2 FROM TABLEX", $db);
if (count($aRows) >= 1) {
   $x = $aRows[1]['FIELD1'];
} 
Send for clarification

Cost: Will you be using PM entrerprise or open sou[…]

SMS Gateway

Hello natesh, I have a Get ready to use integrate[…]

delete information after CSV export

thanks for your attention, i have some change on y[…]

Thanx again amosbatto... I'll re-check file permis[…]