featured planter order

[sebastiangaertner]

{"planters":[8870,5182,8380,4726,7260,6141,4755,7582,5896,4904,5896,8002,7704,3937,3952,7894,3953,3985,4031,4043,4787,5881,5925,6945,7181,7186,7188,7273,7276]}

when the above is displayed on the webmap it is not reading the json content in that specific order. It orders by uuid.

[sebastiangaertner]

Could this work???

......

json_array_elements_text(data -> 'planters') AS planter_id,
   row_number() OVER () AS rn
 FROM 
   webmap.config 
 WHERE 
   name = 'featured-planter'
) AS t ON t.planter_id::text::integer = planter.id
ORDER BY t.rn;

[dadiorchen]

The problematic code should be here:

treetracker-query-api/server/infra/database/PlanterRepository.ts

Line 167 in d1e064c

async getFeaturedPlanters(options: FilterOptions) {