Need to add Contact selector field in the stock Items screen that should display the values for ContactID

hi @Harshita,

Can you try with this.

        [PXDBInt()]      
        [PXSelector(typeof(Search<Contact.contactID>), SubstituteKey = typeof(Contact.displayName))].

Please Use PXSelector in the aspx.

Hello @praveenpo ,
thank you for your prompt response. I now tried with your lines of code and it has been added successfully, but the field isn’t allowing me to select any line, its like whenever I select any line in the dialog box it doesn’t get displayed on the selector field.

[PXDBInt]
[PXUIField(DisplayName="Contact2", Visibility = PXUIVisibility.SelectorVisible)]     
        [PXSelector(typeof(Search<Contact.contactID>), SubstituteKey = typeof(Contact.displayName), DescriptionField = typeof(Contact.displayName), CacheGlobal = true)]
 

This should do it

[PXDBInt]
[PXSelector(typeof(Contact.contactID), DescriptionField = typeof(Contact.displayName), CacheGlobal = true, Filterable = true)]
[PXUIField(DisplayName="Contact2")]

This should do it

[PXDBInt]
[PXSelector(typeof(Contact.contactID), DescriptionField = typeof(Contact.displayName), CacheGlobal = true, Filterable = true)]
[PXUIField(DisplayName="Contact2")]

Hello @dcomerford ,
Now it worked, But it doesn’t display all the records that have been created under Contacts (CR302000)
 

Hello @dcomerford & @praveenpo , How can i put a filter in this to not display the contacts of the Employee type? using project Editor
So its like I would only like to display the records of the type Contact, Sales Person, Business Account & Lead in this selector - Contact field.

 

Hi @Harshita ,

Could you please try below code snippet?

[PXDBInt]
[PXSelector(
    typeof(Search<Contact.contactID, Where<Contact.contactType, NotEqual<ContactTypesAttribute.employee>>>),
    DescriptionField = typeof(Contact.displayName),
    CacheGlobal = true,
    Filterable = true)]
[PXUIField(DisplayName = "Contact2")]

Hope, it helps!

Regards,

Sweta

@Harshita Was just going to add the very same Search condition by @sweta68 beat me to it

[PXDBInt]
[PXSelector(
    typeof(Search<Contact.contactID, Where<Contact.contactType, NotEqual<ContactTypesAttribute.employee>>>),
    DescriptionField = typeof(Contact.displayName),
    CacheGlobal = true,
    Filterable = true)]
[PXUIField(DisplayName = "Contact2")]

Thanks a lot @sweta68 for your prompt response. Its now working as expected.

[PXDBInt]
[PXSelector(
    typeof(Search<Contact.contactID, Where<Contact.contactType, NotEqual<ContactTypesAttribute.employee>>>),
    DescriptionField = typeof(Contact.displayName),
    CacheGlobal = true,
    Filterable = true)]
[PXUIField(DisplayName = "Contact2")]

Hello @sweta68 , how about if I just wanted to display the contact type = Contact?