Michelle:
It is in the public space, either 536870920 or 536870922.
Lisa sent me that information earlier.
James McKenzie
L-3 GSI
-----Original Message-----
From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Lucero, Michelle - IST contractor
Sent: Friday, September 08, 2006 1:02 PM
To: [email protected]
Subject: Re: Table Qualification Errors
Hi, Lisa:
Sorry to come on this so late.
What is the field ID of 'Assignee_Manager_Login'?
Michelle
-----Original Message-----
From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Estrella, Lisa
Sent: Friday, September 08, 2006 2:58 PM
To: [email protected]
Subject: Re: Table Qualification Errors
Hi Saby,
I tried giving public change permissions and it still queried the field ID 4 (Assignee). I also tried taking the assignee permission completely out and left public in there. It still queried field ID 4....
Thanks,
Lisa
-----Original Message-----
From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Sabyson Fernandes
Sent: Friday, September 08, 2006 2:29 PM
To: [email protected]
Subject: Re: Table Qualification Errors
Lisa,
The T275.C4 is from the permission on the Request Id (field id 1) on the SHR:Survey form. From one of your previous emails you said you have Assignee with change permissions set on the request id. When you set the permission on the Request ID with Assignee and not public, the AR Server includes the 'Assigned To' field as part of the query.
When you run the query as an Administrator user, they have rights to all requests so the AR Server does not add the Assigned To field to the query issued to the database and you see all records in the form.
If you reset the permissions to the request id field to public on the SHR:Survey form and re-run the query you will see that the query issued for a non-admin user is the same as for an admin user.
Hope this helps.
Kind regards,
Saby
--- "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,C23000
> 0007 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]>
>
>
>
>
>
________________________________________________________________________
_______
> UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
________________________________________________________________________
_______
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
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.
________________________________________________________________________
_______
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
