I think I stole that code from someone that knows a lot more than me. I probably got it from this forum a few years ago. What would you replace it with?
This is another case where I have to debug step by step. Break the widget tree at various points, tuck in the message box so the code will finish on the message box. Keep breaking, inserting the message, and reconnecting until you get that error again and not the message box. That helps point to the widget that is causing the problem. Does that make sense?
Something like this:
Direct reference:
DynamicQueryAdapter dQ = new DynamicQueryAdapter(this.oTrans);
dQ.BOConnect();
queryResultDataSet = new System.Data.DataSet();
dQ.RunCustomAction(queryId, actionId, queryResultDataSet);
dQ.Dispose()
Iāll have to give this a shot and add it to my bag of tricks. Thanks!
I got it working. Iām just a goober and had the flow run straight into an error. Must have happened when I went through and replaced the GetDsTree and Checkin/out chunks. This is absolutely awesome!
Can you post updates for Kinetics?
Perhaps, someday I will get it converted. This is one conversion that gave me lots of trouble and I gave up on moving it to kinetic more than three times. Iāll try again at some point and if I get a good conversion I would be happy to post it (if I can figure that part out!)
Will this run in classic mode on Epicor 11?
Yes. I wrote it in Modern. Classic and Modern are the same thing.
Nate I get the following error when trying to Import the getPartRevECOs.baq and getPartRev.baq
Canāt import query definition from version latter than current: 4.2.200.0
Query import finished with error(s)
Thankfully these are both easy BAQs to reproduce. For the first one
select
[ECORev].[GroupID] as [ECORev_GroupID],
[ECORev].[PartNum] as [ECORev_PartNum],
[ECORev].[RevisionNum] as [ECORev_RevisionNum],
[ECORev].[CheckedOut] as [ECORev_CheckedOut]
from Erp.ECORev as ECORev
where (ECORev.PartNum = @part and ECORev.RevisionNum = @rev and ECORev.GroupID = @ECOGroup and ECORev.CheckedOut = true)
And for the second one:
select
[PartRev].[RevisionNum] as [PartRev_RevisionNum],
[PartRev].[RevShortDesc] as [PartRev_RevShortDesc]
from Erp.PartRev as PartRev
where (PartRev.PartNum = @part)
As long as you name the BAQs the same, you shouldnāt have to change any code in the BPMs.
Good luck!
Nate