Add filter options in Subscribers for custom field

Hi,

In the Subscriber management section, there is a section where you can filter/search through the subscribers by first name or last name. I would like to add the ability to filter by two of the custom fields that we added.

Which source files would we need to modify to add this filter capability?

Thanks.
V

Hi

You will need to edit code in the folder administrator/components/com_osmembership/views/subscribers to add the filter you want.

You also need to edit the code of subscribers model administrator/components/com_osmembership/models/subscribers.php to modify the SQL command to get the filtered data

Regards,

Tuan

Tuan,

Have been trying to get this to work but am running into issues. As a first step, I have been working to add other fields in administrator/components/com_osmembership/views/subscribers/tmpl/default.php file.

I have been able to add other fields like City or Phone that were part of the original set of fields that were included in Membership Pro. However, when I try and add my custom fields, I get an error. I am wondering if this is an issue because all custom fields are automatically given "osm_" in the title. Either way, this is an important feature I need to get working.

In terms of my options, I was wondering:
a. Would you be willing to take a look at my code and see where I may be going wrong?

or
b. Would you or someone else in your company be able to customize these options for me for a fee?

Thanks.
V

Hi Valerie

For the other custom fields, you cannot simply use the code <?php echo $row->osm_name_of_custom_field; ?> to display data for that custom field (like <?php echo $row->phone ?>, <?php echo $row->city; ?>...

The reason is because the data for these fields are stored in a different database table #__osmembership_field_value

So you will need to write code to get the data for that custom field from the table to display

If you want us to look at the code and customize it for you, I think to display data for the custom fields you want, it will just cost you 30$. However, I am afraid of it is difficult to make it searchable

Tuan