Leppalúði
05/31/2024, 8:22 AM{"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.