Skip to main content

Hi Team,


We often transfer a screen field value as a parameter to an operational report using Page Designer. Do you know if it is possible to format a date item into a different format, such as Oracle's "to_date","to_char" etc. Thank you.

Although both the view field and report parameter are of date type, when I tried to transfer the screen value as the report's parameter and execute the report, the error shown below occurred.

 

Instead, if a fixed value of '2025/2/1' or '2025-2-1' is set in the Action Parameter, the error disappears. 

Do you have any good ideas to share with me?

 

Best Regards,

Feng

What is the query behind the report? What’s the parameter matching against?

Hi ​@PhillBronson 

 

Thank you. I will check and get back to you.

BR

Feng

​@feng I haven’t tried this myself, but I believe you could potentially create a new Custom Field of type expression, use PL\SQL to format it as you like, and then pass the resulting value to your OR. 

https://docs.ifs.com/techdocs/24r2/040_tailoring/225_configuration/400_entity_configurations/020_create_custom_fields/020_add_edit_readonly_attribute/#expression_type

Best regards,

Rukmal

Hi ​@Rukmal Fernando 

 

Good idea. Thank you very much!

In fact, when I transfer the same date field to an IFS standard operational report, it works. So, there may be some issues with the customized report. 

I will update here if there are any new developments.

 

Best regard,

Feng

Hi ​@PhillBronson 

The query is as below. Do you think there are any issues with it? Thank you.

BR

Feng

Reply


Terms & ConditionsCookie settings