Count Records where Field is Empty

Matt

A rather basic question here.

I'm able to query records from a related table, such as Users who've created a record in a separate table.

Some records will be "deleted" where I'll be adding a timestamp to those records as shown in the image.

I'd like to ignore these records where there is a timestamp present. Assuming this is good practice - happy to hear suggestions.

Any help is appreciated![Screen Shot 2021-11-13 at 8.36.02 PM.png]

Sean Montgomery

 you can do this in a QUERY ALL RECORDS command.

https://docs.xano.com/working-with-data/functions/database-requests/query-all-records
It sounds like you would just do date_deleted = null

You can change the return type to "count" which would give you a number.

Matt

Beauty - thanks. I overlooked using the 'null' input in the Custom Query as an "AND" function. 

Solved!