Table Qualification Errors

[Estrella, Lisa]

** 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]   __20060125_______________________This posting was submitted with HTML in it___