Skip to main content
Question

Quick Report between flag issue


Forum|alt.badge.img

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?

5 replies

Forum|alt.badge.img+10
  • Hero (Customer)
  • 126 replies
  • May 25, 2023

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

..


Forum|alt.badge.img+10
  • Hero (Customer)
  • 126 replies
  • May 25, 2023

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


hhy38
Superhero (Customer)
Forum|alt.badge.img+16
  • Superhero (Customer)
  • 325 replies
  • October 21, 2023
mwilson wrote:

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.


ashen_malaka_ranasinghe
Hero (Employee)
Forum|alt.badge.img+11

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


hhy38
Superhero (Customer)
Forum|alt.badge.img+16
  • Superhero (Customer)
  • 325 replies
  • October 21, 2023
ashen_malaka_ranasinghe wrote:

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

 

Records

 

Quick Report Parameter

 


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