Lisa, Sure you have done this, but just wanted to be sure that the public permissions are set on the SHR:Survey form. If this is the case, can you try clearing out the cache files on your desktop and see if that helps. When clearing out the cache files make sure you close all instances of the user tool.
If you have public view permissions on the request id field, then the server ignores any other permissions on the field. The Request ID is a system maintained/generated field, so nobody need have write permissions on this field. Try clearing out the cache files, it maybe that the local cache was not updated when you made the changes to the form and tested these out. Let me know how you get along. Regards, Saby --- "Estrella, Lisa" <[EMAIL PROTECTED]> wrote: > 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 > === message truncated === __________________________________________________ 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
