**__20060125_______________________This posting was submitted with HTML in it___Hi,
I am trying to troubleshoot a problem I am having with a table qualification. I want the table to list the customer satisfaction surveys that have been responded to. I added this qualification to the table properties so that I could "filter" the list:
( '7' = "Responded") AND (($ USER $ = 'Assignee_Manager_Login') OR (($ GROUPS $ LIKE (( "%" + 'Assigned Group') + "%" ))))
Here's the problem: When I am logged in with admin rights, the surveys are listed. But, if I am logged in as a normal user (management role) then the surveys won't show (I have made sure that there is at least one survey that should be showing based on the criteria above).
When I ran the SQL log, I found that when I am logged in as admin then it is using the correct query:
*/SELECT T275.C1,T275.C1,C230000007,C230000008,C536870920,C536870921,C6,C6,C230000007 FROM T275 WHERE ((T275.C7 = 1) AND ((N'Administrator Approval Admin APP-Administrator Problem Management Remedy Support' LIKE ((N'%' + T275.C536870920) + N'%')) OR (T275.C536870922 = N'remdev')))
But, when I am logged in as the manager then it adds an additional "field" to the query (T275.C4):
*/SELECT T275.C1,C2,C4,T275.C1,C230000007,C230000008,C536870920,C536870921,C6,C6,C230000007 FROM T275 WHERE ((T275.C4 = N'lestrell') AND ((T275.C7 = 1) AND ((N'Approval Admin APP-Support APP-Management Remedy Support Web/Intranet' LIKE ((N'%' + T275.C536870920) + N'%')) OR (T275.C536870922 = N'lestrell'))))
Has any one else ever experienced this? Any help/advise would be greatly appreciated!
Thanks,
Lisa
ARS 6.3 patch 17
HD 6.0
CM 6.0
MS SQL
Win 2003 Server
_______________________________
Lisa Estrella
Remedy Administrator/Developer
222 Merchandise Mart Ste 900, Chicago, IL 60654
P: 312.894.7331
F: 312.894.7050
[EMAIL PROTECTED]
--
Frank Caruso
Specific Integration, Inc.
Senior Remedy Engineer
www.specificintegration.com
703-376-1249 __20060125_______________________This posting was submitted with HTML in it___
