Skip to main content
Question

pass multiple values in single parameter in IFS quick reports

  • January 16, 2024
  • 1 reply
  • 319 views

Forum|alt.badge.img+7
  • Sidekick (Customer)
  • 31 replies

How can I pass multiple values separate by “,” in a single input parameter in quick report?

select from SHIPMENT  where CONTRACT ='&CONTRACT'  « this one works only for one value at a time

 

1 reply

Forum|alt.badge.img+10
  • Hero (Partner)
  • 126 replies
  • January 17, 2024

According to the technical documentation, you should be able to use query flags on your parameters. See: https://docs.ifs.com/techdocs/23r1/050_reporting/256_br_and_a/005_adhoc_reporting/010_quickreports/#query_flags

However, the below doesn’t work for me at all. Perhaps the query dialog in IFS Enterprise Explorer modified the query on the fly, whereas Aurena doesn’t?

SELECT * FROM Shipment WHERE contract LIKE '&[-C--L]Site'

A cheat code I sometimes use is a function intended for operational reports: Report_SYS.Parse_Parameter. The first argument should be your data column and the second your query parameter. It accepts multiple values separated by semi-colon (;) wildcards (_ and %) as well as between (..), and returns TRUE or FALSE. You might take a performance hit though, so in your case I would use a sub-select to filter out the sites first like this:

SELECT * FROM Shipment WHERE contract IN (SELECT contract FROM Site WHERE Report_SYS.Parse_Parameter(contract, Upper('&Site')) = 'TRUE')

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings