Hi All,
I am designing edit in excel experience wherein whatever field is displayed on form has to be made available in excel for editing and publishing. I have created an entity AVACoefficientsEntity for a custom table, since the form for the table AVACoefficients had two data methods, I added two unmapped string fields to the entity. I have set the IsComputedField property to No and to populate data into these two fields I overrode postLoad() method on entity as follows:-
public void postLoad()
{
this.RelationEdit=this.Description;
this.ProductName=EcoResProduct::find(this.Product).productName();
super();
}
Now, this works fine when I open the excel, I find data in these two fields. Insert operation works fine but if I try to delete a row in excel it doesn’t works and throws error:-
Error Publishing Row Details: The deletion of a row in data set Coefficients was not published. Error message: 'No resources were found when selecting for update.'
Since delete doesn’t works so update also fails. If I comment the postLoad method although I do not find data in the two columns in excel but delete, insert and update operations work fine.
The problem is that I can't skip those two unmapped fields and I need those two fields on my excel.
Hi,
Did you ever resolve this issue?
I have the same issue and could use your help.
Thanks!