How To: Adding Columns to Existing Kinetic Grid

Use a BPM, dammit! (See original post)

Version 2

This version is slightly more efficient.
It uses a BAQ to grab all the relevant records in the quote and populate the BAQ View at once instead of doing REST calls every iteration.

  1. Create a BAQ that contains the Primary Key of the native grid and the fields you want to add from the associated table.

  1. Create a view to hold your BAQ information.

  1. Add your new columns to the native View (QuoteDtl).

  1. Create a “No Trigger” event that’s going to start with an “erp-baq” call.

  1. Configure the “erp-baq” widget to call your BAQ and filter it based on your primary key (QuoteNum)

image

This allows you to have all of the information available at the get-go instead of having to get it each time.

  1. Add a condition to make sure something came back.

image

  1. Off of the TRUE node, set up a “dataview-condition” just like the original post. For details, see the first post in this thread.

  1. Create an iteration event and wire the “No Trigger” to a “dataview-filter-set”. The idea behind this is you’re going to filter the BAQView to only the row you need for each iteration.

  1. Then, do a “row-update” and set the row in the “matches” view to the corresponding row in the BAQView that you filtered.

  1. Lastly, wire up the “AfterGetByID” event to your initial population event.

AddColumnsToViews_BAQ

Much faster!

15 Likes