Hi Guys I’ve got an updateable BAQ that I’m calling from a customisation. The updateable BAQ works correctly in the BAQ editor but I’m getting an exception (Can’t find query definition in passed dataset) when calling the queryAdapter.Update method from a customisation. I have the following code: D…

I think it needs yourbaq.GetByID("BAQNAME"); in there before the part you’re having trouble with. It’s looking increasingly like I should have taken a bit more time when I put that original post together.

ExecuteByID doesn’t return an updateable DataSet. You need to use Execute instead in the first part of the code, then Update will work correctly.

Thanks Darly, I’ve tried updating that with the following code but I get the same error (this time at the queryAdapter.Execute method call). queryAdapter.Execute(queryAdapter.DynamicQueryData, dataSet); I think it’s the queryAdapter.DynamicQueryData, when I look at it in the data visualisation too…

[image] Rik: queryAdapter.GetQueryExecutionParametersByID(“BAQName”); I’m assuming you actually put the name of the BAQ in here right?

Yes … I was getting deja vu, so I found this: [image] Add an updateable dashboard ERP 10 OK, here’s the core code we use - I’ll detail some things to note after it: DynamicQueryAdapter yourbaq = new DynamicQueryAdapter(this.oTrans); DataTable results; yourbaq.BOConnect()…

Apologies if this is something obvious but it looks like your setting the dsQuery to the termsAdapter.DynamicQueryData but I can’t see that termsAdapter being setup anywhere?

You assume correctly mate, it was just a meaningless name so I wanted it to be clearer.

I think this is going to keep coming back to bite me and I’d better go and edit that post … It was a botched copy-and-paste, and “yourbaq” is defined at the top and “termsAdapter” should read “yourbaq” throughout. If you read down the thread you’ll see that’s already bitten someone else. [Edit - I…

Ah okay that makes sense (sorry I should’ve read the other posts). I’ve updated the code to reflect yours but now I’me getting an interesting “Sequence contains no elements” exception when this bit of code is hit: Ice.BO.QueryExecutionDataSet dsBAQ = yourbaq.GetQueryExecutionParameters(dsQuery); W…

Thanks for all your help Daryl! I had to add in the results code again but that works now! You’ve really help me out there mate, not sure if I’d have been able to solve that on my own! :slight_smile:

Updateable BAQ in customisation error: Can't find query definition in passed dataset

Epicor ERP 10

dhewi (Daryl Hewison) November 25, 2019, 3:26pm 5

Yes … I was getting deja vu, so I found this:

Topic		Replies	Views
Run Updateable BAQ from customisation [C#] Epicor ERP 10	21	10967	June 19, 2020
Dynamic Query write updates back to database Epicor ERP 10 e10 , customization , baq , dynamic-query , ubaq	26	7438	November 20, 2020
More than one UBAQ in a Dashboard? Epicor ERP 10 dashboard , ubaq , updatable-dashboard	44	7256	August 15, 2019
E10 Execute BAQ In Customization Yahoo Archive	32	7239	January 29, 2015
POEntry Customization - BAQ Adapter Exception Epicor ERP 10 e10 , epicor , customization , baq	1	558	September 12, 2023

Updateable BAQ in customisation error: Can't find query definition in passed dataset

Related topics