* id customer_name invoice_no page_no item_count employee_id location_id entered_by_user_id time_in checking_start checker_id time_out status created_at picker_status picker_completed_at

* id employee_name role location status

* id invoice_no customer_name total_pages entered_by_user_id status created_at

* id invoice_id page_no assignment_id status created_at

* id asset_tag asset_name device_id category_id branch_id warehouse_id brand model serial_number device_hostname extension_number ip_address mac_address device_password_encrypted processor ram_details storage_details cartridge_name nvr_channels hdd_slots total_storage playback_days area_name camera_type camera_name port_details screen_size issued_date imsi_number sim_number iqama_id designation phone_number working_status previous_user imei_number purpose handover_date charger head_phone admin_id server_ip server_port specification operating_system windows_key office_key monitor_id pc_id other_specs location_id assigned_to_name assigned_date purchase_order_id external_po_number supplier_name purchase_date purchase_cost warranty_expiry license_renewal_date asset_status condition_status notes created_by created_at updated_at

* id asset_id location_id assigned_to_name assigned_date returned_date remarks created_by created_at

* id asset_id attachment_type original_name stored_name file_path mime_type file_size uploaded_by created_at

* id branch_name branch_code is_active created_at updated_at

* id category_name description is_active created_at updated_at

* category_name prefix last_number number_digits is_active updated_at

* id warehouse_id location_name location_type parent_location_id address_note is_active created_at updated_at

* asset_id monitor_enabled check_method tcp_port current_status consecutive_failures last_response_ms last_check_at last_online_at last_offline_at status_changed_at last_error created_at updated_at

* id asset_prefix last_asset_number number_digits updated_at

* id branch_id warehouse_name warehouse_code address_note is_active created_at updated_at

* id asset_id event_type previous_status response_ms message event_at

* id check_interval_seconds offline_after_failures ping_timeout_ms is_enabled updated_at

* id prefix last_number number_digits updated_at

* id po_number po_serial po_date supplier_name note status payment_status created_by created_at updated_at

* id purchase_order_id original_name stored_name file_path mime_type file_size uploaded_by created_at

* id purchase_order_id sort_order description quantity unit_price remarks

* id device_uuid device_name platform fcm_token fcm_token_hash api_key_hash is_active last_seen_at created_at updated_at

* id asset_id event_type title body success_count failure_count last_error sent_at

* id code_hash expires_at used_at created_by created_at

* id push_enabled offline_notifications recovery_notifications service_account_path updated_at

* id location_name status

* user_id

* kind filename uploaded_at uploaded_by row_count date_from date_to

* code name updated_at

* id code offer_price purchaser start_date end_date poster_by poster_status remarks created_by updated_by created_at updated_at revision

* code stock sales_price unit

* id kind txn_date voucher code quantity unit

* id invoice_id employee_id location_id item_count entered_by_user_id picker_status picking_start picker_completed_at checker_id checking_start checking_completed_at checking_status created_at

* id username password employee_id default_location_id role status created_at

* id user_id employee_id

select table bills employees invoices invoice_pages it_assets it_asset_assignments it_asset_attachments it_asset_branches it_asset_categories it_asset_device_id_settings it_asset_locations it_asset_monitoring it_asset_settings it_asset_warehouses it_network_monitor_events it_network_monitor_settings it_po_settings it_purchase_orders it_purchase_order_attachments it_purchase_order_items it_push_devices it_push_notifications it_push_pairing_codes it_push_settings locations mkt_access mkt_imports mkt_items mkt_promotions mkt_snapshot mkt_transactions picking_assignments users user_monitor_employees . select column
Show

criteria

Sort	Ascending	Descending
Add as	AND	OR
Op	= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL REGEXP REGEXP ^...$ NOT REGEXP	Text Another column
	select table bills employees invoices invoice_pages it_assets it_asset_assignments it_asset_attachments it_asset_branches it_asset_categories it_asset_device_id_settings it_asset_locations it_asset_monitoring it_asset_settings it_asset_warehouses it_network_monitor_events it_network_monitor_settings it_po_settings it_purchase_orders it_purchase_order_attachments it_purchase_order_items it_push_devices it_push_notifications it_push_pairing_codes it_push_settings locations mkt_access mkt_imports mkt_items mkt_promotions mkt_snapshot mkt_transactions picking_assignments users user_monitor_employees .	select column