Create filter for Item
Filter name
Icon
Add to menu
Add to quick create
Share filter
Columns
Order by
Conditions
{"condition":"AND","valid":"true"}
[{"id":"Item:name","field":"name","label":"Name","type":"string","input":"text","variable":"item_name"},{"id":"Item:description","field":"description","label":"Comment","type":"string","input":"text","variable":"item_description"},{"id":"Item:price","field":"price","label":"Price","type":"string","input":"text","variable":"item_price"},{"id":"Item:price_unit","field":"price_unit","label":"Currency","type":"string","input":"text","variable":"item_price_unit"},{"id":"Item:quantity","field":"quantity","label":"Quantity","type":"string","input":"text","variable":"item_quantity"},{"id":"Item:quantity_unit","field":"quantity_unit","label":"Quantity unit","type":"string","input":"text","variable":"item_quantity_unit"},{"id":"Item:inventory_id","field":"inventory_id","label":"Inventory","type":"string","input":"text","variable":"item_inventory_id"},{"id":"Item:item","field":"item","label":"Item","type":"string","input":"text","variable":"item_item"},{"id":"Item:shop_url","field":"shop_url","label":"Shop URL","type":"string","input":"text","variable":"item_shop_url"},{"id":"Item:store","field":"store","label":"Store","type":"string","input":"select","variable":"item_store","values":{"Lidl":"Lidl","Kaufland":"Kaufland","Tesco":"Tesco","Billa":"Billa","Local Market":"Local Market","Online":"Online","Other":"Other"},"operators":["contains","equal","not_equal","in","not_in","is_null","is_not_null","is_empty","is_not_empty"]},{"id":"Item:expiration_date","field":"expiration_date","label":"Expiration Date","type":"string","input":"text","variable":"item_expiration_date"},{"id":"Item:status","field":"status","label":"Condition","type":"string","input":"select","variable":"item_status","values":{"New":"New","Used":"Used","Partially Used":"Partially Used","Consumed":"Consumed","Expired":"Expired","Damaged":"Damaged","Broken":"Broken","Lost":"Lost","Disposed":"Disposed"},"operators":["contains","equal","not_equal","in","not_in","is_null","is_not_null","is_empty","is_not_empty"]},{"id":"Item:user","field":"user","label":"User","type":"string","input":"text","variable":"item_user"},{"id":"Item:group","field":"group","label":"Group","type":"string","input":"text","variable":"item_group"},{"id":"Item:created_by","field":"created_by","label":"Created by","type":"string","input":"text","variable":"item_created_by"},{"id":"Item:modified_by","field":"modified_by","label":"Modified by","type":"string","input":"text","variable":"item_modified_by"},{"id":"Item:createdtime","field":"createdtime","label":"Created time","type":"datetime","input":"text","variable":"item_createdtime"},{"id":"Item:modifiedtime","field":"modifiedtime","label":"Modified time","type":"datetime","input":"text","variable":"item_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"}