Skip to Content Skip to Menu

🕒 Save Time and Effort with CB Editor Assistant: Effortlessly create and refine content in Joomla 3, 4, & 5.
🎁 Limited Offer: Enjoy a 5-day FREE trial and save up to 30% afterward!

DB lookup vs Query ?

  • activha
  • activha
  • OFFLINE
  • Posts: 2336
  • Thanks: 117
  • Karma: 13
12 years 1 month ago #216377 by activha
Replied by activha on topic Re: DB lookup vs Query ?
This is not what we want.

Is there a way to have such a dynamic or Ajax check of DB with one of CB tool ?

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48700
  • Thanks: 8317
  • Karma: 1447
12 years 1 month ago #216410 by krileon
Replied by krileon on topic Re: DB lookup vs Query ?
It's possible as there is API for it; it's just the field doesn't utilize it. So you'll need to implement it or develop a new plugin to provide such a feature.


Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

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

  • activha
  • activha
  • OFFLINE
  • Posts: 2336
  • Thanks: 117
  • Karma: 13
11 years 8 months ago #226609 by activha
Replied by activha on topic Re: DB lookup vs Query ?
I am coming back on this subject.

Is it possible now with Ajax fields to make such a DB lookup request at registration ? To check whether the submitting is allowed to do certain things for instance.

Thanks

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48700
  • Thanks: 8317
  • Karma: 1447
11 years 8 months ago #226662 by krileon
Replied by krileon on topic Re: DB lookup vs Query ?
No, DB Lookup field doesn't have AJAX usage implemented. The core fields ajax plugin just allows fields to be edited inline within your profile for example; it does not add ajax value checking to fields that don't have it.


Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

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

  • activha
  • activha
  • OFFLINE
  • Posts: 2336
  • Thanks: 117
  • Karma: 13
11 years 8 months ago #227066 by activha
Replied by activha on topic Re: DB lookup vs Query ?
Thanks Kyle

So there is no way to check a value dynamically in CB tables on the registration page ?

We have the reference id retrieved by PAP from the cookie, then inserted by auto action in the CB field prior to registration form display. This works ok and the new registrant is correctly set as sub affiliate of the reference id user retrieved.

Basically we want now to retrieve and display the userdata corresponding to this reference id in CB tables but we cannot find a way to do it as the reference id inserted by auto action is inserted by javascript.

Is there a way to have DB queries on CB tables by javascript after the registration form display ?
Can I use the cookie to make a query before the registration form display ?

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48700
  • Thanks: 8317
  • Karma: 1447
11 years 8 months ago #227093 by krileon
Replied by krileon on topic Re: DB lookup vs Query ?

So there is no way to check a value dynamically in CB tables on the registration page ?

No, the CB DB Lookup field does not have ajax validation. It will validate when the form is posted though.

Basically we want now to retrieve and display the userdata corresponding to this reference id in CB tables but we cannot find a way to do it as the reference id inserted by auto action is inserted by javascript.

Is there a way to have DB queries on CB tables by javascript after the registration form display ?
Can I use the cookie to make a query before the registration form display ?

You're already setting the ID to a CB field so you can do a query in a CB Query Field and substitute in the ID as needed. This won't be ajax of course and is only going to display on profile for example.


Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

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

Moderators: beatnantkrileon
Powered by Kunena Forum