Hi James, I'll give that a try...
Lisa On Fri, 8 Sep 2006 13:27:14 -0700, McKenzie, James J C-E LCMC HQISEC/L3 <[EMAIL PROTECTED]> wrote: >Lisa: > >Here is something that I just checked to confirm your settings: > >The following groups have change permission: > >APP-Administrator >APP-Management >APP-Support >Assignee >Submitter > >Public only has view permissions. > >I do have a theory of my own. You stated that you named one of the fields >Assigned To > >Can you either: > >Change the name of that field (in other words remove it from the form and >reinsert it.) >or >Unhide field 4 and then use that one? > >The default name of Assigned To is given to Field id 4 on most forms and >this may be why this filed is being pulled in on your queries. > >James McKenzie >L-3 GSI > > >________________________________ > >From: Action Request System discussion list(ARSList) >[mailto:[EMAIL PROTECTED] On Behalf Of Estrella, Lisa >Sent: Friday, September 08, 2006 1:18 PM >To: [email protected] >Subject: Re: Table Qualification Errors > > >** > >Hi James, > > > >The "allow any user to submit" is grayed out for me. I'll give the rest of >what you said a try... > > > >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 3:13 PM >To: [email protected] >Subject: Re: Table Qualification Errors > > > >Lisa: > >Here is what I think you have to do. Remove the assignee permissions on the >Request ID field (they should not be writing to this field anyway.) > >The public access allows anyone to get to the field and the field is written >by the system. You should have "Allow Any to Submit" checked on this field >which will allow anyone to submit a new request for a survey. > >James Mckenzie >L-3 GSI > > >-----Original Message----- >From: Action Request System discussion list(ARSList) >[mailto:[EMAIL PROTECTED] On Behalf Of Estrella, Lisa >Sent: Friday, September 08, 2006 12:40 PM >To: [email protected] >Subject: Re: Table Qualification Errors > >Thanks for that information Saby. I already have Public in there with view >permissions, so do I need to change the permissions to allow them to write? > >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')))) >> > >__________________________________________________________________________ _____ >UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
