0

I have 2 membership custom fields that are set as searchable. One field is integer the other is alphanumeric. Neither field appears in the Quicksearch options in Search Preferences. The custom fields appear as column options in the membership reports but they are not available as sort options. Is there anything else I need to configure to make them available for search or sortable in reports?

I have tested with a Contact custom field and this works as expected.

Thanks for any help

Improve this question
4
  • What type of data is in these fields? Is it plain text, a boolean value, a date etc.?
    – joxley
    Commented Jan 8, 2020 at 10:54
  • I have updated the question .. one field is integer and the other is alphanumeric.
    – Crofter
    Commented Jan 9, 2020 at 12:00
  • What version of civicrm are your using? Are you able to duplicate this behaviour on dmaster? dmaster.demo.civicrm.org (If not then it's either a bug that's been fixed in a more recent version of civicrm, or a problem specific to your install)
    – Luke Stewart
    Commented Jan 12, 2020 at 0:47
  • I am using 5.21.0. I have tried on the dmaster demo server and get the same results. It seems that a membership custom field does not work the same way as a contact custom field as a contact custom field will appear in the Quicksearch list and is sortable. Is this by design or because of the way the data is stored in the tables?
    – Crofter
    Commented Jan 12, 2020 at 14:07

1 Answer 1

Reset to default
1

The quicksearch function is for searching contacts, and therefore doesn't call to any of the other components of Civi for data fields.

As per Civi's Docs, if you're looking for data regarding a specific component (i.e Memberships), each component has it's own search function. In Find Memberships, this should also show your custom fields to allow you to search from.

Improve this answer
2
  • Thank you for the reply. The membership number in the custom field is our primary key to our members so not being able to use it in the Quicksearch is a pain. My other requirement was to use it as a sortable field in reports but that doesn't seem possible either. What I have decided to do is add a contact custom field and write a civirules action which will keep this custom field in step with the membership custom field.
    – Crofter
    Commented Jan 17, 2020 at 9:40
  • dear @Crofter how did you get CiviRules to write a field from membership entity to contact entity? What action is used to solve this problem?
    – wintermoor
    Commented Jun 12, 2022 at 14:23

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.