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
Recent Comments