Question on messaging by Christian Fries, on 13/9/20:
Hi, trying Corteza, I have some questions / unexpected behaviour:
- when I use the field-type “record” in a module, the search field in a record list page (showing records of that module) does not search for the records (record names) as if they were text strings. So using records disables searching for those records.
- when I edit such a record (settings), I can chose field where the query searches in. But that only works within the settings modal dialog. I expected that this also works with the search field in the record list page.
- Can I somehow do complicated SQL code to do inner joins of tables (modules)? Maybe in the Pre-Filter field? Can I use data from other modules in the Pre-Filter field (simple WHERE… SQL statements?)
- Can I use a record-type as a variable as in object oriented programming or as in SQL to get its fields like contact.lastName or contact.telephoneNumber?