Filter on Meta Field

  • Resolved ldeschenes

    (@ldeschenes)


    9 years, 9 months ago

    Hi,

    Thanks for the great plugin.

    I want to display only some rows of a table by using the filter parameter. The syntax below works fine for User Email:
    [cfdb-table form=”Preuve d’assurance” filter=”from_email=$user_email” show=”Appartement,Du,Au,Type,Police,from_email,date_time”]

    But I would like to filter instead on another meta field stored in the wp-usermeta data table. I use “Ultimate Member” plugin and at time of registration I capture extra fields. One of them the Appartement Number has a meta key of “appartement”.

    I tried the syntax filter=”Appartement=$_GET(appartement)” but that does not work.

    Please help.

    https://wordpress.org/plugins/contact-form-7-to-database-extension/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Michael Simpson

    (@msimpson)

    9 years, 9 months ago

    The plugin doesn’t support that directly.

    You might be able to do it by coding your own custom filter function.

    Thread Starter ldeschenes

    (@ldeschenes)

    9 years, 9 months ago

    Thanks for the suggestion and the plugin “Shortcodes Actions and Filters”.
    That did the job.

    For those wanting to do same:

    1) Created a function:
    require_once(ABSPATH . ‘wp-content/plugins/contact-form-7-to-database-extension/CFDBPermittedFunctions.php’);
    function user_appartement()
    {
    $user_id = get_current_user_id(); $key = ‘appartement’; $single = true;
    $appartement = get_user_meta( $user_id, $key, $single );
    return $appartement;
    }
    cfdb_register_function(‘user_appartement’);

    2) Used the function in Filter:
    [cfdb-table form=”xxx” filter=”Appartement=user_appartement()”]

    Plugin Author Michael Simpson

    (@msimpson)

    9 years, 9 months ago

    Very nice.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Filter on Meta Field’ is closed to new replies.