Skip to main content
Question

Query tool

  • Jun 10, 2024 11:20 AM UTC
  • 4 replies
  • 398 views

Patrycja_MM
Sidekick (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

Please see the post below.

 

 


ChriSu
Sidekick (Customer)
Forum|alt.badge.img+3
  • Sidekick (Customer)
  • Jun 11, 2024 9:55 AM UTC

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
Sidekick (Customer)
Forum|alt.badge.img+5
  • Author
  • Sidekick (Customer)
  • Jul 7, 2025 7:36 AM UTC

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+14
  • Hero (Partner)
  • Jul 7, 2025 12:41 PM UTC

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