Home computer programming, dynamics ax, others why I cannot view the record from x++ (but the record is exists on table), LogisticsPostalAddress
computer programmingdynamics axothers

why I cannot view the record from x++ (but the record is exists on table), LogisticsPostalAddress

this is what I’ve found while playing LogisticsPostalAddress X++ query

this is the first part of logisticspostaladdress,

see the part 2 here


I created a X++ query like this source below

select LogisticsPostalAddress where LogisticsPostalAddress.RecId=5637155184

the result was 0

the problem is, the record was exists on the table, but why it is hidden on the x++ query

this was cause the validTimeState that only the record on the validstate can view,

the solution is, we change the query to:

select validTimeState(fromDateTime,toDateTime)  LogisticsPostalAddress where LogisticsPostalAddress.RecId==5637155184;

we use validTimeState that has a wider range date value

remember to defined this object from the beginning

utcdatetime fromDateTime=dateTimeUtil::MinValue(), toDateTime=dateTimeUtil::MaxValue();

thanks to samuel liang to provide this information here

 

Author

Ronny

Leave a Reply