[GianYagami]

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:

Code: Select all

if case number suggest control has selected, approval title suggest control autofield based on APP_NUMBER(case number value) and vice versa

I've tried using dynaform based value, but it affect preview mode which is failed to load.
the query is:

Code: Select all

SELECT APP_NUMBER, APP_NUMBER FROM PMT_APPROVAL_REPORT WHERE APP_NUMBER = @@ref_case_number;

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.

I know suggestion control works without

Code: Select all

WHERE LIKE

filter but it seems buggy when I tried to implemented this. I am using processmaker 3.2

that's all I can tell, I hope it's clear so it will be solved soon...

[GianYagami]

bump,

update: I've tried with textbox and they call each other with query and the result is same, they affect my session which make slow response on my bpm web.