Seeing Database Queries

[kasdev]

Hello. I want to see database queries via api but i dont know how to achieve it or if its possible. Anyone has an idea?

[AntonPineiro]

Hi,

I think that is not possible.

Best regards

[Yosi_Neuman · Accepted solution]

Hi @kasdev 

To see the DB statements you need to utilize entities rest api few times,

First with service method group 

For example we can filter the database service to show statements under SQL Queries or Procedures  

Then we can pull the service method group  from the URL

and use it as the entity ID for entities rest api 

The DB statements are under isServiceMethodOf

the id's are again the ID's for entities rest api 

Under detected name you will find the DB statement as shown in the UI

HTH

Yos