https://legacy.forums.gravityhelp.com/topic/get-entry-object-by-user-id Gravity Support Forums Topic: Get entry object by user ID en-US Thu, 23 Apr 2026 16:34:24 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/get-entry-object-by-user-id#post-28708 Tue, 28 Jun 2011 13:45:15 +0000 Justin Tadlock 28708@https://legacy.forums.gravityhelp.com/ <p>Thanks, Alex. That's all I needed to know. I was hoping there was a quick function, but I'm okay with using an SQL statement. </p> https://legacy.forums.gravityhelp.com/topic/get-entry-object-by-user-id#post-28706 Tue, 28 Jun 2011 13:37:39 +0000 Alex Cancado 28706@https://legacy.forums.gravityhelp.com/ <p>Justin,<br /> To query the entry data using the created_by field, you can use the following SQL statement.<br /> <pre><code>[sql] SELECT l.*, field_number, value FROM wp_rg_lead l INNER JOIN wp_rg_lead_detail ld ON l.id = ld.lead_id WHERE l.created_by=%d</code></pre> <p>The only caviat is that this won't return you the data organized the way the entry object is.<br /> To do that you would need to make a call to RGFormsModel::build_lead_array(...);</p> <pre><code>$entries = RGFormsModel::build_lead_array($results, true);</code></pre> <p>The problem is that this method is private. I am not opposed to making it public as I can see it being useful in situations like this, but you will need to get a dev version of Gravity Forms from me. If you are interested, just email me at <a href="mailto:alex@rocketgenius.com">alex@rocketgenius.com</a> and I will send it your way. </p> https://legacy.forums.gravityhelp.com/topic/get-entry-object-by-user-id#post-28681 Tue, 28 Jun 2011 11:14:52 +0000 Justin Tadlock 28681@https://legacy.forums.gravityhelp.com/ <p>I have quick question that I hope you can help with.</p> <p>I need to get an entry object by user ID. The form can only be submitted by logged-in users, so the $entry['created_by'] field is set. I just need to know how to pull the entry from the database using that user's ID.</p> <p>I couldn't find anything in the developer docs, but I might be looking in the wrong place. </p>