How to return only the keys of entries with a true value in addon?

I have a table for my members called 'nodes'. It has an addon of 'skills'. The skills table is full of skills that are all bools. The two tables are linked by a shared id.

On my frontend I want to filter by a skill. So if I pick 'Animation' from my UI filter select, it should search Xano and return the users who have ticked true to 'Animation'.

I've been doing the filtering on the frontend which I want to change.
Below is how I am doing it on the front end. ChatGPT may have helped with the JS ;)
Having a hard time trying to work this out in my function stack.

'for (let i = 0; i < artists.length; i++) {
let trueSkills = Object.keys(artists[i].skills).filter(skill => artists[i].skills[skill] === true);
artists[i].skills = trueSkills;
}'

TIA

Other
6 replies