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

  • What type of data is in these fields? Is it plain text, a boolean value, a date etc.? – joxley Jan 8 at 10:54
  • I have updated the question .. one field is integer and the other is alphanumeric. – Crofter Jan 9 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 Jan 12 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 Jan 12 at 14:07
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|||||
  • 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 Jan 17 at 9:40

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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