Question

Quick Report between flag issue

  • 24 May 2023
  • 5 replies
  • 121 views
G
Rank
Badge

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
Rank
Userlevel 3
Badge +10

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

..

M
Rank
Userlevel 3
Badge +10

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

hhy38
Rank
Userlevel 5
Badge +14

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
Rank
Userlevel 3
Badge +10

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
Rank
Userlevel 5
Badge +14

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/

Reply


Terms & ConditionsCookie settings