cancel
Showing results for 
Search instead for 
Did you mean: 

How to build custom query based on Note Types?

Neelima_Serinen
Champ in-the-making
Champ in-the-making

In configuration Custom Query module. I don't see any option to select 'Note Type' to build custom query on documents.

Need to provide a custom query that will query all documents on which 'Note' was not added. This query will enable users to add notes on the documents that were skipped.

1 ACCEPTED ANSWER

Justin_Fandl
Content Contributor
Content Contributor

Hey Neelima,

Another option you can look into is leveraging the display column for "Note Count" which is built in functionality for Custom Queries (outside of custom SQL). If you do not see these as a current option to add for display, you will need to enable them by navigating to Document | Display Columns | Enable "Note Columns" Once added you could then have users sort by this and find all the documents without notes.

Hope this helps!

View answer in original post

7 REPLIES 7

Justin, Implemented your suggestion and users are Happy. Thank you!

That is SOOO much easier than what I had in mind. Thanks Justin.

Neelima_Serinen
Champ in-the-making
Champ in-the-making
Transaction Logs has all user history related reports.

Is there option to run transaction logs using Web client?