- Posts: 49
- Thank you received: 0
Display/Export Custom SQL Output as Registration List
- Nicholas Flint
- Topic Author
- Offline
- Senior Member
-
Less
More
3 years 1 month ago #150563
by Nicholas Flint
I'm looking at the Registration List that is displayed after selecting an event. Is it possible to display the output of a custom SQL query instead of the current table?
For example, I have a query that displays the first and last name followed by a single column showing the values of fields with a name following a specified pattern:
firstname | lastname | field1, field2, field3
firstname | lastname | field4
firstname | lastname | field2, field7
Ideally, I'd like to be able to export this query in place of the default export.
Display/Export Custom SQL Output as Registration List was created by Nicholas Flint
I'm looking at the Registration List that is displayed after selecting an event. Is it possible to display the output of a custom SQL query instead of the current table?
For example, I have a query that displays the first and last name followed by a single column showing the values of fields with a name following a specified pattern:
firstname | lastname | field1, field2, field3
firstname | lastname | field4
firstname | lastname | field2, field7
Ideally, I'd like to be able to export this query in place of the default export.
Please Log in or Create an account to join the conversation.
- Tuan Pham Ngoc
- Away
- Administrator
-
3 years 1 month ago #150579
by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Display/Export Custom SQL Output as Registration List
Hello Nicholas
This is not possible, unfortunately. Depends on how you want to display it and where to get data from, you will have to customize code of registrants list
Tuan
This is not possible, unfortunately. Depends on how you want to display it and where to get data from, you will have to customize code of registrants list
Tuan
Please Log in or Create an account to join the conversation.
- Nicholas Flint
- Topic Author
- Offline
- Senior Member
-
Less
More
- Posts: 49
- Thank you received: 0
3 years 1 month ago #150602
by Nicholas Flint
Replied by Nicholas Flint on topic Display/Export Custom SQL Output as Registration List
What file would I edit to customize that page?
Please Log in or Create an account to join the conversation.
- Tuan Pham Ngoc
- Away
- Administrator
-
3 years 1 month ago #150610
by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Display/Export Custom SQL Output as Registration List
Hello Nicholas
components/com_eventbooking/themes/default/registrantlist/default.php is the file which display registrants list. You need to customize that file
Once the change is done, please move the modified file to PATH_TO_TEMPLATE/html/com_eventbooking/registrantlist folder so that the change won't be lost when you update to future releases of the extension
Regards,
Tuan
components/com_eventbooking/themes/default/registrantlist/default.php is the file which display registrants list. You need to customize that file
Once the change is done, please move the modified file to PATH_TO_TEMPLATE/html/com_eventbooking/registrantlist folder so that the change won't be lost when you update to future releases of the extension
Regards,
Tuan
Please Log in or Create an account to join the conversation.
Moderators: Tuan Pham Ngoc
Support
Documentation
Information
Copyright © 2025 Joomla Extensions by Joomdonation. All Rights Reserved.
joomdonation.com is not affiliated with or endorsed by the Joomla! Project or Open Source Matters.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.