It shows how to pull external data to display on profiles. It does not store this information. It simply displays it. The only way to store that information is to use something like a Query Select where that external information becomes a dropdown value or by using CB Auto Actions to push that fields value into the CB database.The page Documentationxxx describes how I can insert values from an external table into the Comprofiler table.
This is the complete opposite of what CB Query Field does. If you need to push data to an external database table you can easily do this using CB Auto Actions. Example as follows.Is there also an example of how I can write values in an external table and see them in the lists afterwards?
INSERT INTO `#__table` ( `user_id`, `content` ) VALUES( '[user_id]', '[FIELD_NAME]' )
Where did we give the impression CB is a CRM so we can further clarify what it is and is not. I apologize for the confusion.Which I unfortunately noticed too late and have invested many hours.
Please Log in to join the conversation.
xgerry wrote: ... are really packed in only one single table. "Database normalization"
So there is no way to connect a second table to the profile. ...
... this also explains why my previous concerns came to nothing. ...
Please Log in to join the conversation.
Please Log in to join the conversation.
xgerry wrote: Thank you for your help, it works as described.
Since it works, the question of whether the community builder is a CMS is even more difficult to answer.
After all, relations are possible.
Now I just have to sort correctly.
Sort by "counter" from the table "comprofiler_place_user"
How do I enter that? Do I need a new field?
Please Log in to join the conversation.
Please Log in to join the conversation.
xgerry wrote: Under "list management" - "Sorting" - "Advance" I would like to indicate that it derives the sorting from the "Zaehler" database field.
Only "ORDER BY Zaehler ASC" does not work.
Do I have to make the detour via a CB field?
as I said: I have to address a field from another table.
SELECT ue.*, u.*, '' AS 'NA'
FROM `#__users` u
INNER JOIN `#__comprofiler` AS ue
ON ue.`id` = u.`id`
WHERE u.`block` = 0
AND ue.`approved` = 1
AND ue.`confirmed` = 1
AND ue.`banned` = 0
AND ( SELECT COUNT(*)
FROM `#__user_usergroup_map` AS g
WHERE g.`user_id` = ue.`id`
AND g.`group_id` IN (2) ) > 0
ORDER BY (SELECT mycounts.`counter` FROM #__mycounts_table AS mycounts WHERE mycounts.id = u.id) DESC
LIMIT 0, 10
(SELECT mycounts.`counter` FROM #__mycounts_table AS mycounts WHERE mycounts.id = u.id) DESC
Please Log in to join the conversation.