In the Search widget, we currently have <qfield name="ITS_NAME" />, which of course only returns records where ITS_NAME has a value. I would like to populate the combobox with field ITS_NAME, unless that is empty, then populate with field GTC_NAME. As a result, the combobox will contain all records that have a value for at least one of the two fields. Note: in the database, if a record has ITS_NAME, then GTC_NAME will be empty and vice-versa.
Is there a way to make the <qfield> xml tag conditional?