Hello,

Sorry for my english, I'm french.

I created a table with a sql query :

SELECT ID, DATE_FORMAT(post_date, "%d/%m/%Y %H:%i:%s") AS date, (
    SELECT meta_value
    FROM jc_postmeta 
    WHERE post_id = jc_posts.id 
    AND meta_key = '_field_email'
) AS email, (
    SELECT
        CASE
            WHEN meta_value LIKE '%Non%' THEN 'Non'
            WHEN meta_value LIKE '%Oui%' THEN 'Oui'
            ELSE ''
        END
    FROM jc_postmeta 
    WHERE post_id = jc_posts.id 
    AND meta_key = '_field_souscription'
) AS souscription, (
    SELECT meta_value
    FROM jc_postmeta 
    WHERE post_id = jc_posts.id 
    AND meta_key = '_field_civilite'
) AS civilite, (
    SELECT meta_value
    FROM jc_postmeta 
    WHERE post_id = jc_posts.id 
    AND meta_key = '_field_nom'
) AS nom, (
    SELECT meta_value
    FROM jc_postmeta 
    WHERE post_id = jc_posts.id 
    AND meta_key = '_field_prenom'
) AS prenom, (
    SELECT meta_value
    FROM jc_postmeta 
    WHERE post_id = jc_posts.id 
    AND meta_key = '_field_adresse_1'
) AS adresse_1, (
    SELECT meta_value
    FROM jc_postmeta 
    WHERE post_id = jc_posts.id 
    AND meta_key = '_field_adresse_2'
) AS adresse_2, (
    SELECT meta_value
    FROM jc_postmeta 
    WHERE post_id = jc_posts.id 
    AND meta_key = '_field_code_postal'
) AS code_postal, (
    SELECT meta_value
    FROM jc_postmeta 
    WHERE post_id = jc_posts.id 
    AND meta_key = '_field_ville'
) AS ville, (
    SELECT meta_value
    FROM jc_postmeta 
    WHERE post_id = jc_posts.id 
    AND meta_key = '_field_telephone'
) AS telephone, (
    SELECT
        CASE
            WHEN meta_value LIKE '%Non%' THEN 'Non'
            WHEN meta_value LIKE '%Oui%' THEN 'Oui'
            ELSE ''
        END
    FROM jc_postmeta 
    WHERE post_id = jc_posts.id 
    AND meta_key = '_field_client_jardicoop'
) AS client_jardicoop, (
    SELECT meta_value
    FROM jc_postmeta 
    WHERE post_id = jc_posts.id 
    AND meta_key = '_field_code_client'
) AS code_client, (
    SELECT
        CASE
            WHEN meta_value LIKE '%Non%' THEN 'Non'
            WHEN meta_value LIKE '%Oui%' THEN 'Oui'
            ELSE ''
        END
    FROM jc_postmeta 
    WHERE post_id = jc_posts.id 
    AND meta_key = '_field_compte_urssaf'
) AS compte_urssaf, (
    SELECT meta_value
    FROM jc_postmeta 
    WHERE post_id = jc_posts.id 
    AND meta_key = '_field_numero_urssaf'
) AS numero_urssaf
FROM jc_posts
WHERE jc_posts.post_type = 'flamingo_inbound'
AND jc_posts.post_content LIKE '%credit-impot-instantane%'
ORDER BY jc_posts.id DESC

But when I try to filter these datas (whatever I filter), the result is always the same : "Aucun élément à afficher" (no result). Even the search input, without the Powerful Filter add-on, doesn't work.

Where is the problem ?

Thanks for your help

Bests regards

Pierre

Hello Miloš,

 Thanks for your reply. Finally, I've unchecked "Enable server-side processing" and it's good ! I can filter my table.

Thanks again

Bests regards

Pierre