I have a UBAQ that runs a little C# in post processing GetList to check if a file exists. It works fine in a dashboard because I can filter the grid in the dashboard, but I would like to have it show up in the BAQ gadget, which does not have the ability to filter post BAQ. Does anyone know of a way …

Can I delete rows in the ttTable in the post processing BPM?

Any tips on how to do that? I have a loop going through the grid already to set the exist field to true or false, can I delete the row in there as it loops? Or do I need to loop through this again to do the delete? foreach(var x in ttResults) { string[] files = Directory.GetFiles(x.Calculated_Fi…

So I’m looking at the information in here. And it says you shouldn’t delete or remove in a for each loop. If I don’t loop through the table, how can I know which row to delete? I’m so confused. [image] DataRow Deletion - ADO.NET Learn more about: DataRow Deletion …

One option is to create another array of strings with the filenames to delete. Add the filenames of the files to be deleted in the first loop and then run through the delete array afterwards. Mark W.

I just want to delete the rows in the datatable in order to filter the results. I don’t want to delete the files.

[image] Mark_Wonsil: then run through the delete array afterwards. But not by looping through the array. :slight_smile:

Right you have to loop using a for instead of a foreach and do it backwards.

Ahhh. I thought you needed to “clean up” files that were out there. (Forgot the original business case…). In short, you want to eliminate records that are not associated with a created file in the BAQ itself? The reason you don’t want to delete the same records as the foreach, you may change the n…

[image] josecgomez: Right you have to loop using a for instead of a foreach and do it backwards. What Jose said. :grinning:

File Exists BAQ

Epicor ERP 10

josecgomez (Jose C Gomez) October 24, 2018, 5:35pm 13

for(int i=ttResults.Count-1; i>=0;i--)
{
           ttResults.Remove(ttResults[i]);
}

Removing row from BAQ results on Update

Topic		Replies	Views
Can a BAQ do to file exist search on a network location? Epicor ERP 10	16	1554	September 20, 2018
Dashboard to check if parts exist Epicor ERP 10 e10 , dashboard	23	4391	August 20, 2020
BAQ/dashboard with LINQ query filtering? Epicor ERP 10 baq	13	2446	April 1, 2021
Using a UBAQ in a BAQreport - filtering the data Epicor ERP 10 ubaq	6	716	October 9, 2020
Removing row from BAQ results on Update Kinetic ERP	1	1148	February 8, 2024

File Exists BAQ

Related topics