Skip to main content
Question

Dynamic parameter for date column in SQL query

  • Jul 9, 2024 9:46 AM UTC
  • 6 replies
  • 198 views
Sidekick (Customer)
Forum|alt.badge.img+2
  • MaPl
  • Sidekick (Customer)

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.

6 replies

COVJAMIEB
Hero (Partner)
Forum|alt.badge.img+11
  • COVJAMIEB
  • Hero (Partner)
  • Jul 9, 2024 10:03 AM UTC

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

 

Opinions are my own and not the views of my employer or IFS. Feel free to connect with me - https://www.linkedin.com/in/jamie-baird-29615591/
Sidekick (Customer)
Forum|alt.badge.img+2
  • MaPl
  • Author
  • Sidekick (Customer)
  • Jul 9, 2024 10:05 AM UTC

Hi @COVJAMIEB,

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

COVJAMIEB
Hero (Partner)
Forum|alt.badge.img+11
  • COVJAMIEB
  • Hero (Partner)
  • Jul 9, 2024 10:06 AM UTC

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

 

 

Opinions are my own and not the views of my employer or IFS. Feel free to connect with me - https://www.linkedin.com/in/jamie-baird-29615591/
    COVJAMIEB
    Hero (Partner)
    Forum|alt.badge.img+11
    • COVJAMIEB
    • Hero (Partner)
    • Jul 9, 2024 10:25 AM UTC

    Hi @COVJAMIEB,

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

    Advanced search?

    Opinions are my own and not the views of my employer or IFS. Feel free to connect with me - https://www.linkedin.com/in/jamie-baird-29615591/
    Sidekick (Customer)
    Forum|alt.badge.img+2
    • MaPl
    • Author
    • Sidekick (Customer)
    • Jul 9, 2024 10:29 AM UTC

    Yes. Advanced Search.

    Thanks, it works.

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

    COVJAMIEB
    Hero (Partner)
    Forum|alt.badge.img+11
    • COVJAMIEB
    • Hero (Partner)
    • Jul 9, 2024 10:30 AM UTC

    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.

    Opinions are my own and not the views of my employer or IFS. Feel free to connect with me - https://www.linkedin.com/in/jamie-baird-29615591/
    Terms & ConditionsAccessibility statement