Hi, I am trying to build an application from a MSSQL server source. I have to filter the fields of a gallery and, the filtering options consist of 5 text boxes and two combo boxes. I am using the structure below but, although the syntax is correct it only filters when I type in the first text box.
PS: You will notice that although I have spoken of combo boxes there is nothing that makes reference to them in the code. If someone could tell me how to incorporate them correctly I would also appreciate it, since I see that the syntax has been changing over time in the application and I have not found current documentation about it.
The code:
SortByColumns(
Filter(
'DATASOURCE';
StartsWith(SQLFIELD1; Entidad.Text);
StartsWith(SQLFIELD2; Familia.Text);
StartsWith(SQLFIELD3; Empleador.Text);
StartsWith(SQLFIELD4; Patologías.Text);
StartsWith(SQLFIELD5; Dirección.Text)
);
"SQLFIELD1"; SortOrder.Ascending;
"SQLFIELD2"; SortOrder.Ascending;
"SQLFIELD3"; SortOrder.Ascending;
"SQLFIELD4"; SortOrder.Ascending;
"SQLFIELD5"; SortOrder.Ascending
)
Thank you very much in advance!
