Skip to main content
Question

Quick Report between flag issue

  • May 24, 2023
  • 5 replies
  • 216 views
G
Do Gooder (Customer)
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

M
Hero (Customer)
Forum|alt.badge.img+10
  • mwilson
  • 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

..

M
Hero (Customer)
Forum|alt.badge.img+10
  • mwilson
  • 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
  • hhy38
  • Superhero (Customer)
  • 326 replies
  • October 21, 2023

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.

Linkedin Profile: https://www.linkedin.com/in/hhy34/
ashen_malaka_ranasinghe
Hero (Employee)
Forum|alt.badge.img+12

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

Find me on LinkedIn as Ashen Malaka: https://www.linkedin.com/in/ashen-malaka-ranasinghe/
hhy38
Superhero (Customer)
Forum|alt.badge.img+16
  • hhy38
  • Superhero (Customer)
  • 326 replies
  • October 21, 2023

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

 

Linkedin Profile: https://www.linkedin.com/in/hhy34/


Terms & ConditionsCookie settingsAccessibility statement