Hi All, Below is documents where we have display field as array where sometimes it has single value and sometime multivalue field . We want to sort on display but getting error "can not sort on multivalued field" . Thought of creating a copy field as string but this will cause issue when multivalue fields comes.
{
"id":"1"
"display":["2021-04-19T09:30:00 (IST)"]
},
{
"id":"2",
"display":["2021-04-19T09:00:00 (IST)"]
}
{
"id":"3",
"display":["issue1"]
}
Any suggestions?
Thanks
sam
