Skip to main content
Question

Query tool


Patrycja_MM
Do Gooder (Customer)
Forum|alt.badge.img+5

Hello,

Why is there no SQL query tool functionality in Cloud?
This allowed us to quickly find user errors or check a quick report.
Will query tool be added in Cloud?

 

4 replies

Technical Outlaws
Hero (Employee)
Forum|alt.badge.img+11

ChriSu
Sidekick (Customer)
Forum|alt.badge.img+3
  • Sidekick (Customer)
  • 8 replies
  • June 11, 2024

Hi!

Query Designer is available in IFS Cloud an should fit your needs..

 

 

You can use other powerfull tools like DBeaver as well. ;-)

 

Kind regards, 

Christian


Patrycja_MM
Do Gooder (Customer)
Forum|alt.badge.img+5
  • Author
  • Do Gooder (Customer)
  • 20 replies
  • July 7, 2025

Query Designer does not work like the query creation field in IFS 9, here the action is limited.

It will make our work difficult in company. Why was it changed? :(


InfFilipV
Hero (Partner)
Forum|alt.badge.img+12
  • Hero (Partner)
  • 225 replies
  • July 7, 2025

Hi,
yes, work with IFS Cloud is complicated…

  • Query Designer
    • Only entities with configured RowSecurity are allowed to use
    • only few lines preview…
    • limitated joins
  • Quick Reports
    • no table access

For same functionality you need to use database directly:

  • On Premise
    • use direct database access
  • IFS Cloud SaaS
    • purchase VPN tunnel
    • ask for DB TNS via CSM
    • request IFSREADONLY credentials from CSM

Reply


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