We have an updatable BAQ for a Preflight dashboard, when a “Preflighted” flag (UD) changes from false to true, we send an email for notificiation via a BPM. This all works fine in classic/smart client, but in Kinetic-Web the condition fails so the email does not get sent. I have verified the BPM i…

[image] Olga: queryResultDataset.WriteXml(@“c:\temp\name.xml”, XmlWriteMode.WriteSchema); I’m getting this error: ‘QueryResultDataSetUbaqTableset’ does not contain a definition for ‘WriteXml’ and no accessible extension method ‘WriteXml’ accepting a first argument of type ‘QueryResultDataSet…

So it is not dataset, it is tableset with dataset name. then you cannot use this method. I don’t remember if any dump method for tableset exist, so you have to use usual foreach to go through table rows.

Hi I would do this via a BAQ and a Function - schedule the function to run at various times of the day to email a list of things that a user needs to action

[image] SueLowden: schedule the function to run at various times of the day to email a list of things that a user needs to action This is the way. Very, very, very rarely should you fire off an alert immediately. Better to batch items and send them out periodically. Cuts down on inbox clutter…

Yep, let’s all stop “spamming” our internal users each time something happens in Epicor, lets just inform them, as I say, of the list of things that they need to manage

[image] datadaddy: ‘QueryResultDataSetUbaqTableset’ does not contain a definition for ‘WriteXml’ and no accessible extension method ‘WriteXml’ a [image] Olga: So it is not dataset, it is tableset with dataset name. [image] Convert Erp.Tablesets to System.Data.DataSet E…

So it turns out the email is not being sent because the condition fails…more on that below, first… I’m not saying the “less spam” idea is bad, it may work for some companies better than others and depend on the circumstance (timing, frequency, urgency), the main point is Method Directives are suppo…

[image] datadaddy: there is no queryResultDataset this sounds wrong. I don’t think it is true. You probably need to report it with very simple UBAQ/BPM attached for the investigation. Meanwhile you can use some other condition, like check DB instead of checking incoming tableset.

My main suspicion is that in classic, there are 2 records set from the client - before changes and changed. And maybe the condition you use relies on this information. In REST it is not required and overall should not be used, because server should not rely on info sent by client. But maybe in your…

[image] Olga: In REST it is not required and overall should not be used, because server should not rely on info sent by client. But maybe in your case it is essential for condition to work. That is an interesting statement. I don’t think an inconsistency like that is acceptable.

Kinetic, UBAQ, BPM works in classic but not web (Hints)

Kinetic ERP

klincecum (Kevin Lincecum) September 22, 2023, 1:26pm 11

Convert it to a dataset first, and then you can use WriteXML to dump it without having to loop through the rows.

Topic		Replies	Views
Kinetic UI Dashboard with BPM on BAQ GetList does not trigger the BPM Kinetic ERP epicor , baq , dashboard	40	2218	April 25, 2024
Kinetic Dashboard, Updatable BAQ, BPM Behavior ? (Conversion from Classic) Kinetic ERP	2	1132	December 28, 2023
Updateable BAQ Epicor ERP 10	16	5612	January 31, 2022
Updateable BAQ - Select All and Update All Kinetic ERP epicor , kinetic	9	4415	March 29, 2022
Need C# help on BPM Method code Kinetic ERP	9	1115	July 5, 2023

Kinetic, UBAQ, BPM works in classic but not web (Hints)

Related topics