Share
Report
240I am trying to create the following functionality:
When a purchase line is inserted, we want to copy the user in the createdBy field of the salesline to the requester field of the purchline.
For this I checked the table relations and created the following code:
select firstonly * from salesLine
where this.InventRefTransId == salesLine.InventTransId;
if(salesLine.RecId)
{
select firstonly Id from UserInfo where salesLine.createdBy == UserInfo.Id;
if(UserInfo.Id)
{
PartyIProvider partyProvider = PartyProviderFactory::getPartyProvider();
if (partyProvider)
{
str fullName = partyProvider.dirPersonUserId2Name(UserInfo.id);
select * from dirPartyNameView where Name == fullName
join RecId from hcmWorker where HcmWorker.Person == dirPartyNameView.RecId;
}
this.Requester = hcmWorker.RecId;
this.update();
}
}The problem is that the dirPartyNameView does not return any data, despite the data existing.
(in SQL the query does work).
I also tried the following queries: (since i thought the problem could be caused by the instanceRelationsType column, as I am looking for a dirPerson and not a dirParty)
select * from dirPartyNameView where Name == fullName;
select * from dirPersonEntity where Name == fullName;
select * from dirPartyTable where Name == fullName;
Both of these queries give me the correct data in SQL Server when I enter the fullname field with the value that is used in D365, but I keep getting no data in D365.
These views also contain no dataareaId which could influence whether data is returned.
How is it possible that I can not find the correct records via the application?
Categories:
All responses (
Answers (
