I am using IE to create Lobby Elements for Aurena. I am trying to create a Lobby Element for Active Work Orders that are 90 days or older.
The Actual Start date field in IE is REAL_S_DATE.
The Actual Start Date field in Aurena is RealSDate
In IE, on the Data Source Designer, I can set up Condition to be
REAL_S_DATE < to_date ('#NOW#', 'YYYY-MM-DD-HH24:MI:SS' ) -90
and it works in IE.
If I try to create the Lobby Element for Aurena using the same Data Source, I get an X.
How do I set up the Condition for Aurena? Does the field name need to be changed to match the one is Aurena?
How do I search for Work Orders that are 90 Days or older on the Active Work Order screen in Aurena?
Is this correct?
Thanks,
Gregg