Application Studio - Filter Dataview Via Textbox - Help Needed

[dgreenEA (Dylan Green)]

I have been trying to filter a datavew based on what the user enters into a textbox. The use case for this is to filter a selection list that is powered by a baq that returns the contents of a UD table. The reason for the baq is so that I can do calculations against the UD table before bringing it into a dataview.

I have an event that captures a change within the textbox and applies the textbox value to a separate dataview. I have confirmed that the data is getting to the dataview and that the dataview holding the data can be read via a separate read-only textbox. Then, when I go into the filter the UD dataview using the dataview filter widget, I cannot seem to get the right syntax. Currently using udDataview.column LIKE ‘??%{searchDataview.column}%’. I assume its syntax related because when the filter is applied, there are no errors, but the dataview does not filter.

I have tried what was used in the conversations had here:

DataView condition expression

this worked Available_Users.Selected = True AND Available_Users.LaborHed_EmployeeNum <> ‘{PmIdHolder.Team1PM}’. Thanks @hmwillett i was missing these fellas ‘{}’ . Thats a pain i have no clue when to use ‘’ when != when <> when {} or etc.

and here:

Kinetic Dataview-filter-set not working. adding BAQ field to grid

Think I found the issue. The column being looked up is an integer. [image] tweaked the dataview-filter-set parameter to: note the lack of quotes JobMtl_MtlSeq={matches.MtlSeq} magic it worked. [image]

Am I missing a step? Is the context wrong? Thanks in advance for the help and for taking the time to look at the post

[dgreenEA (Dylan Green)]

Finally got a syntax that works: “ColumnYouWantToFilter LIKE ‘%{DataviewYouWantToFilterBy.ColumnYouWantToFilterBy}%’”.

I have confirmed this works with my data view in question. The problem now is that I cannot get the selection list to refresh what is shown. I have tried setting its property “Invalidated” to true, refreshing the grid for the component using the refresh grid widget, and refreshing the tree using the refresh tree widget.

Does anyone else have any suggestions on how to get the selection list to filter down when its dataview is filtered?

[dgreenEA (Dylan Green)]

@hmwillett hate to bother you, but do you have any ideas on how I can filter a selection list visually? I have the dataview powering it filtered, but can’t find a good way to get the selection list to show the filtered data.