Lisa, This is really strange.
Can you send a def file of the SHR:Survey form please. It may help us to spot something. Also if you can create a display only form with the same table as what you have on the console for viewing surveys it would help. Saby --- "Estrella, Lisa" <[EMAIL PROTECTED]> wrote: > Hi Saby, > > I removed all the permissions from SHR:Survey field > 1 except for public, > then I cleared my cache and tried everything again. > It still is looking > for field ID 4... > > Frustrating... > > > Thanks, > Lisa > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Sabyson > Fernandes > Sent: Friday, September 08, 2006 3:31 PM > To: [email protected] > Subject: Re: Table Qualification Errors > > 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 > === 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
