Skip to main content

I have requirement to create a report and invoice date which is of date data type is the parameter that needs to be given in the order report dialog which should also allow between operator. I'm trying to use report_sys.parse_parameter(column (which is date data type), parameter (which is date datatype)).its throwing me invalid relational operator error.

 

How do we solve this.when the parameter is date data type.

 

 

Thanks in advance.

I would suggest doing two parameters instead. Then you have full freedom in the RDF to create a proper WHERE statement instead of using Report_SYS.Parse_Parameter (which also might lead to performance issues).

 

Like this example:

voucher_date BETWEEN from_date_ AND from_date_

Hi ​@Tomas Ruderfelt 

I have a requirement to build a cursor to fetch values based on given set of parameters. Due to the complex selection criteria, I used Report_SYS.Parse_Parameter, but this causes table full access where I need to reconsider my approach 😐

   SELECT * 
    FROM GEN_LED_VOUCHER_ROW
   WHERE REPORT_SYS.Parse_Parameter(COMPANY, companies_) = 'TRUE'
   AND REPORT_SYS.Parse_Parameter(VOUCHER_TYPE, voucher_types_) = 'TRUE'
   AND REPORT_SYS.Parse_Parameter(ACCOUNT, account_range_) = 'TRUE'
   AND TRUNC(to_date(OBJVERSION,'YYYYMMDDHH24MISS')) = TRUNC(entry_date_);

parameter value example:

companies_ : ABC;DEF;GHI

voucher_types_ : J;M

account range_ : 1000..1999;4000..5999

 

Do you have any ideas to achieve something like this without using Report_SYS.Parse_Parameter?

Reply


Terms & ConditionsCookie settings