https://legacy.forums.gravityhelp.com/topic/querying-the-gravity-form-db Gravity Support Forums Topic: Querying the Gravity Form DB en-US Mon, 06 Apr 2026 06:43:40 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/querying-the-gravity-form-db#post-27959 Thu, 16 Jun 2011 14:46:57 +0000 mrkeroppi 27959@https://legacy.forums.gravityhelp.com/ <p>Thanks Alex, That was the push I needed. I really appreciate the hard work. </p> https://legacy.forums.gravityhelp.com/topic/querying-the-gravity-form-db#post-27955 Thu, 16 Jun 2011 14:38:04 +0000 Alex Cancado 27955@https://legacy.forums.gravityhelp.com/ <p>Try the following. It is a little long, but should get you the information you need.<br /> You will need to adjust it to fit your real scenario. You might be able to do it yourself by just following the existing pattern in the query, but if you have problems doing that, just let me know and I will help you.</p> <pre><code>[sql] SELECT person, sum(is_apple) as apples, round((sum(is_apple)/count(*))*100) as percent_apple, sum(is_mango) as mangos, round((sum(is_mango)/count(*))*100) as percent_mango FROM( SELECT person.value as person, fruit.value as fruit, if(fruit.value = &#39;Apple&#39;, 1, 0) as is_apple, if(fruit.value = &#39;Mango&#39;, 1, 0) as is_mango FROM ( SELECT lead_id, value FROM alien_rg_lead_detail WHERE form_id=173 AND field_number=1 ) person INNER JOIN ( SELECT lead_id, value FROM alien_rg_lead_detail WHERE form_id=173 AND field_number=2 ) fruit ON person.lead_id = fruit.lead_id ) stat GROUP BY person</code></pre> https://legacy.forums.gravityhelp.com/topic/querying-the-gravity-form-db#post-27921 Thu, 16 Jun 2011 11:28:44 +0000 mrkeroppi 27921@https://legacy.forums.gravityhelp.com/ <p>After scouring various poll and survey plugins to find what I needed I have decided because of GF's flexibility it's probably best to start with it and go from there. What i'm trying to achieve is a poll of sorts.</p> <p>Thanks to this post (<a href="http://www.gravityhelp.com/forums/topic/getting-values-from-the-database" rel="nofollow">http://www.gravityhelp.com/forums/topic/getting-values-from-the-database</a>) I was able to figure out the way GF stores the data in the wp_rg_lead_detail.</p> <p>Here is an example of the the results taken from a simple form that asks what type of person you are and what's your favorite fruit. (Only example material, This site would be extremely boring if this was my goal.)</p> <p>id lead_id field_number value<br /> 1 1 1 Angry<br /> 2 1 2 Apples<br /> 3 2 1 Angry<br /> 4 2 2 Grapes<br /> 5 3 1 Happy<br /> 6 3 2 Apples<br /> 7 4 1 Sad<br /> 8 4 2 Oranges</p> <p>For each person type (field_number = 1) I have crated a page and would like to output fruit preferences in percentage format. Obviously my sql skills are lacking. Any help would be greatly appreciated. If there is a better way of doing this please let me know. </p>