Andrew Russo
05/01/2024, 5:23 PM"filter_by": "((($meetingShares(userId:=mhvRsyKrPb5qEoPn6KB3) || $meetingShares(groupId:=[1, 2, 3])) || folderId:= [1,2,3]) && tenantId:= xUbTDW0Ujk1OK9jpn2BO) && accountId:=bankPiUzRjCGAknd1Ktq",
What id like to do is filter based on a field like accountName, the meeting has a reference to the folders collection which has a string field on a folder called accountName.
"filter_by": "((($meetingShares(userId:=mhvRsyKrPb5qEoPn6KB3) || $meetingShares(groupId:=[1, 2, 3])) || folderId.accountName:= [1,2,3]) && tenantId:= xUbTDW0Ujk1OK9jpn2BO) && accountId:=bankPiUzRjCGAknd1Ktq",
This is the config of the folderId field on the meetings collection:
{
"facet": false,
"index": true,
"infix": false,
"locale": "",
"name": "folderId",
"optional": true,
"reference": "folders.id",
"sort": false,
"stem": false,
"type": "string"
}
This is the config of the accountName field on the folders collection
{
"facet": false,
"index": true,
"infix": false,
"locale": "",
"name": "accountName",
"optional": false,
"sort": false,
"stem": false,
"type": "string"
}
Harpreet Sangar
05/01/2024, 7:04 PMfolders
collection?Andrew Russo
05/01/2024, 7:04 PMAndrew Russo
05/01/2024, 7:04 PMHarpreet Sangar
05/01/2024, 7:07 PMmeetings
references meetingShares
?Harpreet Sangar
05/01/2024, 7:10 PMaccountName
field?Andrew Russo
05/01/2024, 7:10 PMHarpreet Sangar
05/01/2024, 7:11 PM$folders(accountName: foo)
should work.Harpreet Sangar
05/01/2024, 7:13 PM$meetingShares(userId:=mhvRsyKrPb5qEoPn6KB3 || groupId:=[1, 2, 3])
Harpreet Sangar
05/01/2024, 7:17 PMAndrew Russo
05/01/2024, 8:13 PM"filter_by": "color:=blue && folderId.status:=active",
Harpreet Sangar
05/02/2024, 5:27 AMcollection: meetings
q: *
filter_by: $folders(status: active) && color: blue
Andrew Russo
05/02/2024, 10:54 AMHarpreet Sangar
05/02/2024, 10:56 AMmeetings
will be enough to join in this case.Andrew Russo
05/02/2024, 11:08 AMAndrew Russo
05/02/2024, 4:46 PMHarpreet Sangar
05/03/2024, 4:03 AMAndrew Russo
05/03/2024, 10:33 AMHarpreet Sangar
05/03/2024, 1:47 PMAndrew Russo
05/03/2024, 1:54 PMHarpreet Sangar
05/03/2024, 1:56 PMAndrew Russo
05/03/2024, 1:57 PMHarpreet Sangar
05/03/2024, 2:06 PM