Hi, I’m trying to build a simple accounting app with remotestorage.
I have some customers stored under /customers/ and some bills stored under /bills/.
Each customer and each bill is stored as a JSON object. For each bill, the customer_id is stored.
Now I want to provide an overview of all bills including the names of the customers. These names are not stored in the bill objects, but in the customer objects.
Is there a way to perform a JOIN operation on the server side using remotestorage, that would return the bills with their customer names in them (something like SELECT * FROM bills, customers WHERE bill.customer_id = customer.id)? Or is there a different way you could tackle this problem when using remotestorage?