OnDemand Users Group

Support Forums => Report Indexing => Topic started by: LAZOSA on March 06, 2014, 10:12:08 AM

Title: SQL COMMANDS - QUERY RESTRICTION (massively changes)
Post by: LAZOSA on March 06, 2014, 10:12:08 AM
Hi !!
how it is possible to make changes massively to all Query restrictions (e.g. the load_date >16133 to load_date >16140).
Thank you
Lazos Antonio
Title: Re: SQL COMMANDS - QUERY RESTRICTION (massively changes)
Post by: Justin Derrick on March 06, 2014, 11:58:40 AM
Generally speaking, no.  This is especially complicated because field names may be different between Application Groups, or the definitions of those types might be different (date/time vs. date).

You may be able to use arsxml to apply a standard query restriction across specific AGs:

Let us know how it turns out, and please remember to report back to us with the solution if you find it!

-JD.