14.3.194. crate_anon/crateweb/research/templates/sqlhelper_form_text_anywhere.html

{# crate_anon/crateweb/research/templates/sqlhelper_form_text_anywhere.html #}

{% extends "base.html" %}

{% block content %}

    <h1>Create SQL fragment: Find text anywhere</h1>

    <div>Database from which RID descriptions are taken:
        <b>{{ db_description }}</b></div>

    <div>Enter a fragment of text. SQL will be generated to find it in any
    of the text fields present in the database. The LIKE operator will be used
    for plain text fields, and an appropriate faster method will be used for
    fields having a free-text index.</div>

    <form action="{% url 'sqlhelper_text_anywhere_with_db' db_name %}" method="post">
        {% csrf_token %}
        <table class="formtable">
            {{ form.as_table }}
        </table>
        <input type="submit" name="submit_save" value="Save SQL as query" />
        <input type="submit" name="submit_run" value="Run" />
        <input type="submit" name="submit_view" value="View SQL" />
    </form>

{% endblock %}

{% block helpurl %}{{ HelpUrl.sqlhelper_find_text_anywhere }}{% endblock %}