Display/Export Custom SQL Output as Registration List

  • Nicholas Flint
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
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.
 

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

  • Tuan Pham Ngoc
  • Away
  • Administrator
  • Administrator
More
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

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

  • Nicholas Flint
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
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
  • Administrator
More
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

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

Moderators: Tuan Pham Ngoc