Skip to main content

Hi,

There is a difference in how the BR report is executed when the parameter value in entered manually and selected from LOV. 

Selecting from LOV

Typing manually

 

This happens for both ‘Year’ and ‘Month’. They are of number type. But this is how the queries are formed.

using to_char() or to_number() in advanced filter criteria didn’t work. 

Converting the field in the IAL using to_char() also didn’t work.

Is there any other way to resolve this? 

Best Regards,
Nisansala

Hi ​@Nisansala Liyanage 

We tried this using both a standard Information Source and a Quick Information Source. However, when entering values for the parameters—either by selecting from the LOV or by manually typing them—the number-type parameter values appeared as shown in the screenshot. It seems you are using a Quick Information Source. Could you please verify the data type of the items at the Information Source level.
 


Thank You


Hi ​@shwiclk,

Thanks for the reply.

Yes, it’s a quick information source based on an IAL created using GEN_LED_VOUCHER_ROW_UNION_QRY. So the accounting_year and accounting_period are taken from gen_led_voucher_tab.

 

But when the values are manually typed in Order report dialog, query is formed with single quotes just like in TEXT fields. That’s the reason for not showing any data. LOVs are not enabled for these fields in the IFS Cloud – Order report dialog yet.

I tried to convert the parameter value using to_number() in advanced filter criteria and also changed the data type in IAL to TEXT using to_char(). But none of them worked. Would like to know if it is not possible to do the conversion in advanced filter criteria. 

Best Regards,
Nisansala



Hi ​@Nisansala Liyanage 

For clarification, when you said you tried it with Advanced Filter Criteria, did you mean you used Function Parameters?
 

Thank You


Hi ​@shwiclk,

No, I tried it in here.

Best Regards,
Nisansala


Hi ​@shwiclk,

It was resolved automatically (quite strange) and now it’s possible to enable ALL parameter values for those fields even they are NUMBER type.

But according to the documentation, this is possible only for STRING fields.

 

https://docs.ifs.com/techdocs/23r2/050_reporting/500_information_sources/020_info_source_settings/

Can these be some kind of a caching issue? Information source was refreshed with each change too.

Best Regards,
Nisansala


Hi ​@Nisansala Liyanage 

Thank you for the clarification and glad that you have been able to resolve it.
For your information, Function Parameters can be used do the conversion.

Without properly looking into the issue, I cannot tell the exact reason.

Thank You


Reply