Finance | Project Operations, Human Resources, ...

Update PositionWorkerAssignments Entity via. OData Not Working

(0) Share

Report

Posted on by AnishKM

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);

}

All responses (3)

Answers (0)

Parag Chapre 12,248 Most Valuable Professional on at

Like (0)

Report

RE: Update PositionWorkerAssignments Entity via. OData Not Working

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.
AnishKM on at

Like (0)

Report

RE: Update PositionWorkerAssignments Entity via. OData Not Working

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

Parag Chapre 12,248 Most Valuable Professional on at

Like (0)

Report

RE: Update PositionWorkerAssignments Entity via. OData Not Working

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.