BAQ Removing Row from ttResults

[AndrewM (Andrew)]

Hi All.

I’m just wondering if there is a way to delete a row from the ttResults table in a BAQ BPM update. Since there doesn’t seem to be a way to programmatically have the BAQ refresh once processing completes, I’d like records that are removed to no longer be in the table.

Any pointers or suggestions are much appreciated.

[Banderson (Brandon Anderson)]

How would you filter rows out of GetRows()

I have done some things in a post processing on GetRows (for other tables… not GL) where I did a BPM that simply removed the rows that we didnt want to show… for Vendor.GetRows, we wanted to hide a specific set… so we put the following line into a C# block: ttVendorList.RemoveAll(ttVendorList_Row => ttVendorList_Row.GroupCode == "PTNR"); maybe you could do something similar to the returned rows from GLAdapter?

[hkeric.wci (Haso Keric)]

@AndrewM

I’m just wondering if there is a way to delete a row from the ttResults table in a BAQ BPM update

If you do it in a Dashboard there is. You can also do it in a UBAQ but the list wont refresh until a Get List is called again.

[AndrewM (Andrew)]

Thanks for the ideas.
The scenario is that I have a UBAQ that is splitting stock on hand into PCID’s. So the BAQ will be a list of the SOH, you select what you want to be split into pallets and process, so it will no longer be SOH. My thinking was that, if I remove the line from the dataset after processing it, I wouldn’t have to do a refresh of the entire BAQ.
I don’t think the GetRows will work since that will only be called upon refresh, I’d imagine. Let me know if I misunderstood.

[Banderson (Brandon Anderson)]

You should be able to remove the row on post processing on the update.