App Studio Split Widget

@Ishkaran is there a way to get the split widget to add the split values as rows in the view instead of it adding them as columns?

And if I can get them into rows, is there something I can do to loop through all of the rows to do extra processing?

I don’t know of a way to split them into different rows at the UI level. However, I have always found it easy enough to split and pivot data server side via a BPM and or BAQ when needed. I generally find implementing and supporting data transformations and changes far simpler server side.

1 Like

Plan B is to use a function to do it and have that function return a dataset which I can bind to my grid.

Plan A is to struggle in App Studio and find creative ways to do things, so I can learn it better.

Trying not to resort to Plan B unless I don’t have a choice.

4 Likes

Here is a video that talks about how do you loop through rows in a dataview and process individual rows… It is not for the example that you mentioned, but on similar lines.
https://epicor-my.sharepoint.com/:v:/p/ishkaran_talwar/EfTPWpJEZaBIu4Riw2TuamUBixQFyrOWquE2yLCA8TkvoQ?e=edWvGA

Regarding splitting the delimited values and adding them as new rows. Would need to somehow glue the split event-action and row-add event action. I will get back on this.

6 Likes

:100: client-side-first is the way if only to learn but also to push at the fringes with hope that more power is granted client-side - or at least not taken away.