Forum Discussion
johnjohn-Peter
Jan 23, 2024Steel Contributor
Split my filter into 2 filters one which is delegable and one which is not none-delegable
Inside the screen onvisible, i have this filter statement to build a collection:-
ClearCollect(colSpareParts,ShowColumns(Filter('Spare Parts Asset Types','Asset Type ID'=varWorkOrderATID && ActiveStatus.Value="Active"),"SparePartID"));
Then inside a Combobox items property, i have this statement:-
With(
{
_Start:
Filter(
'Spare Parts', ActiveStatus.Value="Active" And Quantity > 0 And
StartsWith(
Title,
Self.SearchText
) And ID in (colSpareParts)
)
},
Sort(
_Start,
Title
)
)
now part of the statement is delegable and part of it is not , as follow:-
so how i can do the delegable query first, then run the none-delegable part (in operator) on the delegable results?
Thanks
No RepliesBe the first to reply