Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

Global Configuration > Analytics> Show Query and Edit Query is disabled by default

IDAM09
New Contributor II
New Contributor II

Hi,

The global configuration under analytics section show query and edit query option is unchecked by default. Is there any risk by enabling this option in Production instance?

6 REPLIES 6

rushikeshvartak
All-Star
All-Star

There is no risk. You can enable it . As during saving analytics it will popup columns / filters to be selected hence you can enable 


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

Thanks for your response @rushikeshvartak .

I didn't quiet get this " As during saving analytics it will popup columns / filters to be selected hence you can enable ". Could you please elaborate?

When create or update existing analytics report before saving report it asks columns to be selected hence clicking on show query does not harm anything 


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

Thanks. How about edit query? Does enabling this feature in production lead to any risk?

Same answer.

show query - will help to see SQL query

edit query - in case of query updates it will help you 


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

PremMahadikar
Valued Contributor
Valued Contributor

Hi @IDAM09 ,

To be more clear -

Once you enable the below:

Show Query:

PremMahadikar_2-1716797570837.png

What will happen if you disable it? You don't see the query in the analytics once its created.

PremMahadikar_1-1716797511436.png

Edit Query:

PremMahadikar_3-1716797582972.png

What will happen if you disable it? Even though you click on 'Edit' -> You can't edit the query. (Below screenshot, you could notice - Query is greyed out and couldn't be edited)

PremMahadikar_4-1716797747410.png

For sure, no risk and always good to enable both the configuration.

 

If this helps , Please consider selecting Accept As Solution and hit Kudos