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

Moderator: ArturoRobles

By HeshanKaru1994
#826218
Im generating a grid from sql queries. This grid is editable (All the data is filled)

Ex: Array ( [1] => Array ( [PAYEE_ID] => 124 [AGREEMENT_ID] => 88 [VENDOR_CODE] => 30000 [NAME] => heshan [ADDRESS] => jkbjkbjkb [CITY_ID] => Mount Lavinia [COUNTRY] => Sri Lanka
[CONTACT] => +234354657 [NIC_BRC_SELECTION] => NIC [NIC_BRC] => 12324356 [NIC_BRC_FILE_PATH] =>
https://dialog-axiata-dev.processmaker. ... 0098867366 [NIC_BRC_FILE_NAME] => 3.pdf
[NIC_BRC_FILE_APP_UID] => 9417105675d62083baba7e0098867366 [TIN_NUMBER] => 43546 [PERCENTAGE] => 100 [BANK_NAME] => dfgewfreg [BRANCH_NAME] => wretrje
[BRANCH_CODE] => 324354657 [COUNTRY_OF_BANK] => Sri Lanka [ACCOUNT_NUMBER] => 243546576 [CURRENCY] => LKR [SWIFT_CODE] => 4354676 [BANK_BOOK_COPY_PATH] =>
https://dialog-axiata-dev.processmaker. ... 5028501384 [BANK_BOOK_COPY_NAME] =>
3.pdf [BANK_BOOK_COPY_APP_UID] => 4517446825d62085b202fc5028501384 [STATUS] => ACTIVE [STATUS_CHANGED_REQUEST_TYPE] => [STATUS_UPDATED_DATE] => [ID] => 3
[CITY_NAME] => Mount Lavinia [POSTAL_CODE] => 10370 [VALUE] => ML ) )

After submitting this task it directs to the next task where the grid is in view mode (Here the fileupload files gets removed somehow in different places but not all the time)

eg:
Array ( [1] => Array ( [payeeName] => heshan [payeeName_label] => heshan [payeeAddress] => jkbjkbjkb [payeeAddress_label] => jkbjkbjkb [payeeCity_label] => Mount Lavinia [payeeCity] => Mount Lavinia [payeePostalCode] => 10370 [payeePostalCode_label] => 10370 [payeeCountry] => Sri Lanka [payeeCountry_label] => Sri Lanka [payeePhoneNumber] => +234354657 [payeePhoneNumber_label] => +234354657 [payeeNicBrcSelection] => NIC [payeeNicBrcSelection_label] => NIC [payeeNIC] => 12324356 [payeeNIC_label] => 12324356 [payeeNicBrcCopy] => Array ( ) [payeeNicBrcCopy_label] => Array ( ) [tinNumber] => 43546 [tinNumber_label] => 43546 [payeePercentage] => 40 [payeePercentage_label] => 40 [payeeBankName] => dfgewfreg [payeeBankName_label] => dfgewfreg [branchName] => wretrje [branchName_label] => wretrje [branchCode] => 324354657 [branchCode_label] => 324354657 [countryOfBank] => Sri Lanka [countryOfBank_label] => Sri Lanka [accountNumber] => 243546576 [accountNumber_label] => 243546576 [currencyType] => LKR [currencyType_label] => LKR [swiftCode] => 4354676 [swiftCode_label] => 4354676 [bankBookScanCopy] => Array ( [0] => Array ( [appDocUid] => 3003192895d6731bb2f3677084149697 [name] => CCU201906061056MARKETING_1.pdf [version] => 1 ) ) [bankBookScanCopy_label] => Array ( [0] => CCU201906061056MARKETING_1.pdf ) [vendorCode] => 30000 [vendorCode_label] => 30000 ) )


File uploaded code is like this
[NIC_BRC_FILE_PATH] =>
https://dialog-axiata-dev.processmaker. ... 0098867366 [NIC_BRC_FILE_NAME] => 3.pdf
[NIC_BRC_FILE_APP_UID] => 9417105675d62083baba7e0098867366

But it converts to something like this
[payeeNicBrcCopy] => Array ( ) [payeeNicBrcCopy_label] => Array ( )

Need a quick solution

Thank you
User avatar
By RicardoMG
#827972
Hello!

I was unable to replicate the behavior.
I created a process where I replicated what you did with a simple example:
1. I created 2 tasks A and B.
2. I created a variable for me called grid.
3. I created a dynaform.
4. The grid variable is associated with GRID control.
5. In the GRID control I have 2 text fields with the following ids: USR_USERNAME and USR_EMAIL
6. I create a trigger where I get the username and email data from the user table.
7. I assign the trigger before task A and populate the data I get from the trigger to the grid at the start of the case.
8. Task B has a dynaform which has the same grid but in view mode.

Attach the process so you can review it.

I have a question? to populate the grid did you use javascript ..?
Which version of processmaker did you get that behavior ..?
The code in the trigger that i used is the following:
Code: Select all
$query = 'SELECT USR_USERNAME, USR_EMAIL FROM USERS';
$result = executeQuery($query);
@@resultado = $result;
if (is_array($result) and count($result) > 0)
   @#grid = $result;
Best regards, Ricardo.
Attachments
(39.25 KiB) Downloaded 83 times

Excellent read, Positive site, where did u come up[…]

Hello ProcessMakers! We are extremely proud to an[…]

How processmaker load cases on home page of user? […]

Hey everyone, I'd appreciate any help you might be[…]