Configuring custom selector to use a custom field value

Hi ​@u662 , Hope, this link helps you to load data in one selector from another selector selected value.

Hi ​@u662 

Please try changing your siteID to siteCD, these are two different values, ID is the unique key which is usually an integer, and the CD is the masked, more user friendly value, usually what you see on the screen.

Aleks

​@aiwan SiteCD is not a field within INLocation

[PXSelector(typeof(CalibrationHeader.docID),
    typeof(CalibrationHeader.docNbr),
    typeof(CalibrationHeader.date),
    typeof(CalibrationHeader.siteID), SubstituteKey = typeof(CalibrationHeader.docNbr), ValidateValue = false)]

This answer from ​@aiwan is ultimately correct. I had to unpublish and then republish to get the changes to work for some reason.

Here’s my final code:

Warehouse (AMToolMstExt.usrToolWarehouse)

using PX.Objects.IN;

[PXDBString(30)]
[PXUIField(DisplayName="Warehouse")]
[PXSelector(typeof(Search<INSite.siteID>), typeof(INSite.siteCD), typeof(INSite.descr), SubstituteKey = typeof(INSite.siteCD))]

Location (AMToolMstExt.usrToolLocation)

using PX.Objects.IN;
using PX.Objects.AM;

[PXDBString(30)]
[PXUIField(DisplayName="Location")]
[PXSelector(typeof(Search<INLocation.locationCD, Where<INLocation.siteID, Equal<Current<AMToolMstExt.usrToolWarehouse>>>>), typeof(INLocation.locationCD), typeof(INLocation.siteID), SubstituteKey = typeof(INLocation.locationCD), DescriptionField = typeof(INLocation.descr))]