This is my Users DB: [image] But when I do the count, it’s always 0. [image] [image] I don’t know what happens.

Thanks mike, I had to allow find this in searches box. [image]

Popping in here with a random tip since I noticed the topic title and learned this recently from one of our engineers - try to make a habit of using “:first item is empty” instead of “:count is 0.” If the condition were to fail, the first expression would only return the first item of the search be…

Obscure note on Sam’s input for other readers; this methodology requires adjustment when utilizing DB returns from an API (such as the Bubble SQL API): the first item can return non-empty even for a count=0 return, one must run a check on an attribute in order to determine true emptyness for a count…

Count is 0 even though I have data

Need help Database

mikeloc August 24, 2022, 7:30pm 2

Hi there, @santiagopoli3… the issue could be related to privacy rules, specifically this rule. So, check out that link and see if it helps.

Best…
Mike

Topic		Replies	Views
Is "first item is not empty" faster than "count > 0"? App Organization	16	4211	April 5, 2023
Improvement in implementation of “:count is 0” Announcements	31	1203	September 14, 2024
Is ":count = 0" faster, or ":first item is empty"? Database	6	1399	January 20, 2024
Anyone having issues with :count or database calls? Bugs	4	332	September 15, 2022
When Search for... :count > 0 - is activated? Need help	2	984	December 2, 2021

Count is 0 even though I have data

Related topics