+1Hi,
I’m new in the community and haven’t found any topic covering my request.
In IFS 10 we had option to create a SQL query with dynamic date parameters like WORK_DAY between trunc(to_date( '#TODAY#', 'YYYY-MM-DD' )) and trunc(to_date( '#TODAY#', 'YYYY-MM-DD' )) + 10
How can I perform such a query in IFS Cloud?
Thanks a lot for your reply.
+11Hi
+11If it is relating to an advanced search you can execute this in the following way, my example is below.
+11Hi
try to create a SQL query in Labor Load Details (LU Name: LaborOperationLoad).
Advanced search?
+1Yes. Advanced Search.
Thanks, it works.
Is there like a “cheat sheet” with all available parameters for advanced searches.
+11If it is relating to an advanced search you can execute this in the following way, my example is below.
You can use this to query the date range.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
