Dear Experts,
I have a requirement where I have to Search the Request where certain comments have been made.
There can be multiple comments for a Given request number hence I'm using two table "Request" and "Comments" with flat relation where comment table contains requestNumber field to create the relation between the two.
Is there any way possible that I can search in the "Request" record with the comments which have made under it.
Thanks,
Gaurav Singh
Discussion posts and replies are publicly visible
The most simple approach would be to first search in the comments table, fetch the distinct request ids, and then show all requests for these ids.
Hi Stefan,
I want this on the Record Page
This has to be in way like we have Search filters in Record, So when I type the sentence it searches for the specific request where that comment is made.
You can just add the related record field containing your comment to the grid. Then search should automatically include that.