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.
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:firstname.lastname@example.org AND updates.happened_at:[2017-06-29 TO 2017-06-30]
WITH ENTERING SPECIFIED TIME ZONE:
updates.user_email:email@example.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.
STANDARD TIME OFFSET
DAYLIGHT SAVINGS TIME OFFSET
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:firstname.lastname@example.org 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:email@example.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:firstname.lastname@example.org 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:email@example.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]