https://legacy.forums.gravityhelp.com/topic/rgformsmodelget_leads-and-some-weird-behavior Gravity Support Forums Topic: RGFormsModel::get_leads and some weird behavior.. en-US Mon, 20 Apr 2026 07:55:44 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/rgformsmodelget_leads-and-some-weird-behavior#post-53502 Mon, 26 Mar 2012 18:01:59 +0000 Dana Cobb 53502@https://legacy.forums.gravityhelp.com/ <p>Hi, innovatagroup,</p> <p>Below is a sample query for you. Your table names may be different depending on your WordPress database prefix, but they should have "rg_lead" and rg_lead_detail" in the name. In the query below I am using form_id=53, change this to your form. I am selecting entries where the first name field has "dana" in it. My first name field is field id 1.3, but because the database field is a float, we use the BETWEEN clause and make the values a float, otherwise you won't get any data back. You would change this to your field id and still subtract and add to the field number.</p> <pre><code>SELECT * FROM wp_rg_lead JOIN wp_rg_lead_detail ON wp_rg_lead.id = wp_rg_lead_detail.lead_id WHERE wp_rg_lead.form_id=53 AND field_number BETWEEN (1.3 - 0.001) AND (1.3 + 0.001) AND value LIKE &#39;%dana%&#39;</code></pre> <p>Let me know if you have questions. </p> https://legacy.forums.gravityhelp.com/topic/rgformsmodelget_leads-and-some-weird-behavior#post-52862 Mon, 19 Mar 2012 13:04:44 +0000 Dana Cobb 52862@https://legacy.forums.gravityhelp.com/ <p>Hi, innovatagroup,</p> <p>I'll see what we can do. </p> https://legacy.forums.gravityhelp.com/topic/rgformsmodelget_leads-and-some-weird-behavior#post-52661 Fri, 16 Mar 2012 09:40:49 +0000 innovatagroup 52661@https://legacy.forums.gravityhelp.com/ <p>Dana,<br /> Thank you for the reply -- I didn't realize that second parameter was the sort field. I was just piecing together the logic from looking at the core source.</p> <p>If you have some resource for creating a custom query, that'd be immensely helpful. I'm sure it would involve all sorts of "fun" joins, and someone with more knowledge of the software would probably have a better go at it. :) </p> https://legacy.forums.gravityhelp.com/topic/rgformsmodelget_leads-and-some-weird-behavior#post-52643 Fri, 16 Mar 2012 00:50:28 +0000 Dana Cobb 52643@https://legacy.forums.gravityhelp.com/ <p>Hi, innovatagroup,</p> <p>The get_leads function does not allow you to pull leads by searching a specific field. The second parameter specifies by which field to sort the results. So, as you saw, if "Tom" is in any of the fields, that lead will be returned. We do not currently have a function that will allow you to select results by searching a single field, you would need to write your own database query. We can point you in the right direction if you need help with the query. </p> https://legacy.forums.gravityhelp.com/topic/rgformsmodelget_leads-and-some-weird-behavior#post-51733 Thu, 08 Mar 2012 08:38:32 +0000 innovatagroup 51733@https://legacy.forums.gravityhelp.com/ <p>Hey all,</p> <p>I've been using the RGFormsModel::get_leads() method to grab entries to a form, let's say form id #5, for use in some other code. I only want to grab entries whose first name field equals "Tom", for example. The first name field is field id #10.</p> <p>So, from what I've found, you'd call:<br /> RGFromsModel::get_leads(5, 10, 'DESC', 'Tom");<br /> Please correct me if I'm wrong here.</p> <p>However, what I find happening is this call will return results for "Tom" from *any field* in the entry. So if some named Paul entered "Tomato" as their favorite food, their entry is returned as well. It's like that second argument in the function call is completely ignored.</p> <p>Anyone else seen this happen? Seems to be a pretty significant bug if I'm understanding this function correctly. (And that's a big "if") </p>