Create filter for Item


Filter name

Columns

Add to menu

[{"id":"Item:name","field":"name","label":"Name","type":"string","input":"text","variable":"item_name"},{"id":"Item:item","field":"item","label":"Item","type":"string","input":"text","variable":"item_item"},{"id":"Item:item:Product:image","field":"item:Product:image","label":"Item: (Product) Image","type":"string","variable":"item_item_product_image"},{"id":"Item:item:Product:name","field":"item:Product:name","label":"Item: (Product) Name","type":"string","variable":"item_item_product_name"},{"id":"Item:item:Product:user","field":"item:Product:user","label":"Item: (Product) User","type":"string","variable":"item_item_product_user"},{"id":"Item:item:Product:group","field":"item:Product:group","label":"Item: (Product) Group","type":"string","variable":"item_item_product_group"},{"id":"Item:item:Product:created_by","field":"item:Product:created_by","label":"Item: (Product) Created by","type":"string","variable":"item_item_product_created_by"},{"id":"Item:item:Product:modified_by","field":"item:Product:modified_by","label":"Item: (Product) Modified by","type":"string","variable":"item_item_product_modified_by"},{"id":"Item:item:Product:createdtime","field":"item:Product:createdtime","label":"Item: (Product) Created time","type":"datetime","variable":"item_item_product_createdtime"},{"id":"Item:item:Product:modifiedtime","field":"item:Product:modifiedtime","label":"Item: (Product) Modified time","type":"datetime","variable":"item_item_product_modifiedtime"},{"id":"Item:item:Product:description","field":"item:Product:description","label":"Item: (Product) Description","type":"string","variable":"item_item_product_description"},{"id":"Item:item:Service:image","field":"item:Service:image","label":"Item: (Service) Image","type":"string","variable":"item_item_service_image"},{"id":"Item:item:Service:name","field":"item:Service:name","label":"Item: (Service) Name","type":"string","variable":"item_item_service_name"},{"id":"Item:item:Service:tools","field":"item:Service:tools","label":"Item: (Service) Tools","type":"string","variable":"item_item_service_tools"},{"id":"Item:item:Service:user","field":"item:Service:user","label":"Item: (Service) User","type":"string","variable":"item_item_service_user"},{"id":"Item:item:Service:group","field":"item:Service:group","label":"Item: (Service) Group","type":"string","variable":"item_item_service_group"},{"id":"Item:item:Service:created_by","field":"item:Service:created_by","label":"Item: (Service) Created by","type":"string","variable":"item_item_service_created_by"},{"id":"Item:item:Service:modified_by","field":"item:Service:modified_by","label":"Item: (Service) Modified by","type":"string","variable":"item_item_service_modified_by"},{"id":"Item:item:Service:createdtime","field":"item:Service:createdtime","label":"Item: (Service) Created time","type":"datetime","variable":"item_item_service_createdtime"},{"id":"Item:item:Service:modifiedtime","field":"item:Service:modifiedtime","label":"Item: (Service) Modified time","type":"datetime","variable":"item_item_service_modifiedtime"},{"id":"Item:item:Service:description","field":"item:Service:description","label":"Item: (Service) Description","type":"string","variable":"item_item_service_description"},{"id":"Item:comment","field":"comment","label":"Comment","type":"string","input":"text","variable":"item_comment"},{"id":"Item:quantity","field":"quantity","label":"Quantity","type":"string","input":"text","variable":"item_quantity"},{"id":"Item:price","field":"price","label":"Price","type":"string","input":"text","variable":"item_price"},{"id":"Item:inventory_id","field":"inventory_id","label":"Inventory","type":"string","input":"text","variable":"item_inventory_id"},{"id":"Item:inventory_id:Inventory:name","field":"inventory_id:Inventory:name","label":"Inventory: (Inventory) Name","type":"string","variable":"item_inventory_id_inventory_name"},{"id":"Item:inventory_id:Inventory:user","field":"inventory_id:Inventory:user","label":"Inventory: (Inventory) User","type":"string","variable":"item_inventory_id_inventory_user"},{"id":"Item:inventory_id:Inventory:group","field":"inventory_id:Inventory:group","label":"Inventory: (Inventory) Group","type":"string","variable":"item_inventory_id_inventory_group"},{"id":"Item:inventory_id:Inventory:created_by","field":"inventory_id:Inventory:created_by","label":"Inventory: (Inventory) Created by","type":"string","variable":"item_inventory_id_inventory_created_by"},{"id":"Item:inventory_id:Inventory:modified_by","field":"inventory_id:Inventory:modified_by","label":"Inventory: (Inventory) Modified by","type":"string","variable":"item_inventory_id_inventory_modified_by"},{"id":"Item:inventory_id:Inventory:createdtime","field":"inventory_id:Inventory:createdtime","label":"Inventory: (Inventory) Created time","type":"datetime","variable":"item_inventory_id_inventory_createdtime"},{"id":"Item:inventory_id:Inventory:modifiedtime","field":"inventory_id:Inventory:modifiedtime","label":"Inventory: (Inventory) Modified time","type":"datetime","variable":"item_inventory_id_inventory_modifiedtime"},{"id":"Item:inventory_id:Inventory:description","field":"inventory_id:Inventory:description","label":"Inventory: (Inventory) Description","type":"string","variable":"item_inventory_id_inventory_description"},{"id":"Item:warehouse_id","field":"warehouse_id","label":"Warehouse","type":"string","input":"text","variable":"item_warehouse_id"},{"id":"Item:warehouse_id:Warehouse:name","field":"warehouse_id:Warehouse:name","label":"Warehouse: (Warehouse) Name","type":"string","variable":"item_warehouse_id_warehouse_name"},{"id":"Item:warehouse_id:Warehouse:user","field":"warehouse_id:Warehouse:user","label":"Warehouse: (Warehouse) User","type":"string","variable":"item_warehouse_id_warehouse_user"},{"id":"Item:warehouse_id:Warehouse:group","field":"warehouse_id:Warehouse:group","label":"Warehouse: (Warehouse) Group","type":"string","variable":"item_warehouse_id_warehouse_group"},{"id":"Item:warehouse_id:Warehouse:created_by","field":"warehouse_id:Warehouse:created_by","label":"Warehouse: (Warehouse) Created by","type":"string","variable":"item_warehouse_id_warehouse_created_by"},{"id":"Item:warehouse_id:Warehouse:modified_by","field":"warehouse_id:Warehouse:modified_by","label":"Warehouse: (Warehouse) Modified by","type":"string","variable":"item_warehouse_id_warehouse_modified_by"},{"id":"Item:warehouse_id:Warehouse:createdtime","field":"warehouse_id:Warehouse:createdtime","label":"Warehouse: (Warehouse) Created time","type":"datetime","variable":"item_warehouse_id_warehouse_createdtime"},{"id":"Item:warehouse_id:Warehouse:modifiedtime","field":"warehouse_id:Warehouse:modifiedtime","label":"Warehouse: (Warehouse) Modified time","type":"datetime","variable":"item_warehouse_id_warehouse_modifiedtime"},{"id":"Item:warehouse_id:Warehouse:description","field":"warehouse_id:Warehouse:description","label":"Warehouse: (Warehouse) Description","type":"string","variable":"item_warehouse_id_warehouse_description"},{"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"}]

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