Custom Fields based SQL query
By Guest on Tuesday, 09 January 2018
Posted in JEvents (Free Access)
Replies 5
Likes 0
Views 2.4K
Votes 0
I manage a few Joomla websites for car clubs and they all use the basic J-Events calendar. Some have requested the ability for members to register for an event in the calendar which i believe can be done using RSVP Pro. These events will be motoring events and users will need to include the particulars of vehicle they will be bringing to the event.

I have added extra fields to Joomla User accounts that define the members vehicles, each user can have several vehicles registered in their Joomla user profile.

Is there a custom field option available in RSVP Pro where by i could use an SQL query to build a select list in the RSVP Pro event to allow registrants to choose a vehicle based on the data in the "_fields_values" table.
Hello,

Yep Certainly. You can also build your own custom fields for RSVP Pro since we scan the RSVP Pro fields folder for the fields so if you created a new it would be auto loaded to be selected.

Many thanks
Tony
Guest
·
Tuesday, 09 January 2018 11:25
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey,

sorry for crashing the thread. But I do have exact the same question for jevents pro custom fields plugin. Tony, is this also valid for the custom field type: 'Database field list'? Can you easily add an where clause to the query? Or create your own? Couldn´t find anything about it in the documentation.

thanks!

Toni
Guest
·
Thursday, 18 January 2018 07:39
·
0 Likes
·
0 Votes
·
0 Comments
·
The database field list allows you to get data related to the user using a query like this


SELECT ug.title FROM #__usergroups AS ug 

INNER JOIN #__user_usergroup_map AS ugm ON ugm.group_id = ug.id 

WHERE ugm.user_id={ATTENDEE_USER_ID}

LIMIT 100
Guest
·
Thursday, 18 January 2018 10:54
·
0 Likes
·
0 Votes
·
0 Comments
·
Geraint, this answer is for adiehm , right?
I´m so sorry adiehm for crashing your thread. I will open another one as answers will conflict.
Guest
·
Thursday, 18 January 2018 13:01
·
0 Likes
·
0 Votes
·
0 Comments
·
No Book - I thought that is what you were asking - i,e, how to add a where clause to the SQL type field
Guest
·
Monday, 22 January 2018 15:54
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post