Hi Saby, I created a test display only form with the table on it. It works fine. I think I will have to recreate the table on the management console. Thanks for your help!
Lisa -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sabyson Fernandes Sent: Friday, September 08, 2006 4:37 PM To: [email protected] Subject: Re: Table Qualification Errors 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 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
