+2I 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.
Best answer by Tomas Ruderfelt
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_
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_
+22Hi
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?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.