- Forums
- Support and Presales
- Professional Members Support
- CB Query Field not working the same like before.
CB Query Field not working the same like before.
- tlwebdesign
- OFFLINE
-
Junior Member
- Posts: 35
- Thanks: 3
- Karma: 0
2 weeks 23 hours ago #337812
by tlwebdesign
Hi,
I'm in the process op updating a community website that was still on J3, CB 2.6.0 and Query Field Plugin 5.0.4+build.2017.04.27.01.40.36.d2d5b6dda
There i have this query on a field: SELECT * FROM `personeelsnummers` WHERE `personeelsnummer`='[value]' AND `status` = 'Toevoegen' AND NOT EXISTS( SELECT * FROM `uxn04_comprofiler` WHERE `cb_personeelsnummer`='[value]')
Somehow this only worked during registration and not on editing the user in the back-end. Else the validation would fail in backend.
Well i just now updated to latest CB and Plugin versions and it stopped working like it worked before. Now the validation is also triggered when editing a user on the back-end.
What do i need to do to get the same behaviour as i had before?
This code is actually from your tutorial about membership. But that is broken too then because this validation now also runs on editing a user. not only on registration like it did before.
Kind regards,
Tom
CB Query Field not working the same like before. was created by tlwebdesign
Hi,
I'm in the process op updating a community website that was still on J3, CB 2.6.0 and Query Field Plugin 5.0.4+build.2017.04.27.01.40.36.d2d5b6dda
There i have this query on a field: SELECT * FROM `personeelsnummers` WHERE `personeelsnummer`='[value]' AND `status` = 'Toevoegen' AND NOT EXISTS( SELECT * FROM `uxn04_comprofiler` WHERE `cb_personeelsnummer`='[value]')
Somehow this only worked during registration and not on editing the user in the back-end. Else the validation would fail in backend.
Well i just now updated to latest CB and Plugin versions and it stopped working like it worked before. Now the validation is also triggered when editing a user on the back-end.
What do i need to do to get the same behaviour as i had before?
This code is actually from your tutorial about membership. But that is broken too then because this validation now also runs on editing a user. not only on registration like it did before.
Kind regards,
Tom
Please Log in to join the conversation.
krileon
Team Member- ONLINE
- Posts: 68543
- Thanks: 9093
- Karma: 1434
2 weeks 21 hours ago #337820
by krileon
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.
Replied by krileon on topic CB Query Field not working the same like before.
Backend validation can be turned off within CB > Configuration > User Profile by setting "Fields Validation in User Management" to "No". This isn't field specific. I don't quite understand what you're trying to accomplish with that query though. Ideally your NOT EXISTS should probably take into account self (e.g. AND `user_id` != '[user_id]').
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 to join the conversation.
Moderators: beat, nant, krileon
- Forums
- Support and Presales
- Professional Members Support
- CB Query Field not working the same like before.
Time to create page: 0.246 seconds
-
You are here:
- Home
- Forums
- Support and Presales
- Professional Members Support
- CB Query Field not working the same like before.