Lisa:
Interesting result of what you were trying to do.
James Mckenzie
________________________________
From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Estrella, Lisa
Sent: Tuesday, September 12, 2006 10:38 AM
To: [email protected]
Subject: RESOLVED: Table Qualification Errors
**
I finally figured it out! I had the table sorting on the Case ID field, and also the date modified field. In the SHR:Survey form, the permissions on the "Date Modified" field (fld ID 6) only had assignee on there. So, that is why it kept looking for field ID 4 (Assigned To) in the query. When I added the correct permissions to the Date Modified field, the surveys are displayed.
Thanks to everyone for your help!
Lisa
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, then 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
________________________________
The information contained in this communication may be CONFIDENTIAL and is intended only for the use of the recipient(s) named above. If you are not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication, or any of its contents, is strictly prohibited. If you have received this communication in error, please notify the sender and delete/destroy the original message and any copy of it from your computer or paper files.
__20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___
__20060125_______________________This posting was submitted with HTML in it___
