Create filter for Task
Filter name
Icon
Add to menu
Add to quick create
Share filter
Columns
Order by
Conditions
{"condition":"AND","valid":"true"}
[{"id":"Task:name","field":"name","label":"Name","type":"string","input":"text","variable":"task_name"},{"id":"Task:status","field":"status","label":"Status","type":"string","input":"select","variable":"task_status","values":{"Created":"Created","Opened":"Opened","In Progress":"In Progress","Draft":"Draft","Completed":"Completed","Canceled":"Canceled","Waiting Approval":"Waiting Approval","Rejected":"Rejected"},"operators":["contains","equal","not_equal","in","not_in","is_null","is_not_null","is_empty","is_not_empty"]},{"id":"Task:related_to","field":"related_to","label":"Related to","type":"string","input":"text","variable":"task_related_to"},{"id":"Task:related_to:Film:image","field":"related_to:Film:image","label":"Related to: (Film) Image","type":"string","variable":"task_related_to_film_image"},{"id":"Task:related_to:Film:name","field":"related_to:Film:name","label":"Related to: (Film) Name","type":"string","variable":"task_related_to_film_name"},{"id":"Task:related_to:Film:description","field":"related_to:Film:description","label":"Related to: (Film) Description","type":"string","variable":"task_related_to_film_description"},{"id":"Task:related_to:Film:quote","field":"related_to:Film:quote","label":"Related to: (Film) Quote","type":"string","variable":"task_related_to_film_quote"},{"id":"Task:related_to:Film:type","field":"related_to:Film:type","label":"Related to: (Film) Type","type":"string","variable":"task_related_to_film_type"},{"id":"Task:related_to:Film:related_to","field":"related_to:Film:related_to","label":"Related to: (Film) Related to","type":"string","variable":"task_related_to_film_related_to"},{"id":"Task:related_to:Film:genre","field":"related_to:Film:genre","label":"Related to: (Film) Genre","type":"string","variable":"task_related_to_film_genre"},{"id":"Task:related_to:Film:origin","field":"related_to:Film:origin","label":"Related to: (Film) Country of origin","type":"string","variable":"task_related_to_film_origin"},{"id":"Task:related_to:Film:length","field":"related_to:Film:length","label":"Related to: (Film) Length minutes","type":"string","variable":"task_related_to_film_length"},{"id":"Task:related_to:Film:year","field":"related_to:Film:year","label":"Related to: (Film) Year","type":"string","variable":"task_related_to_film_year"},{"id":"Task:related_to:Film:cinema_release_date","field":"related_to:Film:cinema_release_date","label":"Related to: (Film) Cinema Release Date","type":"date","variable":"task_related_to_film_cinema_release_date"},{"id":"Task:related_to:Film:release_date","field":"related_to:Film:release_date","label":"Related to: (Film) Release Date","type":"date","variable":"task_related_to_film_release_date"},{"id":"Task:related_to:Film:trailer","field":"related_to:Film:trailer","label":"Related to: (Film) Trailer","type":"string","variable":"task_related_to_film_trailer"},{"id":"Task:related_to:Film:imdb_url","field":"related_to:Film:imdb_url","label":"Related to: (Film) IMDB Url","type":"string","variable":"task_related_to_film_imdb_url"},{"id":"Task:related_to:Film:csfd_url","field":"related_to:Film:csfd_url","label":"Related to: (Film) CSFD Url","type":"string","variable":"task_related_to_film_csfd_url"},{"id":"Task:related_to:Film:user","field":"related_to:Film:user","label":"Related to: (Film) User","type":"string","variable":"task_related_to_film_user"},{"id":"Task:related_to:Film:group","field":"related_to:Film:group","label":"Related to: (Film) Group","type":"string","variable":"task_related_to_film_group"},{"id":"Task:related_to:Film:created_by","field":"related_to:Film:created_by","label":"Related to: (Film) Created by","type":"string","variable":"task_related_to_film_created_by"},{"id":"Task:related_to:Film:modified_by","field":"related_to:Film:modified_by","label":"Related to: (Film) Modified by","type":"string","variable":"task_related_to_film_modified_by"},{"id":"Task:related_to:Film:createdtime","field":"related_to:Film:createdtime","label":"Related to: (Film) Created time","type":"datetime","variable":"task_related_to_film_createdtime"},{"id":"Task:related_to:Film:modifiedtime","field":"related_to:Film:modifiedtime","label":"Related to: (Film) Modified time","type":"datetime","variable":"task_related_to_film_modifiedtime"},{"id":"Task:related_to:Film:imdb","field":"related_to:Film:imdb","label":"Related to: (Film) Search on IMDB","type":"string","variable":"task_related_to_film_imdb"},{"id":"Task:related_to:Film:gemini","field":"related_to:Film:gemini","label":"Related to: (Film) Search Info","type":"string","variable":"task_related_to_film_gemini"},{"id":"Task:related_to:Task:name","field":"related_to:Task:name","label":"Related to: (Task) Name","type":"string","variable":"task_related_to_task_name"},{"id":"Task:related_to:Task:status","field":"related_to:Task:status","label":"Related to: (Task) Status","type":"string","variable":"task_related_to_task_status"},{"id":"Task:related_to:Task:related_to","field":"related_to:Task:related_to","label":"Related to: (Task) Related to","type":"string","variable":"task_related_to_task_related_to"},{"id":"Task:related_to:Task:milestone","field":"related_to:Task:milestone","label":"Related to: (Task) Milestone","type":"string","variable":"task_related_to_task_milestone"},{"id":"Task:related_to:Task:start_date","field":"related_to:Task:start_date","label":"Related to: (Task) Start date","type":"date","variable":"task_related_to_task_start_date"},{"id":"Task:related_to:Task:end_date","field":"related_to:Task:end_date","label":"Related to: (Task) End date","type":"date","variable":"task_related_to_task_end_date"},{"id":"Task:related_to:Task:priority","field":"related_to:Task:priority","label":"Related to: (Task) Priority","type":"string","variable":"task_related_to_task_priority"},{"id":"Task:related_to:Task:approval_status","field":"related_to:Task:approval_status","label":"Related to: (Task) Approval Status","type":"string","variable":"task_related_to_task_approval_status"},{"id":"Task:related_to:Task:approval_approvers","field":"related_to:Task:approval_approvers","label":"Related to: (Task) Approvers","type":"string","variable":"task_related_to_task_approval_approvers"},{"id":"Task:related_to:Task:price","field":"related_to:Task:price","label":"Related to: (Task) Price","type":"string","variable":"task_related_to_task_price"},{"id":"Task:related_to:Task:description","field":"related_to:Task:description","label":"Related to: (Task) Description","type":"string","variable":"task_related_to_task_description"},{"id":"Task:related_to:Task:mission","field":"related_to:Task:mission","label":"Related to: (Task) Mission","type":"string","variable":"task_related_to_task_mission"},{"id":"Task:related_to:Task:mission_month","field":"related_to:Task:mission_month","label":"Related to: (Task) Mission Month","type":"string","variable":"task_related_to_task_mission_month"},{"id":"Task:related_to:Task:mission_completed","field":"related_to:Task:mission_completed","label":"Related to: (Task) Mission Completed","type":"string","variable":"task_related_to_task_mission_completed"},{"id":"Task:related_to:Task:user","field":"related_to:Task:user","label":"Related to: (Task) User","type":"string","variable":"task_related_to_task_user"},{"id":"Task:related_to:Task:group","field":"related_to:Task:group","label":"Related to: (Task) Group","type":"string","variable":"task_related_to_task_group"},{"id":"Task:related_to:Task:created_by","field":"related_to:Task:created_by","label":"Related to: (Task) Created by","type":"string","variable":"task_related_to_task_created_by"},{"id":"Task:related_to:Task:modified_by","field":"related_to:Task:modified_by","label":"Related to: (Task) Modified by","type":"string","variable":"task_related_to_task_modified_by"},{"id":"Task:related_to:Task:createdtime","field":"related_to:Task:createdtime","label":"Related to: (Task) Created time","type":"datetime","variable":"task_related_to_task_createdtime"},{"id":"Task:related_to:Task:modifiedtime","field":"related_to:Task:modifiedtime","label":"Related to: (Task) Modified time","type":"datetime","variable":"task_related_to_task_modifiedtime"},{"id":"Task:related_to:Game:image","field":"related_to:Game:image","label":"Related to: (Game) Image","type":"string","variable":"task_related_to_game_image"},{"id":"Task:related_to:Game:name","field":"related_to:Game:name","label":"Related to: (Game) Name","type":"string","variable":"task_related_to_game_name"},{"id":"Task:related_to:Game:description","field":"related_to:Game:description","label":"Related to: (Game) Description","type":"string","variable":"task_related_to_game_description"},{"id":"Task:related_to:Game:genre","field":"related_to:Game:genre","label":"Related to: (Game) Genre","type":"string","variable":"task_related_to_game_genre"},{"id":"Task:related_to:Game:platform","field":"related_to:Game:platform","label":"Related to: (Game) Platform","type":"string","variable":"task_related_to_game_platform"},{"id":"Task:related_to:Game:developers","field":"related_to:Game:developers","label":"Related to: (Game) Developers","type":"string","variable":"task_related_to_game_developers"},{"id":"Task:related_to:Game:release_date","field":"related_to:Game:release_date","label":"Related to: (Game) Release Date","type":"date","variable":"task_related_to_game_release_date"},{"id":"Task:related_to:Game:website","field":"related_to:Game:website","label":"Related to: (Game) Website","type":"string","variable":"task_related_to_game_website"},{"id":"Task:related_to:Game:trailer","field":"related_to:Game:trailer","label":"Related to: (Game) Trailer","type":"string","variable":"task_related_to_game_trailer"},{"id":"Task:related_to:Game:is_expansion","field":"related_to:Game:is_expansion","label":"Related to: (Game) Is Expansion","type":"string","variable":"task_related_to_game_is_expansion"},{"id":"Task:related_to:Game:expansion_number","field":"related_to:Game:expansion_number","label":"Related to: (Game) Expansion Number","type":"string","variable":"task_related_to_game_expansion_number"},{"id":"Task:related_to:Game:related_to","field":"related_to:Game:related_to","label":"Related to: (Game) Expansion for the game","type":"string","variable":"task_related_to_game_related_to"},{"id":"Task:related_to:Game:user","field":"related_to:Game:user","label":"Related to: (Game) User","type":"string","variable":"task_related_to_game_user"},{"id":"Task:related_to:Game:group","field":"related_to:Game:group","label":"Related to: (Game) Group","type":"string","variable":"task_related_to_game_group"},{"id":"Task:related_to:Game:created_by","field":"related_to:Game:created_by","label":"Related to: (Game) Created by","type":"string","variable":"task_related_to_game_created_by"},{"id":"Task:related_to:Game:modified_by","field":"related_to:Game:modified_by","label":"Related to: (Game) Modified by","type":"string","variable":"task_related_to_game_modified_by"},{"id":"Task:related_to:Game:createdtime","field":"related_to:Game:createdtime","label":"Related to: (Game) Created time","type":"datetime","variable":"task_related_to_game_createdtime"},{"id":"Task:related_to:Game:modifiedtime","field":"related_to:Game:modifiedtime","label":"Related to: (Game) Modified time","type":"datetime","variable":"task_related_to_game_modifiedtime"},{"id":"Task:related_to:Project:name","field":"related_to:Project:name","label":"Related to: (Project) Name","type":"string","variable":"task_related_to_project_name"},{"id":"Task:related_to:Project:status","field":"related_to:Project:status","label":"Related to: (Project) Status","type":"string","variable":"task_related_to_project_status"},{"id":"Task:related_to:Project:type","field":"related_to:Project:type","label":"Related to: (Project) Type","type":"string","variable":"task_related_to_project_type"},{"id":"Task:related_to:Project:start_date","field":"related_to:Project:start_date","label":"Related to: (Project) Start date","type":"date","variable":"task_related_to_project_start_date"},{"id":"Task:related_to:Project:end_date","field":"related_to:Project:end_date","label":"Related to: (Project) End date","type":"date","variable":"task_related_to_project_end_date"},{"id":"Task:related_to:Project:priority","field":"related_to:Project:priority","label":"Related to: (Project) Priority","type":"string","variable":"task_related_to_project_priority"},{"id":"Task:related_to:Project:project_url","field":"related_to:Project:project_url","label":"Related to: (Project) Project Url","type":"string","variable":"task_related_to_project_project_url"},{"id":"Task:related_to:Project:user","field":"related_to:Project:user","label":"Related to: (Project) User","type":"string","variable":"task_related_to_project_user"},{"id":"Task:related_to:Project:group","field":"related_to:Project:group","label":"Related to: (Project) Group","type":"string","variable":"task_related_to_project_group"},{"id":"Task:related_to:Project:created_by","field":"related_to:Project:created_by","label":"Related to: (Project) Created by","type":"string","variable":"task_related_to_project_created_by"},{"id":"Task:related_to:Project:modified_by","field":"related_to:Project:modified_by","label":"Related to: (Project) Modified by","type":"string","variable":"task_related_to_project_modified_by"},{"id":"Task:related_to:Project:createdtime","field":"related_to:Project:createdtime","label":"Related to: (Project) Created time","type":"datetime","variable":"task_related_to_project_createdtime"},{"id":"Task:related_to:Project:modifiedtime","field":"related_to:Project:modifiedtime","label":"Related to: (Project) Modified time","type":"datetime","variable":"task_related_to_project_modifiedtime"},{"id":"Task:related_to:Project:description","field":"related_to:Project:description","label":"Related to: (Project) Description","type":"string","variable":"task_related_to_project_description"},{"id":"Task:milestone","field":"milestone","label":"Milestone","type":"string","input":"text","variable":"task_milestone"},{"id":"Task:milestone:Milestone:name","field":"milestone:Milestone:name","label":"Milestone: (Milestone) Name","type":"string","variable":"task_milestone_milestone_name"},{"id":"Task:milestone:Milestone:related_to","field":"milestone:Milestone:related_to","label":"Milestone: (Milestone) Related to","type":"string","variable":"task_milestone_milestone_related_to"},{"id":"Task:milestone:Milestone:release_date","field":"milestone:Milestone:release_date","label":"Milestone: (Milestone) Release Date","type":"date","variable":"task_milestone_milestone_release_date"},{"id":"Task:milestone:Milestone:description","field":"milestone:Milestone:description","label":"Milestone: (Milestone) Description","type":"string","variable":"task_milestone_milestone_description"},{"id":"Task:milestone:Milestone:user","field":"milestone:Milestone:user","label":"Milestone: (Milestone) User","type":"string","variable":"task_milestone_milestone_user"},{"id":"Task:milestone:Milestone:group","field":"milestone:Milestone:group","label":"Milestone: (Milestone) Group","type":"string","variable":"task_milestone_milestone_group"},{"id":"Task:milestone:Milestone:created_by","field":"milestone:Milestone:created_by","label":"Milestone: (Milestone) Created by","type":"string","variable":"task_milestone_milestone_created_by"},{"id":"Task:milestone:Milestone:modified_by","field":"milestone:Milestone:modified_by","label":"Milestone: (Milestone) Modified by","type":"string","variable":"task_milestone_milestone_modified_by"},{"id":"Task:milestone:Milestone:createdtime","field":"milestone:Milestone:createdtime","label":"Milestone: (Milestone) Created time","type":"datetime","variable":"task_milestone_milestone_createdtime"},{"id":"Task:milestone:Milestone:modifiedtime","field":"milestone:Milestone:modifiedtime","label":"Milestone: (Milestone) Modified time","type":"datetime","variable":"task_milestone_milestone_modifiedtime"},{"id":"Task:start_date","field":"start_date","label":"Start date","type":"date","input":"text","variable":"task_start_date"},{"id":"Task:end_date","field":"end_date","label":"End date","type":"date","input":"text","variable":"task_end_date"},{"id":"Task:priority","field":"priority","label":"Priority","type":"string","input":"select","variable":"task_priority","values":{"Low":"Low","Normal":"Normal","High":"High"},"operators":["contains","equal","not_equal","in","not_in","is_null","is_not_null","is_empty","is_not_empty"]},{"id":"Task:approval_status","field":"approval_status","label":"Approval Status","type":"string","input":"select","variable":"task_approval_status","values":{"Waiting Approval":"Waiting Approval","Approved":"Approved","Rejected":"Rejected"},"operators":["contains","equal","not_equal","in","not_in","is_null","is_not_null","is_empty","is_not_empty"]},{"id":"Task:approval_approvers","field":"approval_approvers","label":"Approvers","type":"string","input":"text","variable":"task_approval_approvers"},{"id":"Task:price","field":"price","label":"Price","type":"string","input":"text","variable":"task_price"},{"id":"Task:description","field":"description","label":"Description","type":"string","input":"text","variable":"task_description"},{"id":"Task:mission","field":"mission","label":"Mission","type":"string","input":"select","variable":"task_mission","values":{"Daily":"Daily","Weekly":"Weekly","Monthly":"Monthly","Yearly":"Yearly"},"operators":["contains","equal","not_equal","in","not_in","is_null","is_not_null","is_empty","is_not_empty"]},{"id":"Task:mission_month","field":"mission_month","label":"Mission Month","type":"string","input":"select","variable":"task_mission_month","values":{"$month_short":"Current Month","Jan":"Jan","Feb":"Feb","Mar":"Mar","Apr":"Apr","May":"May","Jun":"Jun","Jul":"Jul","Aug":"Aug","Sep":"Sep","Oct":"Oct","Nov":"Nov","Dec":"Dec"},"operators":["contains","equal","not_equal","in","not_in","is_null","is_not_null","is_empty","is_not_empty"]},{"id":"Task:mission_completed","field":"mission_completed","label":"Mission Completed","type":"string","input":"text","variable":"task_mission_completed"},{"id":"Task:user","field":"user","label":"User","type":"string","input":"text","variable":"task_user"},{"id":"Task:group","field":"group","label":"Group","type":"string","input":"text","variable":"task_group"},{"id":"Task:created_by","field":"created_by","label":"Created by","type":"string","input":"text","variable":"task_created_by"},{"id":"Task:modified_by","field":"modified_by","label":"Modified by","type":"string","input":"text","variable":"task_modified_by"},{"id":"Task:createdtime","field":"createdtime","label":"Created time","type":"datetime","input":"text","variable":"task_createdtime"},{"id":"Task:modifiedtime","field":"modifiedtime","label":"Modified time","type":"datetime","input":"text","variable":"task_modifiedtime"}]
Manage custom links
Variables
$today - Current day
$year - Current year
$month_short - Current month short
$month - Current month
$weekday - Current weekday
{"JS_YES":"Yes","JS_NO":"No","JS_TODAY":"Today","JS_YESTERDAY":"Yesterday","JS_JAN":"January","JS_FEB":"February","JS_MAR":"March","JS_APR":"April","JS_MAY":"May","JS_JUN":"June","JS_JUL":"July","JS_AUG":"August","JS_SEP":"September","JS_OKT":"October","JS_NOV":"November","JS_DEC":"December","JS_YEAR_AGO":"Year ago","JS_YEARS_AGO":"Years ago","JS_DELETE_CONFIRM":"Do you want to delete record ?","JS_MAX_LENGTH":"Max length","JS_SELECT_OPTION":"Select an option","JS_YEAR":"Year","JS_TYPE":"Type","JS_MINUTES":"Minutes","JS_EMPTY_EMAIL":"Empty email address.","JS_DATA_LOADED":"Data loaded","JS_RECORD_RATED":"Rated","JS_REMINDER_COMPLETED":"Reminder Completed","JS_REMINDER_COMPLETE_QUESTION":"Do you really want to complete your reminder?","Stars":"Stars","Rating":"Rating","Persons":"Persons","Nights":"Nights","Departure":"Departure","JS_RANDOM_VALUE_WINNER":"Draw result","JS_COPY_TO_CLIPBOARD_SUCCESS":"Copied to clipboard","JS_TIMER_FINISHED":"Timer finished","JS_IMPORT_INVALID_JSON":"Invalid JSON","JS_CREATE_DASHBOARD":"It's required to create Dashboard before Widget","JS_SUCCESS_UPDATE_SCORE":"Successfully updated score"}