Create filter for Project


Filter name

Columns

Add to menu

[{"id":"Project:name","field":"name","label":"Name","type":"string","input":"text","variable":"project_name"},{"id":"Project:status","field":"status","label":"Status","type":"string","input":"select","variable":"project_status","values":{"Created":"Created","In Progress":"In Progress","Draft":"Draft","Completed":"Completed","Canceled":"Canceled"},"operators":["equal","not_equal","in","not_in","is_null","is_not_null"]},{"id":"Project:type","field":"type","label":"Type","type":"string","input":"select","variable":"project_type","values":{"Administrative":"Administrative","Operative":"Operative","Development":"Development","Construction":"Construction","Research":"Research","Event":"Event","Other":"Other"},"operators":["equal","not_equal","in","not_in","is_null","is_not_null"]},{"id":"Project:start_date","field":"start_date","label":"Start date","type":"date","input":"text","variable":"project_start_date"},{"id":"Project:end_date","field":"end_date","label":"End date","type":"date","input":"text","variable":"project_end_date"},{"id":"Project:priority","field":"priority","label":"Priority","type":"string","input":"select","variable":"project_priority","values":{"Low":"Low","Normal":"Normal","High":"High"},"operators":["equal","not_equal","in","not_in","is_null","is_not_null"]},{"id":"Project:project_url","field":"project_url","label":"Project Url","type":"string","input":"text","variable":"project_project_url"},{"id":"Project:user","field":"user","label":"User","type":"string","input":"text","variable":"project_user"},{"id":"Project:group","field":"group","label":"Group","type":"string","input":"text","variable":"project_group"},{"id":"Project:created_by","field":"created_by","label":"Created by","type":"string","input":"text","variable":"project_created_by"},{"id":"Project:modified_by","field":"modified_by","label":"Modified by","type":"string","input":"text","variable":"project_modified_by"},{"id":"Project:createdtime","field":"createdtime","label":"Created time","type":"datetime","input":"text","variable":"project_createdtime"},{"id":"Project:modifiedtime","field":"modifiedtime","label":"Modified time","type":"datetime","input":"text","variable":"project_modifiedtime"},{"id":"Project:description","field":"description","label":"Description","type":"string","input":"text","variable":"project_description"}]

Variables


$today - Current day
$year - Current year

Manage custom links


{"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?"}