Re: Table Qualification Errors

Fri, 08 Sep 2006 11:28:19 -0700

Title: RE: Table Qualification Errors
**

Thanks James.  But the weird thing is, out of the box, the table qualification was ‘7’ = “Responded”.  Before I messed with it, the managers were seeing all surveys that had been responded to, even if it wasn’t their survey to look at.  So that is why I wanted to make the qualification more restrictive…but now it seems as though I’ve messed something up.

 

Thanks,

Lisa

From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3
Sent: Friday, September 08, 2006 1:18 PM
To: [email protected]
Subject: Re: Table Qualification Errors

 

Lisa:

 

That is the key.  If you log in as an 'ordinary' user, you are restricted to looking at your own surveys through workflow (if I remember this correctly.)  I don't remember which bit of workflow does this, but it is there.  Maybe one of the other listers will have more information.

 

James McKenzie

 

 

From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Estrella, Lisa
Sent: Friday, September 08, 2006 11:12 AM
To: [email protected]
Subject: Re: Table Qualification Errors

**

I am running it against the SHR:Survey form.  I’m not sure why it is picking up the assignee field…it has me completely stumped….

 

Thanks,

Lisa

From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3
Sent: Friday, September 08, 2006 1:08 PM
To: [email protected]
Subject: Re: Table Qualification Errors

 

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]>

 

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___

Reply via email to