[untagged]
Group=Search by Attributes (Personal Notes)
Name=Untagged Documents
Name_2052=无标签笔记
Name_1028=無標籤筆記
SQL=document_guid not in (select distinct document_guid from wiz_document_tag) and datetime(DT_MODIFIED, '+10 days') > datetime('now')
SortBy=DateCreated
SortOrder=Desc
PersonalNotesOnly=1


[contains_attachment]
Group=Search by Attributes (Personal Notes)
Name=Contains attachment
Name_2052=包含附件
Name_1028=包含附件
SQL= (document_attachement_count > 0) order by dt_modified desc limit 0, 100
SortBy=DateCreated
SortOrder=Desc
PersonalNotesOnly=1

[1_star]
Group=Search by Attributes (Personal Notes)
Name=1 star
Name_2052=一星
Name_1028=一星
SQL=document_guid in (select distinct document_guid from wiz_document_param where param_name='RATE' and param_value='1')
SortBy=DateCreated
SortOrder=Desc
PersonalNotesOnly=1


[2_stars]
Group=Search by Attributes (Personal Notes)
Name=2 stars
Name_2052=两星
Name_1028=兩星
SQL=document_guid in (select distinct document_guid from wiz_document_param where param_name='RATE' and param_value='2')
SortBy=DateCreated
SortOrder=Desc
PersonalNotesOnly=1


[3_stars]
Group=Search by Attributes (Personal Notes)
Name=3 stars
Name_2052=三星
Name_1028=三星
SQL=document_guid in (select distinct document_guid from wiz_document_param where param_name='RATE' and param_value='3')
SortBy=DateCreated
SortOrder=Desc
PersonalNotesOnly=1

[4_stars]
Group=Search by Attributes (Personal Notes)
Name=4 stars
Name_2052=四星
Name_1028=四星
SQL=document_guid in (select distinct document_guid from wiz_document_param where param_name='RATE' and param_value='4')
SortBy=DateCreated
SortOrder=Desc
PersonalNotesOnly=1

[5_stars]
Group=Search by Attributes (Personal Notes)
Name=5 stars
Name_2052=五星
Name_1028=五星
SQL=document_guid in (select distinct document_guid from wiz_document_param where param_name='RATE' and param_value='5')
SortBy=DateCreated
SortOrder=Desc
PersonalNotesOnly=1



[created_since_today]
Group=Search by Date Created
Name=Created since Today
Name_2052=今日
Name_1028=今日
SQL=dt_created > datetime('now','start of day')
SortBy=DateCreated
SortOrder=Desc



[created_since_yesterday]
Group=Search by Date Created
Name=Created since Yesterday
Name_2052=昨天至今
Name_1028=昨天至今
SQL=dt_created > datetime('now', '-1 day','start of day')
SortBy=DateCreated
SortOrder=Desc

[created_since_the_day_before_yesterday]
Group=Search by Date Created
Name=Created since the day before yesterday
Name_2052=前天至今
Name_1028=前天至今
SQL=dt_created > datetime('now', '-2 day','start of day')
SortBy=DateCreated
SortOrder=Desc


[created_since_one_week]
Group=Search by Date Created
Name=Created since one week
Name_2052=一周内
Name_1028=一周內
SQL=dt_created > datetime('now', '-7 day','start of day')
SortBy=DateCreated
SortOrder=Desc



[created_since_one_month]
Group=Search by Date Created
Name=Created since one month
Name_2052=一月内
Name_1028=一月內
SQL=dt_created > datetime('now', '-31 day','start of day')
SortBy=DateCreated
SortOrder=Desc




[modified_since_today]
Group=Search by Date Modified
Name=Modified since Today
Name_2052=今日
Name_1028=今日
SQL=dt_data_modified > datetime('now','start of day') and datetime(dt_data_modified, '-12 hour') > datetime(dt_created)
SortBy=DateModified
SortOrder=Desc



[modified_since_yesterday]
Group=Search by Date Modified
Name=Modified since Yesterday
Name_2052=昨天至今
Name_1028=昨天至今
SQL=dt_data_modified > datetime('now', '-1 day','start of day') and datetime(dt_data_modified, '-12 hour') > datetime(dt_created)
SortBy=DateModified
SortOrder=Desc

[modified_since_the_day_before_yesterday]
Group=Search by Date Modified
Name=Modified since the day before yesterday
Name_2052=前天至今
Name_1028=前天至今
SQL=dt_data_modified > datetime('now', '-2 day','start of day') and datetime(dt_data_modified, '-12 hour') > datetime(dt_created)
SortBy=DateModified
SortOrder=Desc


[modified_since_one_week]
Group=Search by Date Modified
Name=Modified since one week
Name_2052=一周内
Name_1028=一周內
SQL=dt_data_modified > datetime('now', '-7 day','start of day') and datetime(dt_data_modified, '-12 hour') > datetime(dt_created)
SortBy=DateModified
SortOrder=Desc



[modified_since_one_month]
Group=Search by Date Modified
Name=Modified since one month
Name_2052=一月内
Name_1028=一月內
SQL=dt_data_modified > datetime('now', '-31 day','start of day') and datetime(dt_data_modified, '-12 hour') > datetime(dt_created)
SortBy=DateModified
SortOrder=Desc



[accessed_since_today]
Group=Search by Date Accessed
Name=Accessed since Today
Name_2052=今日
Name_1028=今日
SQL=dt_accessed > datetime('now','start of day')
SortBy=DateAccessed
SortOrder=Desc



[accessed_since_yesterday]
Group=Search by Date Accessed
Name=Accessed since Yesterday
Name_2052=昨天至今
Name_1028=昨天至今
SQL=dt_accessed > datetime('now', '-1 day','start of day')
SortBy=DateAccessed
SortOrder=Desc

[accessed_since_the_day_before_yesterday]
Group=Search by Date Accessed
Name=Accessed since the day before yesterday
Name_2052=前天至今
Name_1028=前天至今
SQL=dt_accessed > datetime('now', '-2 day','start of day')
SortBy=DateAccessed
SortOrder=Desc


[accessed_since_one_week]
Group=Search by Date Accessed
Name=Accessed since one week
Name_2052=一周内
Name_1028=一周內
SQL=dt_accessed > datetime('now', '-7 day','start of day')
SortBy=DateAccessed
SortOrder=Desc



[accessed_since_one_month]
Group=Search by Date Accessed
Name=Accessed since one month
Name_2052=一月内
Name_1028=一月內
SQL=dt_accessed > datetime('now', '-31 day','start of day')
SortBy=DateAccessed
SortOrder=Desc
