IFS Apps 10 upd 17-18 quick reports parameters issue

Hi,

It looks like the issue is with missing query flags.  In IFSAPP9 and IFSAPP10, you could specify Query Flags for the quick report parameters to search for multiple values.

Please edit your query as below and try executing the report and see if it does the job for you.

sma.order_no LIKE '&[-C--L]sma.order_no '

>>Below are the list of flags you could use;

• M=Mandatory
• C=Custom (simplified or 'values only')
• S=Single flag
• B=Allow Between expressions
• L=Allow wildcards ('%' and '_')

You may refer below link for more on query flags :

https://docs.ifs.com/techdocs/foundation1/050_development/026_br_and_a/005_adhoc_reporting/070_dev_qrep/default.htm

Hi tryied flags also but no change, still is adding extra ‘  or directly like You wroted  “ no data found”

Hi, can you add the full sql query you are using here.

Sure, here You are, this is oryginal one.

select 
listagg(zp,', ') within group (order by kod) ZP, 
kooperant, kod, opis, sum(suma_do_wydania) suma_do_wydania
from (
select sma.order_no zp, so.cf$_nfm_id_dostawcy kooperant, sma.part_no kod, INVENTORY_PART_API.Get_Description(sma.CONTRACT, sma.PART_NO) opis, 
(sma.qty_required) - (sma.qty_assigned) - (sma.qty_issued) suma_do_wydania
from SHOP_MATERIAL_ALLOC sma, SHOP_ORD_cfv so
where 
sma.order_no = so.order_no
and sma.release_no = so.release_no
and sma.sequence_no = so.sequence_no
and sma.order_no in (&WPISZ_ZP)
and (sma.qty_required) - (sma.qty_assigned) - (sma.qty_issued) > 0
) group by kooperant, kod, opis
order by 1

Hi,

Try to edit the statement like this >> sma.order_no LIKE '&[-C--L]order_no' (take out ‘sma’ after the flags). So the query would like below

and sma.order_no LIKE '&[-C--L]order_no'

Also when prompting for the parameters try and see by entering the values without quotes and use ‘;’ to separate the values.

Like in below example;

Treid it like that but without result. Option with apostrophe and comma result below:

option with semicolon

Regardig to use semicolon insted of apostrophe and comma, IFS Apps EE by default is putting data for parameter “devided” by apostrophe and comma. There is option to change it to semicolon? 

Hi,

I don’t think there is an option to change that. Let’s wait for any other expert ideas on this. If non of the above did work for you, I suggest you to raise this with IFS.

Hi, did you manage to resolve this?

We’ve just had Update 17 deployed, and now have an issue with a custom menu and quick report using expandable parameters, which was previously working fine.

Hi. It was marked as bug to IFS. WE got update for that.

hi @nmmjacek - Have you any infomation on the bug fix ID for this.

We are currently testing UPD 17-20 and have this issue.

I don’t fancy re-writing all our quick reports!

Hi @Matthew sorry no. We got fix from our partner. Bug was releted to some update for sql injection possibilities. 

Best regards.

Found the answer to out issue - In System Paramaters  - Reporting    ‘Enable bind variables for SQL Quick Reports in IFS EE’ is new. It is set to True by default.

Setting to False made the reports work for us.

I have same setting.

After UPD 17-20 applied Custom Menus using Quick Reports giving this error:

I tried the System Parameters fix suggested and it fixed other issues we were having with Quick Reports, but not this issue with the Custom Menu.

When I run the Quick Report by itself it runs, but when I use the custom field get error.

Details for Quick Report:

Anyone else see this or have any suggestions?