# # Search Query Builder configuration # # Global config for the query builder. See http://querybuilder.js.org/#usage for available settings. query_builder_global_options = {} # Operators to provide per filter input type. query_builder_operators = { select = [ equal, not_equal, is_empty, is_not_empty ], string = [ equal, not_equal, begins_with, not_begins_with, ends_with, not_ends_with, contains, is_empty, is_not_empty ], fulltext = [ contains ], integer = [ equal, not_equal, between, not_between, is_empty, is_not_empty, less, less_or_equal, greater, greater_or_equal ], double = [ equal, not_equal, between, not_between, is_empty, is_not_empty, less, less_or_equal, greater, greater_or_equal ], date = [ equal, not_equal, is_empty, is_not_empty, less, less_or_equal, greater, greater_or_equal ], time = [ equal, not_equal, between, not_between, is_empty, is_not_empty ], datetime = [ equal, not_equal, between, not_between, is_empty, is_not_empty ] } # Whether or not to display the query builder per table. Both this and `query_builder_enabled` must be `1` to display # the query builder for a given table. query_builder_enabled_ca_objects = 1 query_builder_enabled_ca_object_lots = 1 query_builder_enabled_ca_entities = 1 query_builder_enabled_ca_places = 1 query_builder_enabled_ca_collections = 1 query_builder_enabled_ca_occurrences = 1 query_builder_enabled_ca_storage_locations = 1 query_builder_enabled_ca_loans = 1 query_builder_enabled_ca_movements = 1 query_builder_enabled_ca_list_items = 1 query_builder_enabled_ca_object_representations = 1 # Per-table list of filter names to move to the top of the query builder's list, in the order given. Filters can come # from intrinsic fields, attributes or search access points. query_builder_priority_ca_objects = [ ca_objects.idno, ca_object_labels.name, ca_objects.type_id, ca_objects.status, _fulltext ] query_builder_priority_ca_object_lots = [ ca_object_lots.idno_stub, ca_object_lots.type_id, ca_object_lot_labels.name, ca_object_lots.status, _fulltext ] query_builder_priority_ca_entities = [ ca_entities.idno, ca_entities.type_id, ca_entity_labels.displayname, ca_entity_labels.forename, ca_entity_labels.other_forenames, ca_entity_labels.middlename, ca_entity_labels.surname, ca_entity_labels.prefix, ca_entity_labels.suffix, ca_entities.status, _fulltext ] query_builder_priority_ca_places = [ ca_places.idno, ca_place_labels.name, ca_places.type_id, ca_places.status, _fulltext ] query_builder_priority_ca_collections = [ ca_collections.idno, ca_collection_labels.name, ca_collections.type_id, ca_collections.status, _fulltext ] query_builder_priority_ca_occurrences = [ ca_object_lots.idno, ca_occurrence_labels.name, ca_object_lots.type_id, ca_object_lots.status, _fulltext ] query_builder_priority_ca_storage_locations = [ ca_storage_locations.idno, ca_storage_location_labels.name, ca_storage_locations.type_id, ca_storage_locations.status, _fulltext ] query_builder_priority_ca_loans = [ ca_loans.idno, ca_loan_labels.name, ca_loans.type_id, ca_loans.status, _fulltext ] query_builder_priority_ca_movements = [ ca_movements.idno, ca_movement_labels.name, ca_movements.type_id, ca_movements.status, _fulltext ] query_builder_priority_ca_list_items = [ ca_list_items.idno, ca_list_item_labels.name_plural, ca_list_items.type_id, ca_list_items.status, _fulltext ] query_builder_priority_ca_object_representations = [ ca_object_representations.idno, ca_object_representations_labels.name, ca_object_representations.type_id, ca_object_representations.status, _fulltext ] # Per-table list of filter names to exclude from the query builder. Filters can come from intrinsic fields, attributes # or search access points. query_builder_exclude_ca_objects = [] query_builder_exclude_ca_object_lots = [] query_builder_exclude_ca_entities = [] query_builder_exclude_ca_places = [] query_builder_exclude_ca_collections = [] query_builder_exclude_ca_occurrences = [] query_builder_exclude_ca_storage_locations = [] query_builder_exclude_ca_loans = [] query_builder_exclude_ca_movements = [] query_builder_exclude_ca_object_representations = [] query_builder_exclude_ca_list_items = [] query_builder_icons = { add_group = fas fa-plus-circle, add_rule = fas fa-plus-circle, remove_group = fa sfa-times-circle, remove_rule = fas fa-times-circle, error = fas fa-exclamation-triangle } query_builder_plugins = { #sortable = { icon = fa fa-arrows} }