Hi there,
funny stuff happening. I have a kind of search/filter screen in my app that allows users to filter for different aspects of the SP list.
Item property of gallery:
Filter(
retrievaldata,
IsBlank(cvar_filter_mode) || mode.Value = cvar_filter_mode,
IsBlank(cvar_rv_select) || rv_flag = cvar_rv_select, //all boolean filters have a delegation problem, needs fixing before >500records
IsBlank(cvar_mm_select) || 'm&m_flag' = cvar_mm_select,
IsBlank(cvar_dcl_select) || approved = cvar_dcl_select,
IsBlank(Search_NHI.Text) || NHI = Search_NHI.Text,
IsBlank(Search_name.Text) || PatName = Search_name.Text,
IsBlank(cvar_filter_doc) || doc.Value = cvar_filter_doc Or doc_buddy.Value = cvar_filter_doc,
IsBlank(cvar_filter_nrs) || nurse.Value = cvar_filter_nrs Or nrs_buddy.Value = cvar_filter_nrs,
IsBlank(cvar_filter_date_start) || dpt_TPWO >= cvar_filter_date_start,
IsBlank(cvar_filter_date_end) || dpt_TPWO < DateAdd(date_end.SelectedDate, 1, Days),
IsBlank(cvar_comment_search) || rv_comment <> Blank()
)
Until I added the pink line the statements in the red lines worked fine, after adding the pink line they stopped working and returned empty galleries.
cvar_comment_search is set by the OnCheck/OnUncheck properties of a checkbox as follows:
OnCheck: UpdateContext({cvar_comment_search: true})
OnUncheck: UpdateContext({cvar_comment_search: true})
Same methodology is used for the cvar's in the red lines, but they are set to 1 or 0 to work with the SP list oddity in "handling" booleans.
What I am trying to achieve with the pink line is that the gallery shows all records where the comments field (multiline text) is not empty.
Happy about any suggestions here.
Hansjoerg
