Skip to main content

Hi,

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.

Hi @MaPl where are you looking to execute this in IFs Cloud?

 

Hi @COVJAMIEB,

try to create a SQL query in Labor Load Details (LU Name: LaborOperationLoad).

If it is relating to an advanced search you can execute this in the following way, my example is below.

 

 

Hi @COVJAMIEB,

try to create a SQL query in Labor Load Details (LU Name: LaborOperationLoad).

Advanced search?

Yes. Advanced Search.

Thanks, it works.

Is there like a “cheat sheet” with all available parameters for advanced searches.

If 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.

Reply


Terms & ConditionsCookie settings