{{ get_hidden_inputs(db, table) }}
{% trans 'Do a "query by example" (wildcard: "%") for two different columns' %}
{% if geom_column_flag %} {% endif %} {% set type = [] %} {% set collation = [] %} {% set func = [] %} {% set value = [] %} {% for i in 0..3 %} {# After X-Axis and Y-Axis column rows, display additional criteria option #} {% if i == 2 %} {% endif %} {% if criteria_column_names[i] is defined and criteria_column_names[i] != 'pma_null' %} {% set key = keys[criteria_column_names[i]] %} {% set properties = self.getColumnProperties(i, key) %} {% set type = type|merge({(i): properties['type']}) %} {% set collation = collation|merge({(i): properties['collation']}) %} {% set func = func|merge({(i): properties['func']}) %} {% set value = value|merge({(i): properties['value']}) %} {% endif %} {# Column type #} {# Column Collation #} {# Select options for column operators #} {# Inputbox for search criteria value #} {% endfor %}
{% trans 'Function' %}{% trans 'Column' %} {% trans 'Type' %} {% trans 'Collation' %} {% trans 'Operator' %} {% trans 'Value' %}
{% trans 'Additional search criteria' %}
{{ type[i] is defined ? type[i] }} {{ collation[i] is defined ? collation[i] }} {{ func[i] is defined ? func[i]|raw }} {{ value[i] is defined ? value[i]|raw }} {# Displays hidden fields #}