By GianYagami - Mon Mar 02, 2020 12:38 am
- Mon Mar 02, 2020 12:38 am
#827621
Hi,
I have a report table, let's call it "PMT_APPROVAL_REPORT"
as usual, it contains APP_NUMBER and a textfield "Approval title"
I want to use 2 suggest control from that source, which is:
the query is:
I know suggestion control works without
that's all I can tell, I hope it's clear so it will be solved soon...
I have a report table, let's call it "PMT_APPROVAL_REPORT"
as usual, it contains APP_NUMBER and a textfield "Approval title"
I want to use 2 suggest control from that source, which is:
Code: Select all
I've tried using dynaform based value, but it affect preview mode which is failed to load.if case number suggest control has selected, approval title suggest control autofield based on APP_NUMBER(case number value) and vice versa
the query is:
Code: Select all
this query usually works on dropdown field but I can't implemented it on suggest control. It affect my session which is everything failed to load so I must using another browser or wait session is over, even I can't log out from this session.SELECT APP_NUMBER, APP_NUMBER FROM PMT_APPROVAL_REPORT WHERE APP_NUMBER = @@ref_case_number;
I know suggestion control works without
Code: Select all
filter but it seems buggy when I tried to implemented this. I am using processmaker 3.2WHERE LIKE
that's all I can tell, I hope it's clear so it will be solved soon...