Please post all pre-sales questions of all products on this forum

Custom Field-SQL, session variables

More
9 years 8 months ago #67887 by Aaron
Hi,
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.

More
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

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

More
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.

More
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.

More
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
Attachments:

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

More
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.

More
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.

More
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

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

More
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

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

More
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

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

Moderators: Tuan Pham NgocGiang Dinh TruongMr. Dam