knash
October 18, 2021, 4:09pm
1
Hello All,
We are looking at creating a multiple selection of items.
In my past life, I would loop through the selected items and manage a table of records for each item.
I see that Epicor uses one field that stores each items selected with a ~ separator.
Just seeing if anyone here has done this before, and what was the results.
The use case is:
Please select from the list all items that are applicable.
Banderson
October 18, 2021, 4:50pm
2
I would use the separate tables if you can. The ~ delimited fields can be a nightmare and a performance hog if you are trying to query against it.
knash
October 18, 2021, 8:12pm
3
That’s the way I’m headed. Now I have to make what I do, upgradable. lol
Banderson
October 18, 2021, 8:16pm
4
Well, one thing in favor of the other way, is that they introduced a list picker in the WEB UI in kinetic that handles the tilde delimited junk . However… I still don’t like it. lol