Parse-server: Order by nested objects

[codebreach]

I am skipping on the issue template because this is not a bug.

I have an object with a Pointer to User (named creator). I want to be able to order by the full_name field on User

Currently, if I do order('creator.full_name') i get the following error:

{"code":105,"error":"creator.full_name is not a valid order key"}

Would it be possible to implement this in parse-server? Would a PR be accepted for the same?

[mtrezza]

+1 for this, I cannot count the times I stumbled upon this caveat.

It would be very helpful if the dot notation on a subquery could be used to filter / order the superquery. Just by counting the number of references to this limitation when doing a Google search I am sure that this is a much desired feature.

[JHHMobile]

Any updates for this?

[iwantooxxoox]

Looking for the feature too

[natanrolnik]

PRs are welcome @iwantooxxoox @JHHMobile @mtrezza @codebreach

[rooswelt]

Any workaround on this?

[iwantooxxoox]

@rooswelt
My workaround is to add a middleware before ParseServer middleware, override res.send to get response body and do any kind of sorting that you want there.

example:

app.use(YOUR_ENDPOINT, (req, res, next) => {
  res.sendResponse = res.send;
  res.send = (body) => {
    const bodyObj = JSON.parse(body);
    bodyObj.results.sort((a, b) => a.links[cnty].order - b.links[cnty].order);
    return res.sendResponse(JSON.stringify(bodyObj));
  };
  next();
});
app.use(MOUNT_PATH, parseServer);

[rooswelt]

@iwantooxxoox
Thanks but that approach force me to load the entire collection then sort...unfortunately that's not an option for me 'cause I've thousands of entities to load...

[stale[bot]]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.