I just bought the QueryField plugin, I did a test to copy a field in another:
1. on my 'drop down_single' field I add the UPDATE query, the request that copies the selection to another field; in 'integration' part of 'drop/down(unique)' selection (cb_thisfield) , I activated the Query Validation :
UPDATE `#_comprofiler` SET `cb_field` = `cb_thisfield`
But when I edit a user to change the selection of the fields (for testing), the copy is done on other users but not on the one I edited / saved and closed (I purged the cache, refresh.. but nada with the one I edited )
CB Query Field is for SELECT queries. It is not for updating anything. If you want to update on various criteria you need CB Auto Actions and its Query action. CB Query Field simply displays the results of an SQL query, it can validate a field based off an SQL query, or build a dropdown list of options based off an SQL query. In no usecase should you be performing an update query from CB Query Field.
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.
You were advised below that you can query for or use PHP to parse out the last value of a multiselect or multicheckbox field using CB Query Field (SQL) or CB Code Field (PHP). What you're trying to do is not that. You are trying to COPY the entire value of 1 field to another in which case you were advised you would need CB Auto Actions to do (or possibly need both CB Auto Actions and CB Query/Code Field). This is all stated below in your topic.
Use the below query to do what you're wanting in a Query fieldtype to extract the last value of a multiselect or multicheckbox field. No this won't copy it and it won't be stored in the database. It'll be visible on their profile and that's it (it can not be searched either).
Code:
SELECT SUBSTRING_INDEX( `cb_thisfield`, '|*|', -1 ) FROM `#__comprofiler` WHERE `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.
krileon
