Creating a "filtered" version of a DataView in Kinetic UI

Kinetic ERP
1

So in Classic I can easily make a filtered view of an existing data view as follows

var edvUD103A= oTrans.Factory("UD103A"); //Get a hold of the existing view
edvVendorInfo = new EpiDataView(); //Create a new View
edvVendorInfo.dataView = new DataView( edvUD103A.dataView.Table, "ChildKey1 = 'VendorInfo'", string.Empty, DataViewRowState.CurrentRows); //Derive the new view as a filtered view of the same data table

The above is great because it stays in sync, if I add new rows to either of the views it updates everything and keeps everything in sync automatically.

I’m trying to do the same in Kinetic I can easily create a new view and set a static filter on it, but I can’t find a way to have it pull automatically from the same dataset as the original view, further more if I do use an event to populate my custom view, any time the original view changes it doesn’t update my new view.

Any ideas? @Ishkaran ?

1 Like
2

How will you be displaying the info? If it’s in a grid, you can add a panel grid to your editor, bind it to the original view, then set a row filter on it from there.

1 Like
3

Yes it would be a grid I’ll try row filter I was using a filter widget instead of a panel grid widget maybe that’s my issue.

PS: Shouldn’t you be on vacation :face_with_raised_eyebrow: lol

4

I aaammm. I think. Lol
I’m not working. YOU’RE WORKING.

1 Like
5

Ok “not working” @hmwillett, Different question; Shouldn’t you be climbing a mountain on Fridays?

1 Like
6

That’s tomorrow. :stuck_out_tongue_winking_eye:

7

There is no Row Filter property on the Panel Grid Card… there’s a Client Filter… but syntax is … (unsure) tried Field=‘xx’ {Field}=‘xx’ {View.Field}=‘’ with no luck so far

8

image
image834×258 8.33 KB

image

9

There’s not a spot for it in the grid model? I swear it was there.
You could also try the Rest param and add a where clause.
Shooting at the hip right now as I don’t have access to a Kinetic environment to validate.

10

Found it, it is ClientFilter the Syntax is

ChildKey1 = ‘LineData’ (Single Quotes)

4 Likes