1

Is it possible to search contacts by custom fields with SearchKit ? I can't find a way to do it.

I need to list contacts where

Contact Subtype = "parent" and "has a relationship with a child" => this is working
    OR
Contact Subtype = "parent" and "Custom field::School name=XXX" => I can't find how to do this

(In the result table, I can successfully add the custom fields, but I can't use them in the query)

Any thoughts ?

4
  • Certainly doable using the 'Where' function I would have thought, is the school name field set to be searchable in the settings? Sep 19, 2022 at 12:05
  • Using "where" is what I had in mind, but no custom field appears anywhere (or well hidden in submenus and didn't find them) Yes the field is searchable, I use it successfully in the "traditionnal" search methods in Civi Sep 19, 2022 at 13:20
  • The menus can take getting used to. It's still hard to pinpoint as there's a number of combinations as to why it may not be there (i.e. the entity the custom field is related to) etc. If you replicate your field settings on dmaster or provide some more detail here, I'm sure one of use in the community can help. Sep 19, 2022 at 14:16
  • 1
    I've just seen a system alert saying I had to update the database structure because of a new extension. Probably after Search kit installation. After doing so, I can now see the custom fields. Not 100% sure this was the root cause, but it seems so :) Sep 19, 2022 at 14:33

1 Answer 1

1

Worth checking to see if your db might need an update running as some extension or core upgrade can require the db to have the upgrade run also.

1
  • Thx @petednz, this is exactly what I found in the meantime, and since the db update, problem solved :) Sep 20, 2022 at 20:08

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.