Data Extension value of employee

[Mi!]

I have created a new data extension through EMC at the Employee level, and it has added as a new column in Employee
With the name of the data extension.

I want to get the newly added column data in the extensibility application. I tried by calling DataStore.ReadEmployeeByID
But the new column property is not coming. How can i access the new column value of the employee?
Any help is greatly appreciated.

 

[goodbody]

You can according to this blog to get data extension.

microsblogs/documents/part9/README.md at master · simphonydeveloper/microsblogs

micros simphony and res 3700 development information.Please give me a ⭐⭐ - simphonydeveloper/microsblogs

github.com

 

[Mi!]

You can according to this blog to get data extension.

microsblogs/documents/part9/README.md at master · simphonydeveloper/microsblogs

micros simphony and res 3700 development information.Please give me a ⭐⭐ - simphonydeveloper/microsblogs

github.com

I have added some value to the new column in Employee.

I was able to get the Employee level extension value with DataStore.ReadExtensionDataValue. But I want to get employee's new field value corresponding to each employee in the employee object.

When i call DataStore.ReadEmployeeByNum or ReadEmployeeByID i can't find this field.

How can I achieve this?

 

[goodbody]

As far as I know, you cannot get data extension fields through these two methods.

 

[Gohulan]

I have created a new data extension through EMC at the Employee level, and it has added as a new column in Employee
With the name of the data extension.

I want to get the newly added column data in the extensibility application. I tried by calling DataStore.ReadEmployeeByID
But the new column property is not coming. How can i access the new column value of the employee?
Any help is greatly appreciated.

Hey Mi,

Try this it should work,


var employeeCustomColumn = this.DataStore.ReadExtensionDataValue("Employee", "Department", this.OpsContext.TransEmployeeID);
OpsContext.ShowMessage("Custom Employee Column Value for Current Employee is " + employeeCustomColumn);

 

[Mi!]

Hey Mi,

Try this it should work,


var employeeCustomColumn = this.DataStore.ReadExtensionDataValue("Employee", "Department", this.OpsContext.TransEmployeeID);
OpsContext.ShowMessage("Custom Employee Column Value for Current Employee is " + employeeCustomColumn);

Hey Mi,

Try this it should work,


var employeeCustomColumn = this.DataStore.ReadExtensionDataValue("Employee", "Department", this.OpsContext.TransEmployeeID);
OpsContext.ShowMessage("Custom Employee Column Value for Current Employee is " + employeeCustomColumn);

I got the extension value by using DataStore.ReadExtensionDataValue, here i am getting the extension field value. But I was looking for a way to get the newly added column value in Employee object. I tried ReadEmployeeByNum and ReadEmployeeByID , unfortunately new column is not coming.

 

[Gohulan]

So, just to clarify—are you trying to retrieve the column name from the extended data rather than the actual value?


In your scenario, it should be EmpPfNumber, meaning the output you're expecting from the extension application is the field name (EmpPfNumber), not the employee's entered value, correct?

 

[Gohulan]

I got the extension value by using DataStore.ReadExtensionDataValue, here i am getting the extension field value. But I was looking for a way to get the newly added column value in Employee object. I tried ReadEmployeeByNum and ReadEmployeeByID , unfortunately new column is not coming.

Try this

// Convert the integer tableID to the required DbKey.DbTableID type
DbKey.DbTableID tableID = new DbKey.DbTableID(106); // Assuming 106 is the integer value
var employeeCustomColumn = this.DataStore.ReadExtensionDataPropertiesByTableID(tableID);

// To display or process the properties
foreach (var property in employeeCustomColumn)
{
OpsContext.ShowMessage($"ID: {property.ObjectNumber}, Name: {property.Name}, Value: {property.APPLICATIONTYPE}");
}