Skip to main content
Solved

Aurena Lobby - Work Orders over 90 Days old


Forum|alt.badge.img+7

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

 

Best answer by Mayura Wasantha

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

 

 

View original
Did this topic help you find an answer to your question?

3 replies

Mayura Wasantha
Superhero (Employee)
Forum|alt.badge.img+18
  • Superhero (Employee)
  • 474 replies
  • Answer
  • August 24, 2022

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

 

 


EqeRobertK
Superhero (Partner)
Forum|alt.badge.img+15
  • Superhero (Partner)
  • 231 replies
  • August 24, 2022

Hi,

 

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

 


Forum|alt.badge.img+7
  • Author
  • Hero (Partner)
  • 21 replies
  • August 24, 2022

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

 

Gregg


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings