Implementing a "grocery store check out" - Best way to use a grid?

I'm looking to implement something similar to a grocery store check out in CSI 9. Our stockroom will bring a bunch of bar coded tags from a restock location. These tags will get scanned one by one and I want the corresponding entry from my IDO/Collection to show up in the grid.

Does this mean I have to store each of the codes scanned & modify the Collection Filter each time to be "(code=A) OR (code=B) OR (code=C)" etc?

What I ultimately want to do is have the grid populated with all of the entries to process & then the user clicks the "Process" button & each of the entries gets processed.

Find more posts tagged with

Accepted answers

Legacy Contributor

Don't overthink this, adding that IDO gives you the control you want.

Persisting it also allows someone to recover a scanning batch in the event of a disconnect/lost session.

You can invest the extra thinking time into a janitor which can be run as a scheduled background task to cleanse old entries for abandoned scanning batches.

All comments

BradleyBrown

You could generate a batch id and use that as part of your filter.

Stephen Cena

The more I look at this, the less likely I want to use a Grid. Grid's are based off of a Collection. When the users scan things in, I want them to be able to manage the list (ie: remove an incorrect item from the list). I don't want the delete to remove the entry from the main collection just the display.

I don't think I'm seeing how a batch ID would help me. When the user scans the unique bar code, its entry needs to get added to the list. The Grid would need to show all of the items scanned in to date which means a Collection has to be updated somewhere.

I'm debating switching over to a List component with multi-select. Right now, other coding issues to worry about.

Thoughts?

Legacy Contributor

I tend to agree with Bradley, you have a scanning batch with a sub-collection of barcoded items, this can x-reference a master IDO containing most of the information you want to x-reference so your scanning batch just contains the batchID and a collection of barcodeIDs which provide the link to the master data. maybe a quantity unless each item can be scanned multiple times (which would be more like a standard grocery list where you see multiples of the same product).

Stephen Cena

And that's my issue right now. I don't want to add another IDO or collection. Or perhaps I'm missing something still. This is my second "year" as a CSI developer and I'm still trying to understand certain things. I would have to have a separate IDO that the entries get scanned into, otherwise if the users manipulate the Grid they are messing up the data (ie: deleting an item from the collection versus removing it from the Grid display).

Legacy Contributor

Use a temp table, tie it through a method in a custom IDO, then update into your main IDO as the user confirms the data

Legacy Contributor

Stephen Cena

I slept on it & I agree. As much as I don't want to add another IDO/table, it makes sense. My master data lives in the SLItemLocs & the transient/temporary can live in the new one. When the items get processed, I simple clear out the SLItemLocs UETs & all is well.

Once I work out how I magically broke my calling an IDO Ext. Class Method, this will be my next move.

Getting the Most Out of Landmark Embedded Reporting.pdf

Copyright © 2025 Infor. All rights reserved.