Hey, I have a collection named tokens, the collect...
# community-help
l
Hey, I have a collection named tokens, the collection has a nested []object "balances"
{"index": true, "facet": false, "optional": true, "name": "balances.address", "type": "string[]"},
{"index": false, "facet": false, "optional": true, "name": "balances.balance", "type": "string[]"},
{"index": false, "facet": false, "optional": true, "name": "balances.last_received", "type": "int64[]"},
I'm able to get all balances for an address by using
q: '*',
query_by: '_id',
`filter_by:
balances.address:=${address}
,`
offset: offset,
limit: limit,
I need to sort the results by
balances.last_received
for this address, I found an issue on Github that suggests using a field named
balance_sort_.*
but I have at least 1.2M unique addresses, typesense wasn't really a fan of making a schema with 1.2M fields. I considered using JOINs, but I'm using collection aliases and my sync was causing reference not found errors. I'd like to use them as a last resort.