2. ASPRunnerPro General questions
  3. advanced security settings question
This topic is locked

advanced security settings question

 		5/5/2014 6:12:13 PM
ASPRunnerPro General questions
M
 mfred author

I have used the advanced security settings many times to control what people can see. But a client has a new twist. I have a document ordering system where the document visibility is based on the document and user division. Easy enough through the advanced settings. But the client wants to be able to save time by selecting multiple divisions for a document. So the division field in the document table will have multiple divisions. Is there a way to adjust the advanced security settings so that the visibility is based on whether the matching text is anywhere in the field? Here is an example.
User has division B in the division field.

One document has division A, B and C in the division field.

Another document has A and C in the division field.

The user can only see the first document because B is included in the divisions entered into the documents division field.
admin 5/6/2014

No, unfortunately ASPRunnerPro doesn't have such built-in functionality.
It is possible to implement it manually though. Instead of using Advanced Security you can use Dynamic SQL Query approach. You can modify one of the following examples to build a query that selects all documents that have user's division as a part of document division field:

http://xlinesoft.com/asprunnerpro/docs/dynamic_sql_query.htm
For instance here is the sample query for the case when user's division is B:

select * from documents where division like '%,B,%' or division like '%B,%' or division like '%,B%'
G
 		gonzalosb 5/14/2014

hi mfred,

you can do this via CheckBbox on LookUP wizard


after that a function "IF" to display to users depending on data selected as admin explain it on his answer on querys.
or you can use "Hide base on logged user level"
hope this help you.

if you found an other solution please posted here.