A special field type for organizing more complex relationships between entities.
The field type "MySQL query" makes it possible to build a query to an entity (table) according to a given condition. The query is built automatically, you only need to specify the parameters by which the data will be sampled.
Select from entity
Specify the entity to which the MySQL query will be built.
Specify the field to be selected in the query. For example: , where 12 is the id of the numeric field. You can select any field types and use MySQL functions.
Note: the query must return only one value.
Examples of standard queries
Maximum field value: MAX ()
The sum of all values in the column: SUM ()
Total number of entries: COUNT (*)
A query with the condition: IF (> 100, 'Yes', 'No')
Using the field IDs, specify the conditions for what should be selected in the query.
Examples of standard conditions
Comparison of one field:  = .
Comparison across several fields:  =  AND  = 
Example of a MySQL condition IN:  IN (10,20,30)