History as Attribute in Search Criteria
I want to create saved search to check user activity for Parts class but where is History attribute in Search Criteria? Is exist any way to activate it
It is not possible to have History attributes however if you want to track activities of user on a particular class or object, you can write a simple sdk program or scripts.
@Steve Jones
This is user activity report only for logins count and login duration management here want to see what and when was modified by the single user.
@Arif
So far as I see SDK is quite useless the IQuery method is just Search wit Search Attribute but I can give it a try maybe it can accept HISTORY attributes.
setCriteria for IQuery is succeeded for base ID 1002 and [Title Block.Description]
But for History:
Error code : 60029
Error message : Attribute “History.User” not found.
Root Cause exception : com.agile.util.exception.CMAppException: Attribute “History.User” not found.
Same if I try to use Base ID insted of name:
Error code : 60029
Error message : Attribute “1128” not found.
Root Cause exception : com.agile.util.exception.CMAppException: Attribute “1128” not found.
Which means SDK IQuerry implementation is very sloppy and do not give any real access to data somehow this is just a little more advanced standard search.
I solved my problem with SQL ITEM_HISTORY query, this is strange that agile contain good history details in SQL table but not exposed by the system.