Hi, Checking through my SQL profiler, I can see that when I open Overview Console, the following statement is used.
SELECT T943.C1,C1000000000,C7,C1000000164,C179,C230000009,C301626500,C1000000161,C1000000218,C3,C1000000019,C1000000018 FROM T943 WHERE (((T943.C112 LIKE N'%;''mhole'';%') OR (T943.C112 LIKE N'%;0;%') OR (T943.C112 LIKE N'%;-1098;%') OR (T943.C112 LIKE N'%;-20000;%') OR (T943.C112 LIKE N'%;-20026;%') OR (T943.C112 LIKE N'%;803;%') OR (T943.C112 LIKE N'%;804;%') OR (T943.C112 LIKE N'%; 20061;%') OR (T943.C112 LIKE N'%;20313;%') OR (T943.C112 LIKE N'%; 20316;%') OR (T943.C112 LIKE N'%;13006;%') OR (T943.C112 LIKE N'%; 20050;%') OR (T943.C112 LIKE N'%;20055;%') OR (T943.C112 LIKE N'%; 20210;%') OR (T943.C112 LIKE N'%;20211;%') OR (T943.C112 LIKE N'%; 20221;%') OR (T943.C112 LIKE N'%;20315;%') OR (T943.C112 LIKE N'%; 20017;%') OR (T943.C112 LIKE N'%;20032;%') OR (T943.C112 LIKE N'%; 20026;%') OR (T943.C112 LIKE N'%;20000;%') OR (T943.C112 LIKE N'%; 20003;%') OR (T943.C112 LIKE N'%;20012;%') OR (T943.C112 LIKE N'%; 20007;%') OR (T943.C112 LIKE N'%;20301;%') OR (T943.C112 LIKE N'%; 20214;%') OR (T943.C112 LIKE N'%;20213;%') OR (T943.C112 LIKE N'%; 20218;%') OR (T943.C112 LIKE N'%;1000000111;%') OR (T943.C112 LIKE N'%; 1000000112;%') OR (T943.C112 LIKE N'%;1000000001;%') OR (T943.C112 LIKE N'%;1000000096;%') OR (T943.C112 LIKE N'%;1000000141;%') OR (T943.C112 LIKE N'%;1000000099;%') OR (T943.C112 LIKE N'%; 1000000104;%') OR (T943.C112 LIKE N'%;1000000102;%') OR (T943.C112 LIKE N'%;1000000121;%') OR (T943.C112 LIKE N'%;20217;%')) AND (((T943.C230000009 = N'ASTCIUNAVAILABILITY') AND ((T943.C1000000079 = N'SGP000000000130') OR (T943.C1000000079 = N'SGP000000000131') OR (T943.C1000000079 = N'SGP000000000115') OR (T943.C1000000079 = N'SGP000000000177') OR (T943.C1000000079 = N'SGP000000000118') OR (T943.C1000000079 = N'SGP000000000123') OR (T943.C1000000079 = N'SGP000000000121') OR (T943.C1000000079 = N'SGP000000000140'))) OR ((T943.C230000009 = N'MAINCHANGE') AND ((T943.C1000000427 = N'SGP000000000130') OR (T943.C1000000427 = N'SGP000000000131') OR (T943.C1000000427 = N'SGP000000000115') OR (T943.C1000000427 = N'SGP000000000177') OR (T943.C1000000427 = N'SGP000000000118') OR (T943.C1000000427 = N'SGP000000000123') OR (T943.C1000000427 = N'SGP000000000121') OR (T943.C1000000427 = N'SGP000000000140')) AND ((T943.C7 = 1) OR (T943.C7 = 2) OR (T943.C7 = 3) OR (T943.C7 = 4) OR (T943.C7 = 5) OR (T943.C7 = 6) OR (T943.C7 = 7) OR (T943.C7 = 8) OR (T943.C7 = 9))) OR ((T943.C230000009 = N'MAINHELPDESK') AND ((T943.C1000000079 = N'SGP000000000130') OR (T943.C1000000079 = N'SGP000000000131') OR (T943.C1000000079 = N'SGP000000000115') OR (T943.C1000000079 = N'SGP000000000177') OR (T943.C1000000079 = N'SGP000000000118') OR (T943.C1000000079 = N'SGP000000000123') OR (T943.C1000000079 = N'SGP000000000121') OR (T943.C1000000079 = N'SGP000000000140')) AND ((T943.C7 = 0) OR (T943.C7 = 1) OR (T943.C7 = 2) OR (T943.C7 = 3))) OR ((T943.C230000009 = N'ASTPUREQUISITION') AND ((T943.C1000000079 = N'SGP000000000130') OR (T943.C1000000079 = N'SGP000000000131') OR (T943.C1000000079 = N'SGP000000000115') OR (T943.C1000000079 = N'SGP000000000177') OR (T943.C1000000079 = N'SGP000000000118') OR (T943.C1000000079 = N'SGP000000000123') OR (T943.C1000000079 = N'SGP000000000121') OR (T943.C1000000079 = N'SGP000000000140'))) OR ((T943.C230000009 = N'MAINKNOWLEDGEDATABASE') AND ((T943.C1000000079 = N'SGP000000000130') OR (T943.C1000000079 = N'SGP000000000131') OR (T943.C1000000079 = N'SGP000000000115') OR (T943.C1000000079 = N'SGP000000000177') OR (T943.C1000000079 = N'SGP000000000118') OR (T943.C1000000079 = N'SGP000000000123') OR (T943.C1000000079 = N'SGP000000000121') OR (T943.C1000000079 = N'SGP000000000140')) AND (T943.C7 = 4)) OR ((T943.C230000009 = N'MAINKNOWNERROR') AND ((T943.C1000000079 = N'SGP000000000130') OR (T943.C1000000079 = N'SGP000000000131') OR (T943.C1000000079 = N'SGP000000000115') OR (T943.C1000000079 = N'SGP000000000177') OR (T943.C1000000079 = N'SGP000000000118') OR (T943.C1000000079 = N'SGP000000000123') OR (T943.C1000000079 = N'SGP000000000121') OR (T943.C1000000079 = N'SGP000000000140')) AND ((T943.C7 = 0) OR (T943.C7 = 1) OR (T943.C7 = 2))) OR ((T943.C230000009 = N'MAINPROBLEM') AND ((T943.C1000000079 = N'SGP000000000130') OR (T943.C1000000079 = N'SGP000000000131') OR (T943.C1000000079 = N'SGP000000000115') OR (T943.C1000000079 = N'SGP000000000177') OR (T943.C1000000079 = N'SGP000000000118') OR (T943.C1000000079 = N'SGP000000000123') OR (T943.C1000000079 = N'SGP000000000121') OR (T943.C1000000079 = N'SGP000000000140')) AND ((T943.C7 = 0) OR (T943.C7 = 1) OR (T943.C7 = 2) OR (T943.C7 = 3) OR (T943.C7 = 4) OR (T943.C7 = 5))))) ORDER BY 8 ASC, 1 ASC THis only happens when the support staff does have Unrestricted Access checked. When it is checked, the LIKE qualifications do not appear. Where can I find the workflow that does this? I've been searching and cannot find it. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
