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'))))
>
