Hi there - we are building a collection that store...
# community-helps
Sachin Singh
01/28/2022, 5:50 AMHi there - we are building a collection that stores info on "projects" and projects can have multiple members{ID, Username, Role}. Since currently nested fields are not indexed we are a little stuck on what the flattened structure would look like? @Jason Bosco
j
Jason Bosco
01/28/2022, 5:58 AM@Sachin Singh Could you share what your current nested structure looks like in JSON? I can then suggest a flattened structure
s
Sachin Singh
01/28/2022, 11:07 AMExample of json:
{
id:"8d6250fd-cac3-47dc-b084-210dd67b4698",
workspaceId:"8d6250fd-cac3-47dc-b084-210fdd9b4698",
workspaceName:"workspaceName",
description:"description",
status:"ACTIVE",
projectMembers:[
{
userId:"8d6250fd-cac3-47dc-b084-210fdd9b4698",
userName:"testusername",
image:"image.png"
},
{
userId:"8d6250fd-cac3-47dc-b084-210fdd9b4698",
userName:"testusername",
image:"image.png"
},
{
userId:"8d6250fd-cac3-47dc-b084-210fdd9b4698",
userName:"testusername",
image:"image.png"
},
],
brandName:"brandName",
brandDescription:"brandDescription",
brandUrl:"Https://google.com",
brandIndustryName:"brandIndustryName",
}
Sachin Singh
01/28/2022, 11:08 AM@Jason Bosco
c
CaptainCodeman
01/28/2022, 3:20 PMI would convert that into a collection of arrays, e.g.
member.userID: string[]member.userName: string[]🙌 1
CaptainCodeman
01/28/2022, 3:21 PMalthough you may only need userID to be searchable, and included in the schema (i.e. you get name + image back in results, but don't need them to be indexed)
j
Jason Bosco
01/28/2022, 4:20 PM@Sachin Singh ^ exactly what @CaptainCodeman said
Jason Bosco
01/28/2022, 4:20 PMYou only need to flatten the items that you want to search / filter / facet by and add them to the schema. You can still send nested fields in the document and use that for rendering for eg, image
🙌 1