How do I define filter for 'Contact' field in my form?

I have a custom CRUD that is related with Contact. Because of that, I have a ‘Contact’ form field on my form. But, It appears all Contacts without any filtering. How do I define a filter to only show Contacts that match with my filter? Ex: Contact there is a field called ‘first_name’, and I want to show in this field only Contacts that first name starts with ‘A’ or something like this.

Topic

[Yurii MuratovParticipant]

Hello, @spyout98.

I think, the oro_contact_select form type (https://github.com/oroinc/crm/blob/master/src/Oro/Bundle/ContactBundle/Form/Type/ContactSelectType.php) may help you. Please try to change the form type to oro_contact_select for your relation.

Could you please tell me how did you create your entity with relation to contact entity – do you create entity class and migrations, or did you create custom entity only with migration, or did you create your entity in UI? After that, i will be able to explain how to change tis form type.

[spyout98Participant]

A typical inserting of Contact form field in my “FormType” is something like that:

# my/path/to/Form/Type/FormType.php
(…)
$builder->add(
‘contact’,
‘oro_contact_select’,
[
‘required’ => false,
‘label’ => ‘oro.sales.opportunity.contact.label’
]
)

(…)

How do I pass a parameter that make a filter (like ‘firstName = “John”‘) or defines that datagrid ‘XYZ’ that will be showed when user clicks in hamburger icon on right side of field?

[Yurii MuratovParticipant]

@spyout98, if you just want to limit the list of contacts at the choises list, in this case the easest way will be to use common symfony’s entity form type https://symfony.com/doc/current/reference/forms/types/entity.html#using-a-custom-query-for-the-entities and declare custom query to limit the list of contacts

[Author]

Replies