Create filter for Service
Filter name
Icon
Add to menu
Add to quick create
Share filter
Columns
Order by
Conditions
{"condition":"AND","valid":"true"}
[{"id":"Service:image","field":"image","label":"Image","type":"string","input":"text","variable":"service_image"},{"id":"Service:name","field":"name","label":"Name","type":"string","input":"text","variable":"service_name"},{"id":"Service:price","field":"price","label":"Price","type":"string","input":"text","variable":"service_price"},{"id":"Service:service_type","field":"service_type","label":"Type","type":"string","input":"select","variable":"service_service_type","values":{"Holiday":"Holiday","Work":"Work"},"operators":["contains","equal","not_equal","in","not_in","is_null","is_not_null","is_empty","is_not_empty"]},{"id":"Service:status","field":"status","label":"Status","type":"string","input":"select","variable":"service_status","values":{"Planned":"Planned","Active":"Active","Completed":"Completed","Cancelled":"Cancelled"},"operators":["contains","equal","not_equal","in","not_in","is_null","is_not_null","is_empty","is_not_empty"]},{"id":"Service:provider","field":"provider","label":"Provider","type":"string","input":"text","variable":"service_provider"},{"id":"Service:location","field":"location","label":"Location","type":"string","input":"text","variable":"service_location"},{"id":"Service:contact_name","field":"contact_name","label":"Contact Name","type":"string","input":"text","variable":"service_contact_name"},{"id":"Service:contact_email","field":"contact_email","label":"Contact Email","type":"string","input":"text","variable":"service_contact_email"},{"id":"Service:contact_phone","field":"contact_phone","label":"Contact Phone","type":"string","input":"text","variable":"service_contact_phone"},{"id":"Service:planned_date","field":"planned_date","label":"Planned Date","type":"datetime","input":"text","variable":"service_planned_date","operators":["equal","not_equal","less","less_or_equal","greater","greater_or_equal","between","not_between","is_null","is_not_null"]},{"id":"Service:completed_date","field":"completed_date","label":"Completed Date","type":"datetime","input":"text","variable":"service_completed_date","operators":["equal","not_equal","less","less_or_equal","greater","greater_or_equal","between","not_between","is_null","is_not_null"]},{"id":"Service:duration_minutes","field":"duration_minutes","label":"Duration Minutes","type":"string","input":"text","variable":"service_duration_minutes"},{"id":"Service:description","field":"description","label":"Description","type":"string","input":"text","variable":"service_description"},{"id":"Service:link","field":"link","label":"Link","type":"string","input":"text","variable":"service_link"},{"id":"Service:year","field":"year","label":"Year","type":"string","input":"text","variable":"service_year"},{"id":"Service:start_date","field":"start_date","label":"Start date","type":"datetime","input":"text","variable":"service_start_date","operators":["equal","not_equal","less","less_or_equal","greater","greater_or_equal","between","not_between","is_null","is_not_null"]},{"id":"Service:end_date","field":"end_date","label":"End date","type":"datetime","input":"text","variable":"service_end_date","operators":["equal","not_equal","less","less_or_equal","greater","greater_or_equal","between","not_between","is_null","is_not_null"]},{"id":"Service:tools","field":"tools","label":"Tools","type":"string","input":"select","variable":"service_tools","values":{"Air Compressor":"Air Compressor","Axes":"Axes","Chisels":"Chisels","Clamps":"Clamps","Drills":"Drills","Drywall Anchors":"Drywall Anchors","Fasteners":"Fasteners","Grinders":"Grinders","Hammers":"Hammers","Hand Saw":"Hand Saw","Impact Driver":"Impact Driver","Impact Wrench":"Impact Wrench","Ladders":"Ladders","Lathes":"Lathes","Lug Nuts":"Lug Nuts","Measuring Tools":"Measuring Tools","Nail Guns":"Nail Guns","Nails":"Nails","Nuts and Bolts":"Nuts and Bolts","Pliers":"Pliers","Power tools":"Power tools","Sanders":"Sanders","Screw Drivers":"Screw Drivers","Screws":"Screws","Wrenches":"Wrenches","Saws":"Saws"},"operators":["contains","equal","not_equal","in","not_in","is_null","is_not_null","is_empty","is_not_empty"]},{"id":"Service:user","field":"user","label":"User","type":"string","input":"text","variable":"service_user"},{"id":"Service:group","field":"group","label":"Group","type":"string","input":"text","variable":"service_group"},{"id":"Service:created_by","field":"created_by","label":"Created by","type":"string","input":"text","variable":"service_created_by"},{"id":"Service:modified_by","field":"modified_by","label":"Modified by","type":"string","input":"text","variable":"service_modified_by"},{"id":"Service:createdtime","field":"createdtime","label":"Created time","type":"datetime","input":"text","variable":"service_createdtime","operators":["equal","not_equal","less","less_or_equal","greater","greater_or_equal","between","not_between","is_null","is_not_null"]},{"id":"Service:modifiedtime","field":"modifiedtime","label":"Modified time","type":"datetime","input":"text","variable":"service_modifiedtime","operators":["equal","not_equal","less","less_or_equal","greater","greater_or_equal","between","not_between","is_null","is_not_null"]}]
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_API_LIMIT_REACHED":"The API limit or tokens are used up. Check the API key credit\/quota and try again later.","JS_API_LOAD_FAILED":"API loading failed. Please try again later.","JS_CREATE_DASHBOARD":"It's required to create Dashboard before Widget","JS_CALENDAR_ALL_DAY":"All day","JS_CALENDAR_ADD_EVENT":"Add event","JS_CALENDAR_DAY":"Day","JS_CALENDAR_DAY_0":"Sunday","JS_CALENDAR_DAY_1":"Monday","JS_CALENDAR_DAY_2":"Tuesday","JS_CALENDAR_DAY_3":"Wednesday","JS_CALENDAR_DAY_4":"Thursday","JS_CALENDAR_DAY_5":"Friday","JS_CALENDAR_DAY_6":"Saturday","JS_CALENDAR_DAY_SHORT_0":"Sun","JS_CALENDAR_DAY_SHORT_1":"Mon","JS_CALENDAR_DAY_SHORT_2":"Tue","JS_CALENDAR_DAY_SHORT_3":"Wed","JS_CALENDAR_DAY_SHORT_4":"Thu","JS_CALENDAR_DAY_SHORT_5":"Fri","JS_CALENDAR_DAY_SHORT_6":"Sat","JS_CALENDAR_LIST":"List","JS_CALENDAR_MONTH":"Month","JS_CALENDAR_MORE":"more","JS_CALENDAR_NO_EVENTS":"No events","JS_CALENDAR_TODAY":"Today","JS_CALENDAR_WEEK":"Week","JS_CALENDAR_WEEK_SHORT":"Wk","JS_SUCCESS_UPDATE_SCORE":"Successfully updated score","JS_AI_TEMPORARILY_UNAVAILABLE":"The AI service is temporarily overloaded. Please try loading again shortly.","JS_AI_ENDPOINT_UNAVAILABLE":"The Recipe AI endpoint is unavailable. Deploy modules\/Recipe\/views\/Api.php and modules\/Recipe\/models\/Api.php, then reload the page.","JS_AI_INVALID_RESULT":"AI returned no usable recipe. Try a more specific name.","JS_AI_SEARCH_REQUIRED":"Enter a recipe name.","JS_AI_RECIPE_REVIEW":"Click to fill the form. Review the recipe and estimated nutrition before saving.","JS_COURSE_NAME_REQUIRED":"Enter the course name first.","JS_COURSE_DURATION_INVALID":"Course duration must be between 1 and 60 minutes.","JS_COURSE_LEVEL_REQUIRED":"Select the course difficulty first.","JS_COURSE_TYPE_REQUIRED":"Select the course type first.","JS_COURSE_GENERATED":"Course content was generated. Review it and save the record.","JS_TEMPLATE_VARIABLE_IMAGE":"Mapped image","JS_TEMPLATE_VARIABLE_NAME":"Mapped name","JS_TEMPLATE_VARIABLE_DESCRIPTION":"Mapped description","JS_TEMPLATE_SELECT_BASE_TEMPLATE":"Select a base template first.","JS_TEMPLATE_BASE_TEMPLATE_LOADED":"The base template was loaded.","JS_TEMPLATE_BASE_TEMPLATE_LOAD_FAILED":"The base template could not be loaded.","JS_TEMPLATE_REPLACE_CONTENT_CONFIRM":"Loading the base template will replace the current Body content. Continue?","JS_TEMPLATE_DOCUMENT_DOWNLOAD_ONLY":"DOCX preview is not available. Use Download to export the document directly.","JS_WHEEL_OPTION":"Option","JS_WHEEL_SPINNING":"The wheel is spinning...","JS_WHEEL_SELECTED_VALUE":"Selected value","JS_WHEEL_VALUES_REFRESHED":"Values refreshed. You can spin."}