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?
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?
Hi FRSMDE
you can use below format as in this example.
BR,
Sameera.
Sameera, which version and update is that?
Hi Durette
I have checked this in latest Apps10 UPD11 (Aurena client).
Sameera
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.
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.
Hello Xavier
Sorry but I could not find a solution for my question?
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.