Skip to main content
Kofax

Filter data in KAFTA to display data pertaining to the current user logged into Insight

Article # 3040741 - Page views: 13

Issue

How to filter data in KAFTA to display data pertaining to the current user logged into Insight?=

Solution

This example uses the Job Resource Completed record that is used in Administration | Jobs link in KAFTA (“All completed jobs”). Changes to the KAFTA project are not supported, therefore, make a copy of the project first and alter the copied project.

Steps:

1. In the Admin module, create a new User Filter.

     a. Set the Name, Source (TotalAgility database), Database (SQL Server), and Authentication (HTTP Request if using out-of-box KAFTA project or your customer auth method).
 

     b. For the query (this is an example only - your database name may differ):

SELECT B.RESOURCE_NAME FROM TOTALAGILITY.LIVE.AW_LOGGEDON_USER A INNER JOIN TOTALAGILITY.LIVE.AW_RESOURCE B ON A.RESOURCE_ID = B.RESOURCE_ID WHERE SESSION_ID = CONVERT(binary(16),'<session_id>',2)

     c. Save

2. In Studio, copy the ‘Job Resource Completed’ record to a new record
3. Set the copied record’s ‘Resource’ field’s Filter property to use the filter created in Step 1 above
4. Create a new View to use this copied Record in Step 2.
5. Add links to the copied project as appropriate / update KTA navigation as needed
6. Test

 

Level of Complexity 

Easy

 

Applies to  

Product Version Build Environment Hardware
Kofax Analytics for Total Agility All      

References

Add any references to other internal or external articles

 

Article # 3040741
  • Was this article helpful?