Count For Products Approved From Products Submitted

[i.naseem.in24]

Hey BCommunity

Can anyone help me to rectify the following.

1 Products are submitted and I have a count for them
2. Products needs approving and have a database field under Products > Product_Approved = YES / NO

How can i get it to do a count from the following seeing as YES / No is not directly a number, Can anyone help where I am going wrong?

[andrewgassen]

I would typically do something like…“Do a Search for Products” where User = Parent Group’s User and Product_Approved = Yes. Then, after the “Do a Search for Products” in the expression composer, click the “More” button and select “Count”

[i.naseem.in24]

Thanks @andrewgassen ill give that a whirl

[i.naseem.in24]

Hey @andrewgassen

Tried this, but getting the response back as yes/no

In My Database Product has a field Product Approved Yes No

For Products Submitted it works it seems

For Products Approved I tried

what do you think mate