We have the following collections
a master collection
a catalog - fth-bangalore-offline
3 availability collections -availability_warehouse_1,availability_warehouse_357,availability_warehouse_1181
To determine the availability of a product, we need to join these collections using entity_id and sort them based on the is_available field. A product is considered available if is_available is true in any of the three availability collections.
Here is_available key is a merged attribute, and we need to sort on a merged attribute. Does typesense allow this? This merged field sort is not working with following query.
Please explain how we can sort this is_available field