<< Click to Display Table of Contents >> Navigation:  User rights management > General filter applied to all users

General filter applied to all users

General filter applied to all users

You can set a SQL condition that is applied indiscriminately to all the queries and for al the users. A simple case is when you decide that a given set of premarked documents simply dont appear in query results.

Note that the condition would apply only to the results of a query in the main grid and not to parents and children displayed in the hierarchical views, normally on the right.

To apply the condition, in the file in \program files\dbworks stand alone\webviewer\WebViewerOptions.txt add the line

condition "< sql condition >"

as in

condition "T = 'P'"

which would limit the results only to parts.

If you intend to set a condition that includes the logical operator OR, you should enclose the condition in parantheses as in the following example:

condition "(T='P' OR T='A')"