Solved

Aurena Lobby - Work Orders over 90 Days old

  • 23 August 2022
  • 3 replies
  • 152 views

Userlevel 3
Badge +6

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

 

icon

Best answer by Mayura Wasantha 24 August 2022, 07:30

View original

3 replies

Userlevel 7
Badge +15

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

 

 

Userlevel 5
Badge +13

Hi,

 

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

 

Userlevel 3
Badge +6

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

 

Gregg

Reply