How to limit the data source of a selector?

Question

Hello,

With other’s help, I was able to add a selector of employees on shipment screen.
I’ve created an employeeclass (Which is referred to VendorClassID in DAC) named “PICKER”,

I’d like to limit the selector only shows the employees from “PICKER”,

I write the below code, but it gives out errors:

[PXSelector(typeof(Search<EPEmployee.bAccountID,
Where<EPEmployee.vendorClassID,Equal<"PICKER">>>),
typeof(EPEmployee.acctCD),
typeof(EPEmployee.acctName),
typeof(EPEmployee.vendorClassID),
SubstituteKey = typeof(EPEmployee.acctCD))]

What is the right way to write the codes. Please advise. Thank you.

icon

Best answer by Naveen Boga 10 May 2021, 16:30

View original

Naveen Boga · Accepted Answer

Hi@ray20We can not pass directly that value, and for this, we need to use SQL constants.Please use the below code and check….public class SQLConstants{public class PICKER : PX.Data.BQL.BqlString.Constant { public PICKER() : base("PICKER") { } }}[PXSelector(typeof(Search>>),typeof(EPEmployee.acctCD),typeof(EPEmployee.acctName),typeof(EPEmployee.vendorClassID),SubstituteKey = typeof(EPEmployee.acctCD))]

Django · Answer

The code that you’re looking for is something like this:

#region HelperClasses

private class string_PICKER: Constant<string>

{

public string_PICKER():base("PICKER"){}

}

#endregion

Then, in your field code you’ll reference that custom class:

Where<EPEmployee.vendorClassID,Equal<class_PICKER>>>),

Now, I typically use the “Convert To Extension” button under the Data Access group to turn the automatically generated code to files under the Code group and that’s where I’d place the code that I wrote above. But I’m not sure where you’d place that code while keeping your code organized in the way that your project currently shows. Other people might be able to help there.

Edit: Naveen has shown you the same thing but done a litte more correctly. :)

How to limit the data source of a selector?

4 replies

Reply

Reply

Sign up

Social Login

Login to the community

Social Login

Scanning file for viruses.

This file cannot be downloaded