How to prevent editing records in tables on basis of an enum field in the tale.

(0) Share

Report

Posted on by Community Member

I need to prevent modifying certain records in a table. I need to put this condition on the table level, as there are different forms using this table and I cannot put lock on every form. I have an enum field in this table and I need to prevent updating that record if the enum field is populated as 'Yes'.

Please suggest me the code and where I need to add this code.

For Example: I have a customized field in the invent table and I want to prevent editing those records which have this field populated as 'Yes'. I want to prevent this editing at table level itself.

i.e. We should not be able to edit these records from anywhere in ax.

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

Mohsin Khalid 501 on at

Like (0)

Report
Copy link

Link copied!
Hi Hasit ;

Unfortunately you cannot disable those records from being editable on the form unless you do an allowEdit(false) on the active method of the form or the datasource, However if you simply want to prevent the update from happening from anywhere in AX for those records then override the aosValidateUpdate() method on your table and fail the validation if your enum value is yes, see below code for example.

public boolean aosValidateUpdate() { boolean ret; ret = super(); if (this.EnumField == NoYes::Yes) ret = false; return ret; }

Please note that above code will have a performance impact on update of this table because your flag will be checked for each update.

Was this reply helpful? Yes No
Suggested answer

Mea_ 60,286 on at

Like (0)

Report
Copy link

Link copied!

I think better solution is to use XDS, using it you can give view access to certain users to records base on field value. I cannot give you code example because it requires multiple objects to be created, but it's well explained here www.microsoft.com/.../details.aspx

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thanks Mohsin, that was useful.

I tried your code.

I found that this is blocking editing on those records which have the enum field as 'yes' and allowing editing those with enum field as 'no' .

But if I want to change the enum value of one record from no to yes , I am not able to do so (even this is blocked from editing) .Please let me know why I am not able to change the enum value from no to yes and mention the code change I need to do.

Was this reply helpful? Yes No
Verified answer

Mohsin Khalid 501 on at

Like (0)

Report
Copy link

Link copied!
Yes for that consider adding the below check to the condition. FYI the orig() method returns the value before your mod.

public boolean aosValidateUpdate() { boolean ret; ret = super(); if (this.EnumField == NoYes::Yes && this.orig().EnumFild == noYes::Yes) ret = false; return ret; }

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thank you Mohsin, for your timely help.

You understood my issue perfectly and this solution works as expected.

Was this reply helpful? Yes No