help to query for sql field

  • Moliseexplorer di Alessandro Colombo
  • Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
6 months 3 weeks ago #113343 by Moliseexplorer di Alessandro Colombo
help to query for sql field was created by Moliseexplorer di Alessandro Colombo
Hello i need help to create the query for a sql field that pulls out the list of the name of the registrants of the event to which I am registering now (I need to indicate the parent of a minor who is registered at the event).
Thank you

Please Log in or Create an account to join the conversation.

More
6 months 3 weeks ago #113385 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic help to query for sql field
Hi

1. You will have to create a new SQL custom field, assign it to that event, so for each event like this, you will have to create a SQL Command

2. Try to use the SQL command below:

SELECT CONCAT(`first_name`, ' ', `last_name`) as value, CONCAT(`first_name`, ' ', `last_name`) AS text FROM #__eb_registrants WHERE event_id = 100 AND published = 1

(Replace 100 in the SQL command above with ID of the event you are registering for)

Then check the result, it should work as expected

Regards,

Tuan
The following user(s) said Thank You: Moliseexplorer di Alessandro Colombo

Please Log in or Create an account to join the conversation.

  • Moliseexplorer di Alessandro Colombo
  • Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
6 months 3 weeks ago #113412 by Moliseexplorer di Alessandro Colombo
Replied by Moliseexplorer di Alessandro Colombo on topic help to query for sql field
thank you very much, it works perfectly!

Please Log in or Create an account to join the conversation.

More
6 months 3 weeks ago #113419 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic help to query for sql field
Great. Happy to heart that and thanks for confirming

Regards,

Tuan

Please Log in or Create an account to join the conversation.

Moderators: Tuan Pham Ngoc