Query Visual Form Builder entries

  • Resolved RiaanC

    (@riaanc)


    10 years, 10 months ago

    Hi Jonathan

    I hope you are well.

    Can you tell me if it is possible to use Query Wrangler to query Visual Form Builder Pro (https://ww.wp.xz.cn/plugins/visual-form-builder/) entries? According to my understanding it should be as they are custom field entries?

    VFB is limiting as the display entries add-on will only allow the display of entries from one form at a time and not a consolidated list of all forms’ entries. I had a look at the code and it seems complicated trying to update the VFB code to display entries of all forms in one list.

    Your plugin seemed to be the logical choice to do a custom list of entries and I have used it for this purpose on many projects to great effect – although targeting Advanced Custom Fields. Unfortunately the Post Type is not appearing in the filters, but the fields are displayed in the fields, so nothing returns.

    Any ideas would be appreciated.

    Riaan

    https://ww.wp.xz.cn/plugins/query-wrangler/

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Jonathan Daggerhart

    (@daggerhart)

    10 years, 10 months ago

    Hi RiaanC,

    Just took a look at that plugin, and it does not use post types. All of the forms, fields, and entries are in their own database tables.

    wp_visual_form_builder_entries
    wp_visual_form_builder_fields
    wp_visual_form_builder_forms

    I don’t think there is a way to incorporate this data into query wrangler. The easiest way to show these items would be with a custom database query.

    global $wpdb;
$entries = $wpdb->get_results('SELECT * FROM {$wpdb->prefix}visual_form_builder_entries as e LEFT JOIN {$wpdb->prefix}visual_form_builder_forms as f on f.form_id = e.form_id ');

foreach ( $entries as $entry ){
  $entry->data = maybe_unserialize( $entry->data );
  $entry->emails_to = maybe_unserialize( $entry->emails_to );
  $entry->form_email_to = maybe_unserialize( $entry->form_email_to );

  // all data about this entry, include the form's data
  print_r( $entry );
}

    Not a query wrangler solution, but if you really need it, that code should put you on the right track.

    Thread Starter RiaanC

    (@riaanc)

    10 years, 10 months ago

    Hi Jonathan

    Thank you for the quick response. Pity about that, but understandable.

    Thank you for pointing me in the right direction with the custom query. I will give it a go.

    Riaan

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

The topic ‘Query Visual Form Builder entries’ is closed to new replies.