Give a fixed order for this API

[dadiorchen]

The bug is: if request this https://prod-k8s.treetracker.org/query/trees?organization_id=193&limit=1000 we got a random list every time, you can request it multiple times, and the return list differs.

Is this because the order is random? If this is the case, please give a default order for the list, for example, order by created time.

---

Some hints:

• Please read our readme for more information/guide/tutorial.
• Here is an engineering book in Greenstand.
• To know more about our organization, visit our website.
• If you want to join the slack community (some resources need the community member's permission), please leave your email address.

[kunalznk]

hello can u assign it to me

[jeremydthomas]

of course

[github-actions]

🎉 This issue has been resolved in version 1.62.3 🎉

The release is available on GitHub release

Your semantic-release bot 📦🚀

[dadiorchen]

@kunalznk can you check the url, I found the problem is still there:

This is the SQL on the log:

{
7117   method: 'raw',
7118   sql: '\n' +
7119     '      SELECT\n' +
7120     '      trees.*,\n' +
7121     '      tree_species.id as species_id,\n' +
7122     '      tree_species.name as species_name,\n' +
7123     '      region.id as country_id,\n' +
7124     '      region.name as country_name,\n' +
7125     '      entity.id as organization_id,\n' +
7126     '      entity.name as organization_name\n' +
7127     '      FROM trees\n' +
7128     '      LEFT JOIN planter ON trees.planter_id = planter.id\n' +
7129     '      LEFT JOIN entity ON entity.id = planter.organization_id\n' +
7130     '      LEFT JOIN tree_species \n' +
7131     '        on trees.species_id = tree_species.id \n' +
7132     '      LEFT JOIN region\n' +
7133     '        on ST_WITHIN(trees.estimated_geometric_location, region.geom)\n' +
7134     "        and region.type_id in (select id from region_type where type = 'country')\n" +
7135     '      WHERE\n' +
7136     '        (\n' +
7137     '          planter.organization_id in ( SELECT entity_id from getEntityRelationshipChildren(193))\n' +
7138     '        OR\n' +
7139     '          trees.planting_organization_id = 193\n' +
7140     '        )\n' +
7141     '      LIMIT 100\n' +
7142     '      OFFSET 0\n' +
7143     '    ',
7144   bindings: [],
7145

We are missing the orderBy, do you know how to open the SQL log locally? You can check the SQL created on your side, so you can tell what's happening.

[kunalznk]

Okay I'll check it

[dadiorchen]

Let me know if you need help