Skip to main content

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

 

There seems to be some syntax changes here. Could you try the below query ?

REAL_S_DATE < to_date ('#TODAY#', 'YYYY-MM-DD-HH24:MI:SS' ) -90

 

 


Hi,

 

In IFS Cloud I was able to this with teh following search 

 


Awesome!!!  Thanks for the Quick responses.  They both work.

 

Gregg


Reply