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.