Sorry if this is already posted - I couldn’t find it anywhere.

Is it possible to limit the entries viewed by author_id or member_id?  In other words, if I am logged in I would like to only show my entries (this is for a very basic event registration form that I am building and I want attendees to be able to see if they have already submitted some requested information).

Thanks.

Geoff

For the record, I came across this thread www.solspace.com/forums/viewthread/436/ but I’m not 100% sure that it’s telling me it can’t be done.  I really hope not, or I’ve wasted a day of work… :(

Seems like a simple thing to accomplish in EE.

Mr. T,

exp:freeform:entries does not currently have a filter for member_id. We’ll add that as a feature request. You could use exp:query to get the data from the Freeform DB though.

mk

Mitchell-

Thanks for the reply.  I went ahead and built a weblog instead which I think is going to work - just a bit more complicated! 

I look forward to seeing what new ideas you guys come up with.  Great tools!

Geoff

Mitchell Kimbrough - 01 July 2008 07:58 AM

exp:freeform:entries does not currently have a filter for member_id. We’ll add that as a feature request. You could use exp:query to get the data from the Freeform DB though.

Hi,

I tried using the exp:query module to accomplish this using the following code:

Unfortunately, the query is returning no data. I verified that the statement is correct by hard coding the author_id (e.g. 1) in the SQL statement. Are you not allowed to use global variables within exp:query? How would one go about pulling data from the DB dynamically (according to author_id)

Thanks,

Steve