https://legacy.forums.gravityhelp.com/topic/need-the-field-names-via-sql Gravity Support Forums Topic: Need the field names via SQL en-US Thu, 09 Apr 2026 06:08:11 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/need-the-field-names-via-sql#post-42972 Fri, 02 Dec 2011 20:09:12 +0000 David Smith 42972@https://legacy.forums.gravityhelp.com/ <p>Hi Scott,</p> <p>Your best bet will be to do some post processing to the returned data after you've retrieved it form the database. To get the form meta unserialized you can use this:</p> <pre><code>[php] $form = RGFormsModel::get_form_meta($form_id);</code></pre> <p>Then you could loop through the items of your returned data and drill down in the $form array to get the matching field ID and then the corresponding field label.</p> <p>Let me know if you have any other questions. </p> https://legacy.forums.gravityhelp.com/topic/need-the-field-names-via-sql#post-42881 Fri, 02 Dec 2011 13:05:49 +0000 Scott 42881@https://legacy.forums.gravityhelp.com/ <p>I have some sql I use to pull some reports out from the db tables.</p> <pre><code>SELECT pziou_rg_form.id, pziou_rg_form.title, pziou_rg_lead.date_created, pziou_rg_lead.ip, pziou_rg_lead.source_url, pziou_rg_lead_detail.field_number, pziou_rg_lead_detail.&lt;code&gt;value&lt;/code&gt; FROM pziou_rg_form INNER JOIN pziou_rg_lead ON pziou_rg_form.id = pziou_rg_lead.form_id INNER JOIN pziou_rg_lead_detail ON pziou_rg_lead.id = pziou_rg_lead_detail.lead_id</code></pre> <p>Works well, but obviously the fields are only identified by the field number.</p> <p>How/Where can I get that data?</p> <p>I see the _meta table filled with serialized data, but I'm having a bit of trouble understanding how it's formatted. It looks like a multidimensional JSON array. </p>