Skip to main content
Solved

Aurena Advanced Search & Dates

  • April 5, 2022
  • 8 replies
  • 935 views
L
Hero (Customer)
Forum|alt.badge.img+9

We are running Apps 10 Update 11

In the Aurena interface is there a way to search for a date that is say 3 days in the future? An example would be in Inventory Part In Stock and we want to find any items that expire in the next 3 days.

In IEE I would use the advances/SQL query and use something like EXPIRATION_DATE <= trunc(sysdate)+3

I’m trying to figure out how to replicate what we currently do in IEE in Aurena. Not that we are migrating to the cloud version immediately, but it’s going to happen sooner or later.

Best answer by matt.watters

Try this, using the Y/M/W/D date search attributes for a Range.

In the screenshot below I will find all records for which the expiration date falls between today and the next 45 days.

 

S

8 replies

S
Superhero (Employee)
Forum|alt.badge.img+14

Hi @Lane,

You can get the same result you wanted as shown in the below screen print. You need to click on the Question mark and that will give you the conditions that you need filter the results. 

Let me know if you need further assistance.

 

Kind regards,

Shanuka.

S
Superhero (Employee)
Forum|alt.badge.img+14

Hello again :),

Additionally you can turn on by clicking ‘Advanced’ as shown below.

 

Kind regards,

Shanuka.

matt.watters
Ultimate Hero (Partner)
Forum|alt.badge.img+26
  • matt.watters
  • Ultimate Hero (Partner)
  • Answer
  • April 5, 2022

Try this, using the Y/M/W/D date search attributes for a Range.

In the screenshot below I will find all records for which the expiration date falls between today and the next 45 days.

 

If a response resolves your issue, please use "Best Answer" so that the thread can be closed and others can find solutions more easily. Regards - Matt
L
L
Hero (Customer)
Forum|alt.badge.img+9
  • Lane
  • Author
  • Hero (Customer)
  • April 5, 2022

Thanks @matt.watters that was exactly what I was looking for. The documentation really needs to be upgraded for Aurena.

B
Do Gooder (Customer)
Forum|alt.badge.img+6
  • BGunn
  • Do Gooder (Customer)
  • August 31, 2023

@matt.watters What do the + - * options do ?  Thanks

matt.watters
Ultimate Hero (Partner)
Forum|alt.badge.img+26
  • matt.watters
  • Ultimate Hero (Partner)
  • August 31, 2023

@matt.watters What do the + - * options do ?  Thanks

I assume you can do math in the fields, such as #TODAY#+60 or “#START OF THIS MONTH#-50. Never worked with the *, possibly a multiplier?

If a response resolves your issue, please use "Best Answer" so that the thread can be closed and others can find solutions more easily. Regards - Matt
AltRuslaC
Do Gooder (Partner)
Forum|alt.badge.img+2
  • AltRuslaC
  • Do Gooder (Partner)
  • October 3, 2024

I tried variant (see screenshort). It not working

Only the option works

I tried the same thing W, Y, M ….

How does the filter “In range” work? What am I doing wrong?

barner
Sidekick (Customer)
Forum|alt.badge.img+7
  • barner
  • Sidekick (Customer)
  • April 29, 2025

Hi ​@AltRuslaC , 

Did you get any explenation on how the rage works? It would be nice to get it.

For me it looks like Y/M/W/D works like counting “from today”. I have search like at the picture below and 5M is converted to a date 5 months from today in Request URL.

I tried to do as you did (#START_OF_LAST_YEAR# + 5M) but it failed in application

 

Let me know if you have more information.

Br. Barbara

Barbara Aasbrein
Terms & ConditionsCookie settingsAccessibility statement