Here is a list we have compiled that can be especially helpful when looking for recent tags made by a user, updates to documents done on a certain day, wildcards, etc.
Any work product applied by a user within a time frame
➡️ Commented by user
ℹ️ Please Note:
Searches would be used in the main search bar.
These are examples, so be careful to make sure you're changing the search to reflect your unique metadata and/or search criteria.
Updates = work product applied to a document. Examples would include tagging, culling, adding notes, adding comments, redacting, etc.
Any work product applied by a specific user within a time frame
How many / which documents did reviewer tag/cull/edit notes on a specific day (timezone is determined by project settings if no time is entered)
updates.user_email:example@email.com AND updates.happened_at:[2017-06-29 TO 2017-06-30]
updates.user_email:example@email.com AND updates.happened_at:[2017-10-10T00:00:00-07:00 TO 2017-10-10T23:59:59-07:00]
☝️ this is an example where time and timezone is specified becoming the whole day based on Pacific Daylight timezone. The format of this syntax is [Year-Month-DayT:MilitaryHour:Minute:Second-Timezone Offset from UTC]. Example Timezone offset from UTC would be -4:00 for EST/-07:00 for PST.
Work Product examples
Tagged by user
What documents were tagged responsive by Joe Cull on March 1, 2021 between 12pm and 2pm Pacific Time?
updates.user_email:joe.cull@logikcull.com AND(updates.new_tags:Responsive AND NOT updates.old_tags:Responsive)AND updates.happened_at:[2021-03-01T12:00:00+07:00 TO 2021-03-01T14:00:00+07:00]
Culled by user
What documents were culled by Joe Cull on March 1, 2021 between 12pm and 2pm Pacific Time?
updates.user_email:joe.cull@logikcull.com AND(updates.new_cull:true AND updates.old_cull:false)AND updates.happened_at:[2021-03-01T12:00:00+07:00 TO 2021-03-01T14:00:00+07:00]
Commented by user
What documents were commented on by Joe Cull on March 1, 2021?
updates.user_email:joe.cull@logikcull.com AND comments.created_at:2021-03-01