You can choose to extract all data from a table, or filter it by adding WHERE clauses. You can extract only some fields or add calculated fields. Some more complex queries may not work correctly. If you want to link other tables use the LEFT JOIN ... ON clause.
Adds a filter when the list receives a certain parameter.
Parameters are written as shortcodes and are:
You can also use all the functions of the template engine such as [^ current_post] to get the data of the post you are viewing ([^ current_post.id] for the id).
If required is selected but the value is not passed, the query returns no results. If required is not selected and no parameters are passed, the query returns the unfiltered results
The permissions section appears only when a column is set in the form tab as the author of the record. Once this column is activated, it will be possible to allow you to select which roles can only see and edit your own items. If you also activate the status (publish, draft) column also in the FORM tab, then you will also be able to manage a role for contributors. These can only see and edit their own content, but cannot publish it.
If there is only one table, choose whether or not records can be deleted from the list.
If the query extracts multiple tables, choose which ones should be removed when deleting a file.
If you select no to all tables, then the records cannot be removed in the list.