BAQ's in E10 using multiple views (CTE's & Recursive CTE's)

Epicor ERP 10
21

Thanks for your time in looking at this. Epicor did respond back and basically said this is not possible to do with a UD field and that calculations will not work for Publish and Subscribe.

I will find a way to do it. Will just take a bit more thought.

Thanks again.

Carol

22

Well, this is how you can concatenate rows, do the opposite. (probably not helpful)

This is thread that shows how to add a filter on a grid from a text box. You can probably make this work by getting the value of the cell in the row, and using the contains filter in the grid (so you don’t need to pull apart the tilde fields). It hijacks the grid filter which isn’t ideal is the user what’s to use it, but if that’s not a problem then I think you could get it to work.

You might need @Chris_Conn to help with the C# on getting the row values of the selected row.

23

Lol so basically they DONT exist? Haha I think this was misspoken. Ultimately whether or not you can publish a calculated field, I do not know, although I would image you can, it’s just a value that is broadcast to the subscribers to why not.

I’ve only read bits and pieces so what I am about to type may have 0 relevance.

var myEDV = oTrans.Factory("edvNameHere");
var currentRow = myEDV.dataView[myEDV.Row];
int myString = currentRow["StringFieldNameHere"].ToString();

//assume myString is a concat'd ~ string
string[] values = myString.Split('~');
//now values is an array of your values
foreach(string val in values)
{
  do stuff
}