Make child object fields search in a table

  • 1
  • Idea
  • Updated 3 years ago
  • Under Consideration
I know that you can add child objects and their fields to a table, but once you add these fields you cannot use the search feature to find records with child objects with a certain text.
Photo of Nate Gilbertson

Nate Gilbertson

  • 1,194 Points 1k badge 2x thumb

Posted 4 years ago

  • 1
Photo of Zach McElrath

Zach McElrath, Employee

  • 49,056 Points 20k badge 2x thumb
Nate, in what context are you using child object search? If there are few enough records that you can pull them all in to your Skuid page, then you might be able to use Client-side search , which supports search on Child Relationship fields. This only makes sense if you are able to pull in all relevant records into the table before hand, e.g. if you were on an Account detail page and had a Cases table, and wanted to search on Case Comments as well for any of those Cases, this would be okay because there's a limited number of Cases to retrieve, so you could remove the Limit clause on your Cases model, add a Child Relationship to the Cases model to retrieve Case Comments, and then turn on Client-side Search on your Cases table, then you could search on the Case fields as well as CaseComment child relationship fields.
Photo of Nate Gilbertson

Nate Gilbertson

  • 1,194 Points 1k badge 2x thumb
Thank you for the response! Is it possible to add a child field to the search field option in the table properties? This way I can search on this field on the table and not everything on the table?
Photo of Zach McElrath

Zach McElrath, Employee

  • 49,056 Points 20k badge 2x thumb
Unfortunately no, it currently is not possible to do this. We'll add this to our to-do list.
Photo of Chad

Chad

  • 210 Points 100 badge 2x thumb
Nate,

We were having this same issue. We were unable to search on related fields that were visible within the table.

As a work-around we created a template field for each of the related fields (account name in our instance) and then used the following template:
Allow HTML = TRUE

<A Href = "/{{{Account__c}}}"; Target = "_Blank"> {{Account.Name}} </A>