How can I retrieve items with an empty field?

micker
Offline
Administrator

4 years 9 months ago #78110 by micker

Replied by micker on topic How can I retrieve items with an empty field?

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

FLEXIcontent is Free but involves a very big effort on our part.
Like the our support? (for a bug-free FC, despite being huge extension) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing reviews. Thanks![/size]

Please Log in or Create an account to join the conversation.

ggppdk
Offline
Administrator

4 years 9 months ago #78111 by ggppdk

Replied by ggppdk on topic How can I retrieve items with an empty field?

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

-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...

Please Log in or Create an account to join the conversation.

grabit
Topic Author
Offline
Platinum Member

4 years 9 months ago #78113 by grabit

Replied by grabit on topic How can I retrieve items with an empty field?

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

An Apple a days keeps the doctor away

Please Log in or Create an account to join the conversation.

grabit
Topic Author
Offline
Platinum Member

4 years 9 months ago #78116 by grabit

Replied by grabit on topic How can I retrieve items with an empty field?

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

An Apple a days keeps the doctor away

Please Log in or Create an account to join the conversation.

ggppdk
Offline
Administrator

4 years 9 months ago #78120 by ggppdk

Replied by ggppdk on topic How can I retrieve items with an empty field?

Hello

in phpmyadmin or similar tool, use the following query
- replace PPP with your DB table prefix
- replace 57 with the field ID of your field

Code:

SELECT  c.id, c.title
FROM  PPP_content AS c
        LEFT JOIN PPP_flexicontent_fields_item_relations AS v
            ON (c.id = v.item_id AND v.field_id = 57)
WHERE  v.item_id IS NULL;

Please Log in or Create an account to join the conversation.

grabit
Topic Author
Offline
Platinum Member

4 years 9 months ago #78124 by grabit

Replied by grabit on topic How can I retrieve items with an empty field?

Ok thats fine but if I want to have an easyer way to find the items from the backen.

Is it another way with php in an automatic field?

So I can have a filter in the item list and a column with yes or no for the automatic field called Map defined.

Possible?

An Apple a days keeps the doctor away

Please Log in or Create an account to join the conversation.