Is there a way to compare BAQ across environments to see if there is any difference? We uploaded our DB to Kinetic cloud a few months ago and need to check if any queries changed in our live environment.
There’s the pseudo-SQL on the General tab if you want a glance at it.
If you want something more automated, you’d have to run a diff on records from the nearly 2 dozen ice.Query… tables in the system.
Thank you John. That confirms what I am seeing as well. It appears the DB design of the system tables for BAQ break out every single little aspect of the BAQ into a separate table.