Does the BAQ Designer support the STRING_SPLIT function like in SQL?
I am trying to convert the query above into a BAQ. However, I do not see a string split option anywhere. Any help would be much appreciated
I think this thread should get you there: How to add a cross apply to a BAQ
Also, if you are on the latest version, I believe you can test the SQL to BAQ feature… I would be curious how it handles that one.
3 Likes
Thank you!
Epicor gave us a cheat for that. Since they jam a ton of ~ separated values into a single field/variable (looking at you SalesReps). Should work in the BAQ and in BPM’s as I recall.
[Ice].entry(index,table.fieldname,‘separator’)
I think the index starts at 1.
See Also: KB0030301
2 Likes