QAID # 22630 NOT Published
Please do NOT provide the article number (QAID) and/or URL of this Knowledgebase article or its contents to external customers, as it is NOT Published and/or * INTERNAL ONLY *.
Question / Problem:
Where do we find the queries used for User Filters in in KAfC 2.0?
Answer / Solution:
User Filters are located in Insight Administration:
- Navigate to User Filters
- Highlight Batch Class
- In Database select MS SQL Server
- Authentication in this case is Windows
- Then the SQL query show
You can get the SQL query from the User Filters windows and paste in MS SQL Manager and run the query against the Kofax Capture database to get the results:
Change the value with “ ” with the values found in WcDataServices.log, search for the log for the value “memberOf” to get Identity from the list
The query should connect and should bring a list of batch classes a user has access to.