Display only those Document who's status is pending

Hi Guys, I'm trying to display data from MongoDB on the admin panel, but my condition is. I only want to show those data whose status is under review and ignore all other documents.

I'm trying many things, like using a MongoDB $match Operator or using a simple filter function on js

{{{ formatDataAsArray(GetAllHappenings.data).filter(item => item.status == "underReview") }}}

this returns me all the data in happening collection

let me know how should I do it in retool query .

These all work for me:

Aggregate action.

Transformer on a "find" action.

Filter on the input to the table for a "find" action that returns everything.

1 Like

thanks works!!!