WQL to SQL

This SQL Query can be used to see how WQL is converted to SQL by SMS for collections.

Select
Collections.SiteID
, Collections.CollectionName
, Collection_Rules.QueryName
, Collection_Rules_SQL.WQL
, Collection_Rules_SQL.SQL
 
From Collections,Collection_Rules, Collection_Rules_SQL
Where
     Collections.CollectionID = Collection_Rules.CollectionID
AND  Collections.CollectionID = Collection_Rules_SQL.CollectionID

Leave a Reply

Your email address will not be published. Required fields are marked *