Referencing a list of fields

Learn how to reference a list of fields.

If the list starts with "regex:", the remainder is treated as a regular expression that is evaluated against all fields of the referenced table. Otherwise, it is treated as a comma-separated list of fieldnames, with two possible wildcards:

• "*": all fields of that table, excluding virtual fields
• "**": all fields of that table, including virtual fields

For a list of field types, see FieldTypes and Categories.

Example: Reading all "Free" fields of a table (fields which name start with Free)

      <request>
        <query>
          <tables>
            <table tablename="Company"/>
          </tables>
          <fields tablename="Company" fields="regex:Free.+"/>
          <condition>
            <cond tablename="Company" fieldname="Company" op="=" value="Test"/>
          </condition>
        </query>
      </request>