- Posts: 13
- Thank you received: 1
SQL field display on Subscription Management
- preflight
- Topic Author
- Offline
- New Member
-
Less
More
1 year 2 weeks ago #165608
by preflight
SQL field display on Subscription Management was created 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?
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
- Offline
- Administrator
-
1 year 2 weeks 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
Regards,
Tuan
Please Log in or Create an account to join the conversation.
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.