I’m working in IFS Applications 10 Update 12.
In IEE, I create a quick report according to the documentation using a list of values and Query Flags: https://docs.ifs.com/techdocs/21r1/foundation1/045_administration_aurena/255_br_and_a/005_adhoc_reporting/010_quickreports/default.htm
SELECT * from customer_info where customer_category_db LIKE '&[-CS--]CUSTOMER_INFO.CUSTOMER_CATEGORY_DB'
Viewing the report produces the expected parameter “Customer Category” with the expected list of values. If I run the report with the value “Customer”, many records are returned.
I switch over to Aurena and go to Reporting/Order Report/ and order my report. The parameter shows as the view name and does not have the list of values. Even if I manually type in the value “Customer”, the report returns nothing.
Am I missing a step or two in Aurena to get the list of values to work as described in the tech doc?
I’ve used these query flags and lov sources often in IEE and have not had any issues. This is the first time I’ve tried this in Aurena and don’t understand why it’s failing to produce the lov and run.
