Loop through selected records

(1) Share

Report

Posted on by Andrew Huisman

313

Hello everyone,

I found a lot of information online about how to loop through the selected records of a grid, but for some reason for me, it's only grabbing the last record I have selected. I wanted to post my code and see if anyone notices something I'm doing wrong.

First, here is a print screen of the form I'm working on. I pick the lines in the lower grid and then click Print Item Label which opens another form that should list the items selected so I can print labels

The datasource for the second grid is WMSArrivalDetailTmp

Here is my code that is running in the init method on the next form (for printing labels)

selectionHelper = MultiSelectionHelper::construct();selectionHelper.parmDatasource(element.args().record().dataSource());wmsArrivalDetailLoop = selectionHelper.getFirst();if (wmsArrivalDetailLoop.RecId){     while (wmsArrivalDetailLoop.RecId)     {          select salesLine               where salesLine.SalesId == wmsArrivalDetailLoop.InventTransRefId               && salesLine.ItemId == wmsArrivalDetailLoop.ItemId          join inventDim               where inventDim.inventDimId == salesLine.InventDimId;          if (salesLine)          {               table.ItemId = salesLine.ItemId;               table.Name = salesLine.Name;               table.TCI_UserID = curUserId();               table.TCI_Warehouse = inventDim.InventLocationId;               table.TCI_Location = inventDim.wmsLocationId;               table.NumOfLabels = abs(salesLine.ExpectedRetQty);               table.insert();          }               wmsArrivalDetailLoop = selectionHelper.getNext();     }}

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Andrew Huisman 313 on at

Like (0)

Report
Copy link

Link copied!
I'll repost the code to make it readable

selectionHelper = MultiSelectionHelper::construct(); selectionHelper.parmDatasource(element.args().record().dataSource()); wmsArrivalDetailLoop = selectionHelper.getFirst(); if (wmsArrivalDetailLoop.RecId) { while (wmsArrivalDetailLoop.RecId) { select salesLine where salesLine.SalesId == wmsArrivalDetailLoop.InventTransRefId && salesLine.ItemId == wmsArrivalDetailLoop.ItemId join inventDim where inventDim.inventDimId == salesLine.InventDimId; if (salesLine) { table.ItemId = salesLine.ItemId; table.Name = salesLine.Name; table.TCI_UserID = curUserId(); table.TCI_Warehouse = inventDim.InventLocationId; table.TCI_Location = inventDim.wmsLocationId; table.NumOfLabels = abs(salesLine.ExpectedRetQty); table.insert(); } wmsArrivalDetailLoop = selectionHelper.getNext(); } }

Was this reply helpful? Yes No
Martin Dráb 240,345 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Your code returns selected records and your screenshot shows a single selected record, therefore the result is correct.

But selected records apparently isn't what you want. You want records with a particular value of Select of arrival column. To know how to implement it, you need to find out the data source of the column. If it's a table field, you can simply use a query. It may also be, say, an edit method backed by a collection (e.g. Set class). In that case, you need to simply iterate the collection.

Was this reply helpful? Yes No
Suggested answer

Andrew Huisman 313 on at

Like (0)

Report
Copy link

Link copied!
Martin,

Again, you have come to my rescue. I figured it was something simple like this. Thank you so much.

For anyone who wants to know, here is my code now and it's working perfectly

while select wmsArrivalDetailTmp where wmsArrivalDetailTmp.Selected == NoYes::Yes { select salesLine where salesLine.SalesId == wmsArrivalDetailTmp.InventTransRefId && salesLine.ItemId == wmsArrivalDetailTmp.ItemId join inventDim where inventDim.inventDimId == salesLine.InventDimId; if (salesLine) { table.ItemId = salesLine.ItemId; table.Name = salesLine.Name; table.TCI_UserID = curUserId(); table.TCI_Warehouse = inventDim.InventLocationId; table.TCI_Location = inventDim.wmsLocationId; table.NumOfLabels = abs(salesLine.ExpectedRetQty); table.insert(); } }

Was this reply helpful? Yes No