Lisa:
The question is why is C4 (Assignee) being picked up on the non-administrator query. What form are you running this query against?
James McKenzie
________________________________
From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Estrella, Lisa
Sent: Friday, September 08, 2006 11:01 AM
To: [email protected]
Subject: Re: Table Qualification Errors
**
Hi,
Change permission: APP-Administrator, APP-Management, APP-Support, Assignee, & Submitter
View permission: Public
Thanks,
Lisa
________________________________
From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Frank Caruso
Sent: Friday, September 08, 2006 12:56 PM
To: [email protected]
Subject: Re: Table Qualification Errors
** What are the permissions on the field with id 1 (Request ID)?
On 9/8/06, Estrella, Lisa <[EMAIL PROTECTED] > wrote:
**
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] <mailto:[EMAIL PROTECTED]>
__20060125_______________________This posting was submitted with HTML in it___
