SQL field display on Subscription Management

  • preflight
  • Topic Author
  • Offline
  • New Member
  • New Member
More
1 month 1 week ago #165608 by preflight
Hey team,

I have a SQL custom field set as: "SELECT id AS value, organization AS text FROM #__osmembership_subscribers WHERE plan_id IN (3,4,5) ORDER BY organization".  It's set to "Show On Subscriptions Management".
This works fine except that on the subscription management table, the column shows the value instead of the text.  Strangely when I first set it up and tested it, it showed the text which is what I would expect.

I can write an override or workaround it, but I think that the management list and export should show the text, no?

 

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

  • Tuan Pham Ngoc
  • Away
  • Administrator
  • Administrator
More
1 month 1 week ago #165609 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic SQL field display on Subscription Management
The extension only stores value of the field in database, so it can only display value. So in case you want to display the text, please try to customize the code

Regards,

Tuan

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