https://legacy.forums.gravityhelp.com/topic/how-to-query-database Gravity Support Forums Topic: How to query database en-US Sun, 19 Apr 2026 23:22:30 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/how-to-query-database#post-52887 Mon, 19 Mar 2012 15:34:35 +0000 mobilus 52887@https://legacy.forums.gravityhelp.com/ <p>Thanks for taking the time to detail your solution. This will definitely help. Cheers,<br /> Mike </p> https://legacy.forums.gravityhelp.com/topic/how-to-query-database#post-52881 Mon, 19 Mar 2012 15:03:23 +0000 placson 52881@https://legacy.forums.gravityhelp.com/ <p>I had to do a complicated subquery in order to get my results. There's no native way to read the field_number values from the wp_rg_form table to get the column names. Essentially the problem is that Gravity Forms allows for dynamic tables by creating rows in the wp_rg_lead_detail table. To display your rows as a column you have to do a row to column, pivot table. To achieve this a sub query is required. My query ended up looking like this mess:</p> <p>1) I created a view called 'bjj'</p> <p><code>create view bjj as select * from wp_rg_lead_detail where form_id=1</code></p> <p>2) My query looked like this madness:</p> <pre><code>select lead_id as entryId ,(select value from bjj where field_number=1 and lead_id = entryId) as email ,(select value from bjj where round(field_number,2) = 2.3 and lead_id = entryId) as first_name ,(select value from bjj where round(field_number,2) = 2.6 and lead_id = entryId) as last_name ,(select value from bjj where round(field_number,2) = 5.1 and lead_id = entryId) as address1 ,(select value from bjj where round(field_number,2) = 5.2 and lead_id = entryId) as address2 ,(select value from bjj where round(field_number,2) = 5.3 and lead_id = entryId) as city ,(select value from bjj where round(field_number,2) = 5.4 and lead_id = entryId) as state ,(select value from bjj where round(field_number,2) = 5.5 and lead_id = entryId) as zip ,(select value from bjj where round(field_number,2) = 5.6 and lead_id = entryId) as country ,(select value from bjj where round(field_number,2) = 63.0 and lead_id = entryId) as phone ,(select value from bjj where round(field_number,2) = 66.0 and lead_id = entryId) as age from bjj group by entryId order by entryId</code></pre> <p>Since GF uses floats for the field_number you have to accomodate by doing the ugly round(...). You have to know firsthand what your field_numbers map to. In my case I had to manually examine the field_number/values pair to find out what they were mapped to (e.g. 66.0 mapped to the age column).</p> <p>Hope that helps you out. </p> https://legacy.forums.gravityhelp.com/topic/how-to-query-database#post-52876 Mon, 19 Mar 2012 13:48:56 +0000 mobilus 52876@https://legacy.forums.gravityhelp.com/ <p>I'm also interested in learning how to generate a list of my entries. If you get help, can you post your findings. thanks, Mike </p> https://legacy.forums.gravityhelp.com/topic/how-to-query-database#post-52593 Thu, 15 Mar 2012 15:46:51 +0000 placson 52593@https://legacy.forums.gravityhelp.com/ <p>Hello? Any help out there? </p> https://legacy.forums.gravityhelp.com/topic/how-to-query-database#post-52315 Tue, 13 Mar 2012 19:30:17 +0000 placson 52315@https://legacy.forums.gravityhelp.com/ <p>Hi there.. is this possible to do from SQL or do I have to deserialize the strings stored in the form table? </p> https://legacy.forums.gravityhelp.com/topic/how-to-query-database#post-52174 Mon, 12 Mar 2012 19:10:52 +0000 placson 52174@https://legacy.forums.gravityhelp.com/ <p>I've looked at the wp_rg tables and I found that this query will return all the fields and their values. However the field_number is just a number. Where are the values for the field_number stored?</p> <p> select id, field_number, value from wp_rg_lead_detail where form_id=1;</p> <p>I have 3 forms and the 1st form has form_id = 1. The values returned are:</p> <p>| 17971 |5.3| Stockton<br /> | 17972 |5.4 | California<br /> | 17973 |5.5 | 95212</p> <p>Where are my field_number values? </p>