- Posts: 13
- Thank you received: 0
Please post all pre-sales questions of all products on this forum
Custom Field-SQL, session variables
- Aaron
- Topic Author
- Offline
- New Member
-
Less
More
9 years 8 months ago #67887
by Aaron
Custom Field-SQL, session variables was created by Aaron
Hi,
We are creating a custom field that selects students based on parent (loggedIn User).
How can we grab the session variables that indicate loggedIn Users email for the "Default Values" field in our Custom Field dropdown?
Thank you so very much!
Aaron and Vida
We are creating a custom field that selects students based on parent (loggedIn User).
Code:
select a.studentfname as text, a.studentfname as value, a.parent2email as m from youth a, _eb_registrants b
where b.email = a.parent2email and b.email = [EMAIL]
How can we grab the session variables that indicate loggedIn Users email for the "Default Values" field in our Custom Field dropdown?
Thank you so very much!
Aaron and Vida
Please Log in or Create an account to join the conversation.
- Tuan Pham Ngoc
- Offline
- Administrator
-
9 years 8 months ago #67894
by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Custom Field-SQL, session variables
Hi Aaron
In short, you will have to customize the code. Please let us know what extension you are using so that we can give you the solution
Regards,
Tuan
In short, you will have to customize the code. Please let us know what extension you are using so that we can give you the solution
Regards,
Tuan
Please Log in or Create an account to join the conversation.
- Aaron
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 13
- Thank you received: 0
9 years 8 months ago #67963
by Aaron
Replied by Aaron on topic Custom Field-SQL, session variables
We have purchased the Event Booking software.
Please Log in or Create an account to join the conversation.
- Aaron
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 13
- Thank you received: 0
9 years 8 months ago #68110
by Aaron
Replied by Aaron on topic Custom Field-SQL, session variables
Hi! Any solution yet? The ability to use userid in query would be very useful.
Please Log in or Create an account to join the conversation.
- Tuan Pham Ngoc
- Offline
- Administrator
-
9 years 8 months ago #68124
by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Custom Field-SQL, session variables
Hi
You can get this file, unzip it, upload to administrator/components/com_eventbooking/libraries/rad/form/field folder of your site
After that, you can use [USER_ID] and [USER_EMAIL] tag. It will be replaced with the ID and Email of the logged in users in the query
Regards,
Tuan
You can get this file, unzip it, upload to administrator/components/com_eventbooking/libraries/rad/form/field folder of your site
After that, you can use [USER_ID] and [USER_EMAIL] tag. It will be replaced with the ID and Email of the logged in users in the query
Regards,
Tuan
- Aaron
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 13
- Thank you received: 0
9 years 8 months ago #68153
by Aaron
Replied by Aaron on topic Custom Field-SQL, session variables
Excellent! Thank you for the support. We will test it out and report back here.
Please Log in or Create an account to join the conversation.
- Aaron
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 13
- Thank you received: 0
9 years 8 months ago #68162
by Aaron
Replied by Aaron on topic Custom Field-SQL, session variables
Works great. Thanks again. Surely others will use this new feature.
Please Log in or Create an account to join the conversation.
- Tuan Pham Ngoc
- Offline
- Administrator
-
9 years 8 months ago #68184
by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Custom Field-SQL, session variables
Thanks for confirming. I will add it to the core download package and will include it in the next release, then.
Tuan
Tuan
Please Log in or Create an account to join the conversation.
- Aaron
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 13
- Thank you received: 0
9 years 6 months ago #71008
by Aaron
Replied by Aaron on topic Custom Field-SQL, session variables
Hello Tuan,
I was wondering if you were able to include this change to the new version. I don't want to upgrade until I know how the change was implemented and if I need to change the custom fields.
We had altered code to include the ability to use the "userID" in queries for data to populate dropdown custom fields. Also this behavior "breaks" the administrative editing of the registration record as the custom field uses the administrator's userid instead of the registrant's userid. Does this behavior continue with the new version?
Thank you
Aaron
I was wondering if you were able to include this change to the new version. I don't want to upgrade until I know how the change was implemented and if I need to change the custom fields.
We had altered code to include the ability to use the "userID" in queries for data to populate dropdown custom fields. Also this behavior "breaks" the administrative editing of the registration record as the custom field uses the administrator's userid instead of the registrant's userid. Does this behavior continue with the new version?
Thank you
Aaron
Please Log in or Create an account to join the conversation.
- Tuan Pham Ngoc
- Offline
- Administrator
-
9 years 6 months ago #71043
by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Custom Field-SQL, session variables
Hi Aaron
No, we haven't integrated this change into the extension yet. I will try to spend sometime next week to see whether I can integrate this change into version 2.0.6 of the extension
Regards,
Tuan
No, we haven't integrated this change into the extension yet. I will try to spend sometime next week to see whether I can integrate this change into version 2.0.6 of the extension
Regards,
Tuan
Please Log in or Create an account to join the conversation.
Moderators: Tuan Pham Ngoc, Giang Dinh Truong, Mr. Dam
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.