Forum | Appery.io

Mapping a database collection to a list, I have a boolean field called "isActive" and I'd like to only display items in the list that are set to "isActive:true"

I'm assuming I do this in my mapping from the $ to the listitem. How's it written where I only return true items?

codereturn isActive(true);/code

Hi Tommy -

Show us example of your DB structure.

I'm sure I just add it to the Edit JS button where the $ is associated with the listitems... Just don't know the small bit of code: return isActive = true;

Maybe a "where isActive=true"

What service your are calling?
Expression will look like this for testing service tab:
pre
where={"isActive": {"$exists":true}}
/pre

I don't know, I just want to bring over the items that are marked "true" so basically list all items that have the column "isActive" set as 'true' and not list the ones marked as 'false'...

That code above did not work but I may be putting it in the wrong spot ...

Hello! You don't need to add any JS mapping. You can just map from isActive field to listitem visible property.

That's awesome! Thanks! I couldn't wait to try it and it worked. So easy...