Skip to main content
Question

Advanced search


FRSMDE
Do Gooder (Employee)
Forum|alt.badge.img+6
  • Do Gooder (Employee)
  • 17 replies

Hello

In the enterprise explorer in the advanced search we could use SQL Code like the attached example. What is the correct syntax to use it in Aurena?

This topic has been closed for comments

7 replies

Forum|alt.badge.img+4

Hi FRSMDE

 

you can use below format as in this example.

 

BR,

Sameera.


durette
Superhero (Customer)
Forum|alt.badge.img+19
  • Superhero (Customer)
  • 525 replies
  • May 28, 2021

Sameera, which version and update is that?


Forum|alt.badge.img+4

Hi Durette

 

I have checked this in latest Apps10 UPD11 (Aurena client).

 

Sameera


Forum|alt.badge.img+3
  • Do Gooder (Customer)
  • 5 replies
  • June 7, 2021
Prabhath Sameera wrote:

 

 

Thank you for your reply Sameera.
I think the problem that FRSMDE is facing is similar to the problem described in this question:

There is no problem for your particular case with ‘Purchase Orders’ because you can use the ‘Purchase Order Lines’ function to search for orders which, for example, has released or confirmed lines.
But if you consider FRSMDE’s example with suppliers and addresses, we have the problem that there is no function with which we can, for example, search for suppliers which have a certain zip code. In the enterprise explorer we solved this problem by making a sub-select in the advanced search. Unfortunately this is no longer possible in Aurena.


Forum|alt.badge.img+20
FRSMDE wrote:

Hello

In the enterprise explorer in the advanced search we could use SQL Code like the attached example. What is the correct syntax to use it in Aurena?

 

Hope this helps you.


FRSMDE
Do Gooder (Employee)
Forum|alt.badge.img+6
  • Author
  • Do Gooder (Employee)
  • 17 replies
  • June 14, 2021

Hello Xavier

Sorry but I could not find a solution for my question?


Forum|alt.badge.img+20

@FRSMDE ,
 

I’m sorry but As per my understanding,  above attachment explain scope of quering in IFS Aurena and system is not support any further at the moment. 


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