Can't change query in analytics

[ASA]

If I go to "Analytics Configuration List", open a previously created SQL analytics and click "Edit", I can't see (and change) the SQL query in the analytics.

I'm pretty sure this worked in the past. Can anyone tell what this might be depended on?

If I go via "Create similar analytics" it works but I don't want to create a new one every time.

[pruthvi_t]

Hi @ASA ,

We're not able to replicate the same in the 23.6 version. Can you please provide more details on the savrole of the user facing this issue. If you had found anything in the logs.

Thanks,

[ASA]

Hi Pruthvi,

User has ROLE_ADMIN. Couldn't find anything relevant in the logs.

[rushikeshvartak]

Try restarting server. We faced same issue and it got resolved 

[ASA]

Restarting didn't work. Still can't edit existing analytics query.

[rushikeshvartak · Accepted solution]

Check global configuration under analytics section edit query option is ticked

[ASA]

That's it, thanks!

Is this a new option? Worked on the same instance in the past and we didn't change it.

[Francoisgrenon]

Make sure to replace any <> by != and exclude the word DATE as alias. I fixed many SQL analytics by this