How can I retrieve items with an empty field?

I want to find in the backend a list of items that have not yet info in a specific field.

Is it possible?

For instance I am looking for items where the international address is still empty.

Thanks for your help.

I am pushing top this question because I need to find this issue in more than 1000 items.

i don't think ...
maybe you can add filed in item list bakend

Hi Micker,

I am lost with this issue.

My idea was to store properties as field for the "longitude" in a text field called "Longitude"

The create a radio-button field "ismapset" with values 0 for no and 1 for yes and then make an automatic value creation with the prop version in php.

Here is my code
The problem is that the code returns always "0" in both case empty or not.

Where is my mistake?

try !empty instead of isset

Still 0 (no) as answer.

did you do a dump of $F = & $item->fields; ? to check more your value ?

Hello

you want an SQL query ?

- if no value was added in DB an SQL query is a simple / easy solution to find them using a "LEFT JOIN"

- if these items have an address partly filled (but miss some info (like e.g. "business name" property) ) then it you will need a PHP script that gets all items and loops through them

I am not fluent with such coding. How can I do that?

A sql query would be perfect, I just need to know if the field has ben completed or is still empty.