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.
Just to add to Stefan, if you are on a cloud environment or in any other way you could upgrade to versione 22.3, that would be directly possible docs.appian.com/.../Appian_Release_Notes.html
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.
Hi Gabriele,
That's only possible when we have to filter it on a specific condition. Also we need to code to create filters separately and then to Query on the records data on the click of search button.
I want to utilize the feature of records where we can directly call the record on the UI along with its Out of box functionality like filter, savings filter and export to excel hence looking for an option if we can create a user filter on the Request record which can link to the Comment table.
Were you able to find any solution for your problem? I have the similar issue posted here