| **
James, It did the same query again: > /* Fri Sep 08 2006 15:25:24.5010
*/SELECT
T275.C1,C2,C4,T275.C1,C6,C230000007,C230000008,C536870920,C536870921,C230000007,C6
FROM T275 WHERE ((T275.C4 = N'lestrell') AND ((T275.C7 = 1) AND ((N'lestrell' =
T275.C536870922) OR (N'Approval Admin APP-Support APP-Management Thanks, Lisa From: Action Request
System discussion list(ARSList) [mailto: 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: 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 -----Original
Message----- 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,
-----Original
Message----- 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, ---
"Estrella, Lisa" <[EMAIL PROTECTED]> wrote:
> Hi,
__________________________________________________
________________________________________________________________________
_______________________________________________________________________________
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. 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. |
Title: RE: Table Qualification Errors
- Re: Table Qualification Errors McKenzie, James J C-E LCMC HQISEC/L3
- Re: Table Qualification Errors Sabyson Fernandes
- Re: Table Qualification Errors Estrella, Lisa
- Re: Table Qualification Errors Estrella, Lisa
- Re: Table Qualification Erro... Sabyson Fernandes
- Re: Table Qualification ... Estrella, Lisa
- Re: Table Qualification Errors Lisa Estrella
- Re: Table Qualification Errors Lisa Estrella
- Re: Table Qualification Errors McKenzie, James J C-E LCMC HQISEC/L3
- Re: Table Qualification Errors Estrella, Lisa
