Hi All
I have a problem with the Datasource Designer in IFS. I want to create a table which show me different values based on different date / timeperiods. The values which I want to select are all located on the same view. I am able to generate the date in PL/SQL without problems. In PL/SQL I use subquerrys, in which I use different abbreviations for the same view.
For example:
(select round(sum(lo.hours_loaded))
from ifsapp.labor_operation_load lo
where lo.labor_class_no = l.labor_class_no
and lo.contract = l.contract
and lo.company = l.company
and lo.work_day between trunc(sysdate,'iw')and trunc(sysdate + 7,'iw')-1
)
in this example “l.” usees also the datasource “ifsapp.labor_operation_load”.
As you can see, I use the same datasource in my query. In PL/SQL I receive differnet results for different Labor classes (as wanted). But when I want to create a Lobby Element, I receive only one result for all Labor classes.
I want tu sum the Hours_loaded for every different Labor class where the work day is in the current week.
Is it possible to crate a list with multiple values where all values are on the same view and each value has a different date condition ?
Thanks for help
