| Can a MAX Function serve as a Search Parameter [message #1838825] |
Fri, 05 March 2021 18:56 |
Eclipse User |
|
|
|
Hi All,
I am working on my first Search parameters in my report.
The search parameters work fine, when I use a normal data set:
SQL selection:
PFT.ORDER_NO AS ORDERNUMMER,
SQL search parameter in where clause:
/**AND PFT.ORDER_NO = [OrderNummer] */
OrderNummer is also defined in the Report Parameter Section.
So, this works fine....
But the search parameters don't work, when I use a function (here "min") as data set:
SQL selection:
MIN(PFT.LST_UPD_TSTMP) OVER (PARTITION BY PFT.ORDER_NO) AS Date_of_earliest_Approval_of_TX_inOrder,
SQL search parameter in where clause:
/** AND trunc (MIN(PFT.LST_UPD_TSTMP) OVER (PARTITION BY PFT.ORDER_NO)) >= [Date_of_earliest_Approval_of_TX_inOrder]*/
Date_of_earliest_Approval_of_TX_inOrder is also defined in the Report Parameter Section.
So, this does not work...
Does anyone have an idea what I am doing wrong here?
Brgds., Uwe
|
|
|
Powered by
FUDForum. Page generated in 0.02859 seconds
] 
Search
Help
Register
Login
Home
