Create filter for Cars
Filter name
Icon
Add to menu
Add to quick create
Share filter
Columns
Order by
Conditions
{"condition":"AND","valid":"true"}
[{"id":"Car:image","field":"image","label":"Image","type":"string","input":"text","variable":"car_image"},{"id":"Car:image:Photo:name","field":"image:Photo:name","label":"Image: (Photo) Name","type":"string","variable":"car_image_photo_name"},{"id":"Car:image:Photo:input","field":"image:Photo:input","label":"Image: (Photo) Input","type":"string","variable":"car_image_photo_input"},{"id":"Car:image:Photo:type","field":"image:Photo:type","label":"Image: (Photo) Type","type":"string","variable":"car_image_photo_type"},{"id":"Car:image:Photo:link","field":"image:Photo:link","label":"Image: (Photo) Link","type":"string","variable":"car_image_photo_link"},{"id":"Car:image:Photo:size","field":"image:Photo:size","label":"Image: (Photo) Size","type":"string","variable":"car_image_photo_size"},{"id":"Car:image:Photo:style","field":"image:Photo:style","label":"Image: (Photo) Style","type":"string","variable":"car_image_photo_style"},{"id":"Car:image:Photo:user","field":"image:Photo:user","label":"Image: (Photo) User","type":"string","variable":"car_image_photo_user"},{"id":"Car:image:Photo:group","field":"image:Photo:group","label":"Image: (Photo) Group","type":"string","variable":"car_image_photo_group"},{"id":"Car:image:Photo:created_by","field":"image:Photo:created_by","label":"Image: (Photo) Created by","type":"string","variable":"car_image_photo_created_by"},{"id":"Car:image:Photo:modified_by","field":"image:Photo:modified_by","label":"Image: (Photo) Modified by","type":"string","variable":"car_image_photo_modified_by"},{"id":"Car:image:Photo:createdtime","field":"image:Photo:createdtime","label":"Image: (Photo) Created time","type":"datetime","variable":"car_image_photo_createdtime"},{"id":"Car:image:Photo:modifiedtime","field":"image:Photo:modifiedtime","label":"Image: (Photo) Modified time","type":"datetime","variable":"car_image_photo_modifiedtime"},{"id":"Car:name","field":"name","label":"Car Name","type":"string","input":"text","variable":"car_name"},{"id":"Car:brand","field":"brand","label":"Brand","type":"string","input":"text","variable":"car_brand"},{"id":"Car:model","field":"model","label":"Model","type":"string","input":"text","variable":"car_model"},{"id":"Car:year","field":"year","label":"Year","type":"string","input":"text","variable":"car_year"},{"id":"Car:ad_url","field":"ad_url","label":"Ad URL","type":"string","input":"text","variable":"car_ad_url"},{"id":"Car:power_hp","field":"power_hp","label":"Power (HP)","type":"string","input":"text","variable":"car_power_hp"},{"id":"Car:fuel_type","field":"fuel_type","label":"Fuel Type","type":"string","input":"select","variable":"car_fuel_type","values":{"Petrol":"Petrol","Diesel":"Diesel","Hybrid":"Hybrid","Electric":"Electric","LPG":"LPG","CNG":"CNG"},"operators":["contains","equal","not_equal","in","not_in","is_null","is_not_null","is_empty","is_not_empty"]},{"id":"Car:transmission","field":"transmission","label":"Transmission","type":"string","input":"select","variable":"car_transmission","values":{"Manual":"Manual","Automatic":"Automatic","CVT":"CVT","DSG":"DSG"},"operators":["contains","equal","not_equal","in","not_in","is_null","is_not_null","is_empty","is_not_empty"]},{"id":"Car:mileage","field":"mileage","label":"Mileage","type":"string","input":"text","variable":"car_mileage"},{"id":"Car:fuel_consumption_avg","field":"fuel_consumption_avg","label":"Average Fuel Consumption","type":"string","input":"text","variable":"car_fuel_consumption_avg"},{"id":"Car:loan_needed","field":"loan_needed","label":"Loan Needed","type":"string","input":"text","variable":"car_loan_needed"},{"id":"Car:tire_size","field":"tire_size","label":"Tire Size","type":"string","input":"text","variable":"car_tire_size"},{"id":"Car:tire_price_estimate","field":"tire_price_estimate","label":"Tire Price Estimate","type":"string","input":"text","variable":"car_tire_price_estimate"},{"id":"Car:monthly_payment","field":"monthly_payment","label":"Monthly Payment","type":"string","input":"text","variable":"car_monthly_payment"},{"id":"Car:winter_tires_included","field":"winter_tires_included","label":"Winter Tires Included","type":"string","input":"text","variable":"car_winter_tires_included"},{"id":"Car:equipment_level","field":"equipment_level","label":"Equipment Level","type":"string","input":"text","variable":"car_equipment_level"},{"id":"Car:equipment_features","field":"equipment_features","label":"Equipment Features","type":"string","input":"text","variable":"car_equipment_features"},{"id":"Car:price","field":"price","label":"Price","type":"string","input":"text","variable":"car_price"},{"id":"Car:insurance_estimate","field":"insurance_estimate","label":"Insurance Estimate","type":"string","input":"text","variable":"car_insurance_estimate"},{"id":"Car:annual_fuel_cost","field":"annual_fuel_cost","label":"Annual Fuel Cost","type":"string","input":"text","variable":"car_annual_fuel_cost"},{"id":"Car:annual_insurance_cost","field":"annual_insurance_cost","label":"Annual Insurance Cost","type":"string","input":"text","variable":"car_annual_insurance_cost"},{"id":"Car:annual_service_cost","field":"annual_service_cost","label":"Annual Service Cost","type":"string","input":"text","variable":"car_annual_service_cost"},{"id":"Car:annual_tire_cost","field":"annual_tire_cost","label":"Annual Tire Cost","type":"string","input":"text","variable":"car_annual_tire_cost"},{"id":"Car:annual_total_cost","field":"annual_total_cost","label":"Annual Total Cost","type":"string","input":"text","variable":"car_annual_total_cost"},{"id":"Car:service_history","field":"service_history","label":"Service History","type":"string","input":"text","variable":"car_service_history"},{"id":"Car:last_service_km","field":"last_service_km","label":"Last Service","type":"string","input":"text","variable":"car_last_service_km"},{"id":"Car:next_service_km","field":"next_service_km","label":"Next Service","type":"string","input":"text","variable":"car_next_service_km"},{"id":"Car:stk_ek_valid_until","field":"stk_ek_valid_until","label":"MOT\/Technical Inspection Valid Until","type":"string","input":"text","variable":"car_stk_ek_valid_until"},{"id":"Car:accident_history","field":"accident_history","label":"Accident History","type":"string","input":"text","variable":"car_accident_history"},{"id":"Car:technical_condition","field":"technical_condition","label":"Technical Condition","type":"string","input":"select","variable":"car_technical_condition","values":{"Excellent":"Excellent","Very Good":"Very Good","Good":"Good","Average":"Average","Poor":"Poor"},"operators":["contains","equal","not_equal","in","not_in","is_null","is_not_null","is_empty","is_not_empty"]},{"id":"Car:compare_to","field":"compare_to","label":"Compare To","type":"string","input":"text","variable":"car_compare_to"},{"id":"Car:pros","field":"pros","label":"Pros","type":"string","input":"text","variable":"car_pros"},{"id":"Car:cons","field":"cons","label":"Cons","type":"string","input":"text","variable":"car_cons"},{"id":"Car:score_value","field":"score_value","label":"Value Score","type":"string","input":"text","variable":"car_score_value"},{"id":"Car:score_costs","field":"score_costs","label":"Costs Score","type":"string","input":"text","variable":"car_score_costs"},{"id":"Car:score_equipment","field":"score_equipment","label":"Equipment Score","type":"string","input":"text","variable":"car_score_equipment"},{"id":"Car:score_total","field":"score_total","label":"Total Score","type":"string","input":"text","variable":"car_score_total"},{"id":"Car:description","field":"description","label":"Description","type":"string","input":"text","variable":"car_description"},{"id":"Car:user","field":"user","label":"User","type":"string","input":"text","variable":"car_user"},{"id":"Car:group","field":"group","label":"Group","type":"string","input":"text","variable":"car_group"},{"id":"Car:created_by","field":"created_by","label":"Created by","type":"string","input":"text","variable":"car_created_by"},{"id":"Car:modified_by","field":"modified_by","label":"Modified by","type":"string","input":"text","variable":"car_modified_by"},{"id":"Car:createdtime","field":"createdtime","label":"Created time","type":"datetime","input":"text","variable":"car_createdtime"},{"id":"Car:modifiedtime","field":"modifiedtime","label":"Modified time","type":"datetime","input":"text","variable":"car_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"}