Skip to main content

Hello,

I’ve tried multiple times to input the parameters, but each attempt has resulted in quotation errors or other issues. Here’s what I’m aiming for:

Input:

ifsapf:tbwJtTask_Ext?external_search=source_ref1={&PM_NO}%20AND%20STATE%20IN%28%27Cancelled%27%2C%27Finished%27%2C%27WorkDone%27%29%20ORDER%20BY%20created_date%20DESC%20FETCH%20first%2010%20rows%20only


Expected Result:

WHERE source_ref1 = {&PM_NO}
AND state IN ('Canceled', 'WorkDone', 'Finished')
ORDER BY t.created_date DESC FETCH first 10 rows only


Actual Output:

where (SOURCE_REF1 = '234' AND STATE IN(''Cancelled'',''Finished'',''WorkDone'') ORDER BY created_date DESC FETCH first 10 rows only');


Could you help me understand how to adjust this so the query runs as intended? Thank you very much for your guidance.

Hi,

I'm guessing now, but it could be that what you want to do is something that feature was not designed for. In case you didn't yet check it, here are some links to the documentation:

About external search:

https://docs.ifs.com/techdocs/foundation1/050_development/022_user_interface/045_ee_dev/080_external_search/default.htm

External search in combination with the ifshome protocol:

https://docs.ifs.com/techdocs/foundation1/050_development/022_user_interface/045_ee_dev/090_ifshome/default.htm

Perhaps you can get some clues from there?

If you cannot sort it out, you might want to consider creating a support case as well, to get a definite answer.

Good luck!
 


Reply