{# crate_anon/crateweb/research/templates/query_edit_select.html #} {% extends "base.html" %} {% block extrahead %} {% endblock %} {% block content %} {% comment %} {% include "query_nav.html" %} {% endcomment %}
LIMIT row_count or
LIMIT offset, row_count to limit the results,
where offset is numbered from 0 (not 1), and
row_count is the number of records to retrieve
(so LIMIT 50 or LIMIT 0, 50 retrieves
the first 50 records, and LIMIT 50, 50 retrieves the
next 50).SELECT TOP 100 ...
to limit the results to the first 100 rows.
rid = ridvalue with
~pid:dbname = pidvalue or
~mpid:dbname = mpidvalue.
where 'dbname' is the website's name for the database whose
whose rid you want to find (choices are
{% for dbinfo in dbinfolist %}
'{{dbinfo.name}}',
{% endfor %}).
Note:
| Created at | Delete query | Active? | Run since last database update? |
Choose this one | Filter display | SQL | |
|---|---|---|---|---|---|---|---|
| {{ query.created }} | {% if query.active %}{% endif %} {{ query.active|yesno }} {% if query.active %}{% endif %} | {% if query.run_since_update is None %} No information {% elif query.run_since_update is True %} Yes {% else %} No {% endif %} | {% if query.active %} (activated) {% else %} {% endif %} | {% comment %}Widest, so last:{% endcomment %} {% if query.truncated_sql %} | {{ query.truncated_sql|safe }}... Long query. See here | {% else %}{{ query.formatted_query_safe|safe }} | {% endif %}