Search using fields other than Name and external Id | Community
Skip to main content

Search using fields other than Name and external Id

  • April 14, 2023
  • 7 replies
  • 0 views

It appears that the ability to search for records is limited to only 2 fields(name, external id).

Will search be available in the future with the ability to leverage any field in the Custom Object record?

 

7 replies

  • April 17, 2023

It be great if the new custom objects have a search capability as the legacy ones so we can create complex searches, specially using the API. Like: Get all books with author ABC that contains XYZ in the tittle; or get all books associated/linked to a particular user.


Ashwin11
  • April 17, 2023

Hi @matthew43 , @lydia13 - We are already in the works for the new custom objects search experience which is expected to search across all text type fields (Text/Text Area/Regex) and share the results in order of relevance. CCing @preethi12 from the Search team in case there are more detailed questions around the search experience.


  • April 18, 2023

Those are great news 😀


  • September 8, 2023

Are there plans to implement more complex searches? With the previous version we could use searches like:

{
"query": {
"$and": [
{"author": {"$eq": "Sidney Sheldon"}},
{"publisher": {"$contains": "Bloomsbury"}}
]
}
}

Also be able to search by relationship as before. So, for example, I can get all the assets that the user/owner XYZ has looking at asset:owner = XYZ (where owner is a lookup field to user defined in asset custom object)


Ashwin11
  • September 8, 2023

hi @lydia13 - Our team are working towards this.. This might be something that we fix right after we make this feature available for all eligible customers


Ashwin11
  • September 8, 2023

We are also working on Dynamic filter capabilities on Lookup fields- 
For eg: Show me all the Assets where Owner = Requester


  • September 11, 2023

That's fantastic. Do you have an estimate for the release of those features?