Event Handler class to refresh a Form

(0) Share

Report

Posted on by Community Member

Hi guys,

If I create a class which is an Event Handler class for a table : OnIsert, how to make Form whereby I trigger the insertion, to refresh all it's field ?

So this is the class (header) looks like :

class MyCaseAssociationOnInsert

{

[DataEventHandler(tableStr(CaseAssociation), DataEventType::Inserted)]

public static void CaseAssociation_onInserted(Common sender, DataEventArgs e)

{

…… <some code>

}

So basically the table is CaseAssociation, and the Form I referring is Case form, inside there is Case Association. My purpose for this Event handler is, when user ADD Case Association, it will trigger some action / job, and in that part will also update some of the fields in the Case Detail it self, like some fields in General section above it.

72207.Capture.PNG

The Event Handler is running fine, only the information is not refresh, and I need to press Refresh button to make it updated. However with those parameter -> ( Common sender, DataEventArgs e ) --> I cannot see a possibility to reach the caller form data source to make it refresh automatically.

Kindly advice,

Thanks

I have the same question (0)

All responses (10)

Answers (1)

Blue Wang on at

Like (0)

Report

Hi WWwong,

Have you used datasource.refresh() or datasource.research(true)?

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,162 Moderator on at

Like (0)

Report

If you hook in the insert event of a table, you can't indeed reach the form that did the insertion. This is true also without event handlers.

After all, the insert method of a table can be called from many places, not just the form. If you wish to add some logic specific to a form, you need to develop your code on that form (or CoC / event handler of that form).

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Blue,

I thought so, but the object, like "sender" only give me a short option ->

How exactly the code will looks like ?

Thanks,

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,162 Moderator on at

Like (0)

Report

In table event handlers, sender is of type "Common" as mentioned. It has no relation to some form that might be inserting data to the table.

Was this reply helpful? Yes No
Suggested answer

Sergei Minozhenko 23,093 on at

Like (1)

Report
Hi Wwong,

You can access FormDataSource from record level by code below, but as Nikolaos mentioned, in this case, it will be applied to all forms where this table is used. It's much safer to implement the same change on the form level.

if (sender.isFormDataSource()) { FormDataSource fds = sender.dataSource(); fds.reread(); //or executeQuery or research(true) }

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Nikolaos,

So if by any chance I'm still using that class to insert (and update the table) that actually the underlying data source of that form, I can create another Event Handler from the CaseDetail Form like you told me, right?

I just tried it, by create a new class, like this :

class MyCaseDetailCaseAssociationOnCreated

{

/// <summary>

///

/// </summary>

/// <param name="sender"></param>

/// <param name="e"></param>

[FormDataSourceEventHandler(formDataSourceStr(CaseDetail, CaseAssociation), FormDataSourceEventType::Created)]

public static void CaseAssociation_OnCreated(FormDataSource sender, FormDataSourceEventArgs e)

{

sender.reread();

sender.refresh();

}

}

But somehow, it doesn't work. Logically it should work, right?

Thanks,

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,162 Moderator on at

Like (0)

Report

The onCreated event is not corrected, since that fires when the record is created but not yet inserted.

Try the onWritten event.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Btw, just realize. This CaseDetail form contains many Data Sources, including Case Association and CaseDetail Base.

The new EventHander I created, which is now as suggested is OnWritten, the "Sender" parameter, does it connect to CaseAssociation table only ? Which mean if I tell to : Sender.Refresh() --> it will refresh Case Association only, not the rest of data source including CaseDetailBase ?

and should I have 2 lines, reread() and refresh() ?

I read many time about these refresh/reread/research but still not very clear and confident on how and which one or two I should use.

Thanks,

Was this reply helpful? Yes No
Verified answer

nmaenpaa 101,162 Moderator on at

Like (0)

Report

Now the discussions starts deviating from your original question.

Anyway, if you develop event handler on form data source, the sender points to that data source.

However via that sender you can access the FormRun and all other data sources, controls, methods etc of the form.

Refreshing the main data source of the form should refresh all others automatically as well. You can easily test it yourself.

And, you should call formDataSource.refresh(), followed by formDataSource.research(true) as instructed in the very first reply above :)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Actually no, I'm still persistence on how to refresh my form :)

Only my bad is still using the existing table event handler and try the workaround by create form event handler as your suggested.

Anyway solved it. As suggested, I went to FormRun first ->

[FormDataSourceEventHandler(formDataSourceStr(CaseDetail, CaseAssociation), FormDataSourceEventType::Written)]

public static void CaseAssociation_OnWritten(FormDataSource sender, FormDataSourceEventArgs e)

{

FormDataSource CaseDetailBase_ds = sender.formRun().datasource(formDataSourceStr(CaseDetail,CaseDetailBase));

CaseDetailBase_ds.refresh();

CaseDetailBase_ds.research(true);

}

Case closed.

Thanks to you all.

Was this reply helpful? Yes No