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.
ℹ️ 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' means work product applied to a document. Examples would include tagging, culling, adding notes, and adding comments.
Work product applied by a specific user within a time frame
TO SEARCH FOR: How many or which documents did a reviewer tag/cull/edit notes on a specific day?
WITHOUT ENTERING SPECIFIED TIME ZONE (i.e., timezone is determined by project settings):
updates.user_email:example@email.com AND updates.happened_at:[2017-06-29 TO 2017-06-30]
WITH ENTERING SPECIFIED TIME ZONE:
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 ("T00:00:00") and timezone ("-07:00") is specified to refer to the whole day based on Pacific Daylight timezone.
The format for syntax to specify time frame is:
[Year-Month-DayT:MilitaryHour:Minute:Second-Timezone Offset from UTC]
You can refer to the Timezone Offset chart below to include the specific Timezone Offset from UTC as applicable to the area from which you (or the user you are searching for) are using Logikcull.
TIME ZONE | STANDARD TIME OFFSET | DAYLIGHT SAVINGS TIME OFFSET |
ET | -4:00 | -5:00 |
MT | -5:00 | -6:00 |
CT | -6:00 | -7:00 |
PT | -7:00 | -8:00 |
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]
☝️This example shows how to search for documents that were not previously tagged Responsive before the time specified, but are now tagged Responsive.
Culled by user
What documents were culled by Joe Cull on March 1, 2021 between 12pm and 2pm Eastern 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-04:00 TO 2021-03-01T14:00:00-04:00]
☝️Note how the UTC Timezone Offset in this example is modified for Eastern Time.
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
Notes Added by user
What documents have new notes added by Joe Cull on March 1, 2021 between 12pm and 2pm Central Time?
updates.user_email:joe.cull@logikcull.com AND (updates.new_notes:true AND updates.old_notes:false) AND updates.happened_at:[2021-03-01T12:00:00-06:00 TO 2021-03-01T14:00:00-06:00]