How To: Kinetic BAQ Grid Pub-Sub

Hey folks!
Your friendly, neighborhood Kineticist here with another episode of “How To Kinetic”!
Today, we’re going to talk about how to publish and subscribe two grids of data in Kinetic!
I’ll be using two BAQs, but the principles should remain the same for subscribing to a native grid.
Let’s get started!

  1. Create a new DataView for your primary BAQ grid.

  1. Grab a ‘Panel Card Grid’ from the Toolbox and slap it on your design surface.
  2. Click the grid, then go to Properties > Grid Model and fill out the ‘Ep Binding’ with the ID of the data grid you just created.

image

  1. a) If you want to customize what columns are shown, do so now in the Grid Model > Columns section. Small note about columns from BAQ grids.

  2. Go to Properties > Grid Model > Provider Model and enter your BAQ ID in the ‘Baq ID’ property.

  1. Go to Properties > Grid Model > Provider Model > Baq Options. This is where you can fill out a where clause to filter your results. I have set mine to filter my results based on the Quote Number of the loaded form. If you have multiple filters, you can use the ‘Where List’ section instead.

image

  1. Place a new ‘Panel Card Grid’ on your design surface for BAQ #2.
  2. Go to Properties > Grid Model > Provider Model and enter the ID of your second BAQ in the ‘Baq ID’ property. (You can also take the time to edit the columns in Properties > Grid Model > Columns at this point).

  1. Go to Properties > Grid Model > Provider Model > BAQ Options to fill out the where clause. I used a Where List for this example, so you may see how it’s configured.

image

Column: This is the column from BAQ2 you wish to filter on. Make sure you use the full column name from the BAQ (IE, OrderHed_OrderNum).
Condition: Condition to filter by. I set mine to equals or ‘=’.
Value: This is going to be the value from BAQ1 in the format of ‘??{DataView.FieldName}’. Recall that I named my DataView “RelatedOrders”. The two ‘??’ means we can pass a null value back.

That’s it! Save and Preview your layer and you should see your grids working!

3 Likes

And I am bookmarking a search for #experts-corner @willetta

https://www.epiusers.help/search?expanded=true&q=%23experts-corner%20@willetta

Awesome work, Aaron. Thank you.

1 Like