30Hello,
This is my specific requirements
The entity should not be able to return more rows than there are locations in the specific parameter table (JDBBaydoorLocationPowerApp).
It is possible for multiple /LoadID/ to be assigned to the same /WMSLocationID/. In this case, it is necessary to identify the /LoadID/that is the first to arrive chronologically. To do this, i shouls to take the first /LoadID/ of the day whose status is different from /shipped/ (based on the /Scheduled Shipping Date and Time/ field).
I created a custom entity and this is its datasource
and i add two virtuel fileds to this entity ( LoadedPalletNumber, TotalPalletNumber)
LoadedPalletNumber= The number of workID related to the loadID whose container number is not empty and whose work status is closed
TotalPalletNumber=The number of WorkID related to the LoadID whose container number is not empty and whose Work status is not canceled.
so i use the method postload
But When exporting the data from my entity, I receive a list of /loadIds/ that share the same /WmsLocationID/. However, I aim to obtain only the /loadId/ that happens to be the first to arrive for each distinct /WmsLocationID/.
I wish to know where exactly the problem lies in my reasoning and my code. Please help me find the solution
Categories:
