Using Hidden Feature to add a search field to backend Registrant Management

I would like to be able to search the backend registrant list by the user_id and group_id fields. Those are both stored in the eb_registrants table, so I assumed they would be searchable.

I tried to use the hidden feature you introduced in EB 3.0.0. to enable this search. However, when I use the URL and field_id=user_id (or field_id=group_id) I get a message
"An error has occurred.
0 The field does not exist"

Thinking the hidden feature was perhaps only for custom fields, I also tried it with several custom fields, but still get the same error as above.
This is the URL format that I am using (from the 3.0.0 changelog)

domain.com/index.php?option=com_eventboo...le&field_id=field_id

Is there a way to make this work for us ?

Thank you -

Hello

That hidden feature won't work, sorry. You would have to edit code in the file administrator/components/com_eventbooking/model/common/registrants.php

Look for:

$config = [
'tbl.first_name',
'tbl.last_name',
'tbl.organization',
'tbl.email',
'tbl.transaction_id',
'tbl.invoice_number',
'tbl.ticket_qrcode',
'tbl.ticket_code'
];

Add 'tbl.user_id' and 'tbl.group_id' into the array and it would work well

Regards,

Tuan

That works very well, thank you Tuan !

Great. Happy to hear that