Answers.Body: <p>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.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-09-20T20:08:59.857Z
Answers.Text: Thx @petednz, this is exactly what I found in the meantime, and since the db update, problem solved :)
Answers.UserDisplayName: stackexchange user
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-09-19T22:06:20.183Z
Answers.LastActivityDate: 2022-09-19T22:06:20.183Z
Answers.UserDisplayName: petednz - fuzion
Body: <p>Is it possible to search contacts by custom fields with SearchKit ? I can't find a way to do it.</p>
  <p>I need to list contacts where</p>
  <pre><code>Contact Subtype = &quot;parent&quot; and &quot;has a relationship with a child&quot; =&gt; this is working
      OR
  Contact Subtype = &quot;parent&quot; and &quot;Custom field::School name=XXX&quot; =&gt; I can't find how to do this
  </code></pre>
  <p>(In the result table, I can successfully add the custom fields, but I can't use them in the query)</p>
  <p>Any thoughts ?</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-09-19T12:05:19.127Z
Comments.Text: Certainly doable using the 'Where' function I would have thought, is the school name field set to be searchable in the settings?
Comments.UserDisplayName: RebeccaTregenna
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-09-19T13:20:36.897Z
Comments.Text: 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
Comments.UserDisplayName: stackexchange user
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-09-19T14:16:21.577Z
Comments.Text: 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.
Comments.UserDisplayName: RebeccaTregenna
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-09-19T14:33:51.720Z
Comments.Text: 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 :)
Comments.UserDisplayName: stackexchange user
Tags: <searchkit>
Title: Search by custom field with searchkit
ThreadText: # Search by custom field with searchkit
  
  (Asked by: username_0 on 2022-09-19)
  
  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 ?
  
  **Tags:** searchkit
  
  > **Comments:**
  > **username_1**: Certainly doable using the 'Where' function I would have thought, is the school name field set to be searchable in the settings?  
  > **username_0**: 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  
  > **username_1**: 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.  
  > **username_0**: 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 :)  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2022-09-19. Score: 1 | Accepted answer
  
  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.
  
  > **Comments:**
  > **username_0**: Thx @petednz, this is exactly what I found in the meantime, and since the db update, problem solved :)  
  
  ---
  
  