Assign user, date and time when saving BAQ updateable

Epicor ERP 10
,
1

Good morning, I implemented a dashboard with an updatable BAQ but I need that when I click on save, it assigns me the user who is editing and the date and time, I already managed to do it with a button but it does not work for me that way.
I have tried to do it with a BeforeAdapterMethod method but this window does not show me methods in the wizard.

this is the button code
private void epibtnactu_Click(object sender, System.EventArgs args)
{
EpiDataView V_SegPO_1View1 = ((EpiDataView)(this.oTrans.EpiDataViews[“V_SegPO_1View1”]));
EpiDataView usrV_SegPO_1View1 = ((EpiDataView)(this.oTrans.EpiDataViews[“CallContextClientData”]));
System.Data.DataRow edvUserCharRowPOrel = usrV_SegPO_1View1.CurrentDataRow;
EpiUltraGrid ulV_SegPO_1View1 = (EpiUltraGrid)csm.GetNativeControlReference(“40a88efb-0ee2-4008-8d0d-828eb61ce271”);

	foreach(DataRowView row in V_SegPO_1View1.dataView)
	{
	
	  row["PORel_Fec_edicion_c"] = DateTime.Now;
	  row["PORel_usuario_edita_c"] = (edvUserCharRowPOrel["CurrentUserId"].ToString());
	
	}

		ulV_SegPO_1View1.Focus();
		//oTrans.Update();
}

and the wizard

image
image776×394 17 KB

image
image763×378 20.4 KB

image
image1718×618 40.9 KB

I want to know if there is any other way to call the update method so that when I click on save, it assigns me the data I want.

2

You could use a BPM on the table in question, that checks if any of the fields you are tracking have changed, and if so, set the fields. Should be easy to do a Preprocessing BPM on the Update method.

3

I tried it through BPM but it couldn’t because when doing the TraceData, the businessObject is called Ice.Proxy.BO.DynamicQueryImpl and the Update method, but that businessObject doesn’t let me point to the table where I have to insert the data.

4

Well, another alternative is to do it within the BAQ itself, though you have to be careful with that.

image
image1920×1359 178 KB

BPM Directives Configuration will let you add Preprocess and Post process BPMs to the BAQ itself. The only danger is that if someone comes along and unchecks the updateable box on the BAQ, you will lose those BPMs, even if they check it back on.

5

Hello, thanks for your help, I already have several BPMs that control non-null data for me, but I haven’t been able to assign a data to a field since I can’t find the method to do it.

out there I already tried it, I don’t know if it can be done by customcode.

6

You can create a customization on the dashboard itself, then you can have access to all the same functions you get on screens. We have done this for a few dashboards where we needed functionality we just couldn’t get in the normal dashboard functions. The beforeadapter method you are looking for may be available in customization,

7

@atorres You are in the baq there are no methods. Make a preprocessing directive on update like below.

image

image
image827×370 61.6 KB

image
image

8

I would like to do it through the BeforeAdapter but this window gives me an error

image
image1168×708 23.2 KB

9

Hello thanks for your help, I will try this way.