Hi folks,
I have a canvas app which works locally when searching a collection and yet fails to find the same data using the published version. The SQL data sources are identical and I understand the delegation (or at least I think I do!) limits me to 2000 rows per lookup (default up from 500). I have just under 6000 rows so, in sql I have created specific views which return rows 0-2000, 2001-4000, 4001-6000 of a table. I then create a collection in the canvas app using those data sources as below and then my Filtering uses that colEsrStaff collection.
Really baffled as to why it works in edit mode but not in published - ideas anyone?
Screen onVisible:
ClearCollect(colEsrStaff,'[uvwEsrStaff2000]');
Collect(colEsrStaff,'[uvwEsrStaff4000]');
Collect(colEsrStaff,'[uvwEsrStaff6000]');
The gallery uses this snippet
Items:
If(
!IsBlank(StaffListNameSearchInput.Text),
If(
Find(
" ",
StaffListNameSearchInput.Text
) > 0,
Sort(
Sort(
Filter(
colEsrStaff,
StaffListNameSearchInput.Text in Firstname & " " & LastName
),
LastName
),
Firstname
),
//else
Sort(
Sort(
Filter(
colEsrStaff,
StaffListNameSearchInput.Text in Firstname || StaffListNameSearchInput.Text in LastName || StaffListNameSearchInput.Text in EmployeeNo
),
LastName
),
Firstname
)
)
)
