Finance | Project Operations, Human Resources, ...

Update PositionWorkerAssignments Entity via. OData Not Working

(0) Share

Report

Posted on by AnishKM Microsoft Employee

Below code is written for updating "validTo" field for PositionWorkerAssignments entity in D365.

However no error is thrown, but data is not updated in the table/entity.

var query = Context.PositionWorkerAssignments.Where(s => s.PersonnelNumber == associate.PersonNumber) as DataServiceQuery<PositionWorkerAssignment>;
var response = await query.ExecuteAsync().ConfigureAwait(false);
var workerAssignment = response.FirstOrDefault();

if (workerAssignment != null)
{
var workerAssignmentCollection = new DataServiceCollection<PositionWorkerAssignment>(Context);
workerAssignmentCollection.Add(workerAssignment);

workerAssignment.ValidTo = DateTime.UtcNow.Date; //ending assignment

Context.UpdateObject(workerAssignment);
var saveResponse = await Context.SaveChangesAsync(SaveChangesOptions.PostOnlySetProperties).ConfigureAwait(false);

}

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

Parag Chapre 12,254 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi Anish,

I am not sure how this handles in Odata but when updating Valid To value you need to consider whether you want to create a new record, correction. This table is Date effective.

Was this reply helpful? Yes No
AnishKM Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

But even if we need to add a new record? should we end(update) the initial assignment?

Was this reply helpful? Yes No
Parag Chapre 12,254 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

As per my information, When you create a new record then it adjusts the previous record and creates a new record.

When you edit the record then it just adjusts the current record.

Please check the data entity methods and try to debug the code.

Was this reply helpful? Yes No