I have a grid with few columns. I also have a text field. When user will start to enter text in text filed I would like to filter grid and display only those rows where at least one column contains text entered by user.
So basically I would like to apply following formula:
Show only rows where GridColumn1.Contains(textfield.text) OR GridColumn2.Contains(textfield.test) OR GridColumn3.Contains(textfield.text).
This should be dynamic as user is adding or removing characters - rows should appears or disappears.
Is dataview-filter-set enough for this or not?
@hmwillett maybe you have some idea?
We have here basically 2 issues.
- To capture changes when text field is updated on the fly (character by character)
- To filter dataView rows with âORâ operator.
It would be, however, the textbox does not seem to have a text changed event.
I also cannot seem to be able to figure out how to get the value out of a control.
I tried to bind it to the CallContextBPMData, or the TransView to get data out of it,
but just typing in the control wonât set those 
Best I could get was to add a textbox, set itâs EpiBinding to a field in TransView.MyField.
On the OnBlur event (when it loses focus) add a dataview-filter-set for the dataview, and
add a filter like Part_PartNum LIKE '%{TransView.MyField}%'
It only works on things that are actually loaded in the dataview, it will not load more.
Testing it I sometimes found it unreliable.
If you can manipulate the pagesize somewhere to load the whole dataview, you might be ok.
Depends.
Playing with row rules almost gets you there nicely too, except it wonât let you hide rows 
Both questions are still open.
1 Like
Since these questions remain open, I figured Iâd add to this. I am trying to filter a selection-list as the user types in a textbox. I created a Control-OnBlur event for the textbox.
There I added the dataview-filter-set for the dataview my selection-list is bound to and filtered it:
Calculated_EquipIDWithDescription LIKE â%{CallContextBpmData.Character01}%â
No errors, but nothing happens when I type in the txtbx or tab out of it⌠Maybe my filter is setup wrong? Do I have to refresh the dataview after itâs filtered?
Only 2 years late. Itâs cool. 
JobHead_PartNum LIKE '%value%%' OR JobHead_JobNum LIKE '%value%%'
%value% holds the âChangingâ value.
Adding a second % makes it akin to a starts with. Use %%value%% for a contains.
DataTable.ColumnChanging used to do this, but it does not seem to anymore. Iâll have to play around.
1 Like
Lots of weirdness in version 11.2.400.9. I setup my dataview-filter-set param and filter it accordingly using TransView.ToolFilter. I event made the event just a button click. Trace shows the event is doing what it is supposed to do:
Available selection list remains unchanged:
My available tools should be blank.
I know the widget is supposed to filter the dataview, but should I run the BAQ that populates it again?
I missed the bit about the selection-list (was looking at the post title saying âgridâ).
Selection list works differently. Instead of the dataview-filter-set, you just call the BAQ that populates the source again, but include your filter in the execute options.
1 Like
Sorry for taking forever in responding here. Must be my version (11.2.400.9); selection list refuses to cooperate. When I change the value, I can see itâs running the BAQ with my filter, but itâs not updating the dataview bound to the selection list control. The same dataset that it gets when the screen loads continues to display.
Let me see the properties for your list.
