Questions and discussion about developing processes and programming in PHP, JavaScript, web services & REST API.

Moderator: amosbatto

Forum rules: Please search to see if a question has already asked before creating a new topic. Please don't post the same question in multiple forums.
#824577
I tried to create a plugin with a dashlet in versions 3.0.1.8, 3.2.1 and 3.3.8 and it can't get the plugin's dashlet code to execute when the user clicks on the "Dashboards" menu. I filed a report with the developers, but have not yet received a reply. Usually it takes them a long time to respond.

For now, I recommend that you put your code to one of the existing dashlets in the ProcessMaker code. For example, you can change the code in the file workflow/engine/classes/DashletProcessMakerCommunity.php.

If you want to query a database, you can use code like this:
Code: Select all
//Set $db to the ID of a Database Connection if querying an external database.
//If querying the ProcessMaker database or a PM Table in the current workspace, then set to 'workflow': 
$db = 'workflow'; 

$cnn = Propel::getConnection($db);
$stmt = $cnn->createStatement();

$sql = "SELECT FIELD1, FIELD2 FROM PMT_MY_TABLE
     WHERE  FIELD3='something' ORDER BY FIELD1";
$result = $stmt->executeQuery($sql, ResultSet::FETCHMODE_ASSOC);
$aRecords = array();

while ($result->next()) {
      $row = $result->getRow();
      $aRecords[] = array($row['FIELD1'], $row['FIELD2']);
}

Hi Amosbatto. I apologise, I have been away for w[…]

Export grid to excel or csv

I want to export a grid to any kind of excel or cs[…]

Custom inbox columns

Can we add a variable from a process as a column w[…]

Hi, I'm programming a case in which a logged-in us[…]