Quick Report between flag issue

Hi,

during implementation of new quick report I experienced a weird problem - let me try to describe it using below example:

For simple code:

SELECT
	CREATE_DATE,
	PART_NO,
	CONTRACT
FROM
	IFSAPP.INVENTORY_PART
WHERE
	REPORT_SYS.PARSE_PARAMETER(CREATE_DATE,'&[-W-BL]Created') = 'TRUE'

configuration like [-W-BL] should give me possibility to use “between” expression for this filter.

However, when I try to use it:

IFS always returns “No data found” information - of course I checked and in our database we’ve got parts created in this period.

What might be the reason of presented problem? Is there any way to fix it?

Page 1 / 1

That function acts the same and the values from a query window. You have to give it the values. The between operator is

..

I do have a question though. Why not just use a between, it is SQL after all?

Because to make UX the same as the search screen.

Hi @GrzegorzPlo,

Can you try this SQL query as well?

SELECT 
     CREATE_DATE, PART_NO, CONTRACT FROM IFSAPP.INVENTORY_PART 
WHERE 
     REPORT_SYS.PARSE_PARAMETER(CREATE_DATE,'&[-C-BL]Created') = 'TRUE'

Also, refer to the following document:

https://docs.ifs.com/techdocs/21r1/foundation1/045_administration_aurena/255_br_and_a/005_adhoc_reporting/010_quickreports/default.htm

Hi @GrzegorzPlo,

Can you try this SQL query as well?

SELECT 
     CREATE_DATE, PART_NO, CONTRACT FROM IFSAPP.INVENTORY_PART 
WHERE 
     REPORT_SYS.PARSE_PARAMETER(CREATE_DATE,'&;-C-BL]Created') = 'TRUE'

Also, refer to the following document:

https://docs.ifs.com/techdocs/21r1/foundation1/045_administration_aurena/255_br_and_a/005_adhoc_reporting/010_quickreports/default.htm

@ashen_malaka_ranasinghe I have the same problem. I tried. However, the application returns No data found

Column