[SOLVED] Corona - Club App

The page Documentationxxx describes how I can insert values from an external table into the Comprofiler table.

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.

Is there also an example of how I can write values in an external table and see them in the lists afterwards?

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.

Global
Triggers: onAfterUserRegistration, onAfterNewUser, onAfterUserUpdate, onAfterUpdateUser
Type : Query
User: Automatic
Access: Everybody
Action
Query: Mode: External (configure the subsequent fields for connecting to your external database)

As for the triggers they're explained as follows.

onAfterUserRegistration = frontend registration
onAfterNewUser = backend registration
onAfterUserUpdate = frontend profile edit
onAfterUpdateUser = backend profile edit

If the database isn't an external database then leave Mode as Internal. You can use a Code action if you prefer to do this with custom PHP. If you don't need it acting on all those triggers remove whichever aren't relevant to your usecase. The above query would insert every time so it maybe best to ensure `user_id` is a unique index then use ON DUPLICATE KEY UPDATE behavior so it inserts or it updates.

Which I unfortunately noticed too late and have invested many hours.

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.

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

Your previous concerns led to nothing, because nobody understands what you want.
It seems like you are missing some basics, also with regard to databases. It makes me sad to see you wasting developers' time on immature questions.

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?

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.

Maybe the right answer is: Joomla is a CMS, but CB is not a CMS nor a CRM, but with CB Auto-Actions and other add-ons, and a bit of coding knowledge it has an enormous flexibility to do what you want (and that no CRM nor CMS will do by itself)

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?

Trying to answer with the very little information provided by the question:

As you are managing that table you would just need to add something like an " ORDER BY counter DESC" (or ASC) to your MySQL query to get the list into e.g. a CB Field, wherever it is.

We are here to help you, but we need your precise help to help you precisely and efficiently. Please read our " Help us help you " page, and provide us with details and context in your next questions. Obviously, we have no idea where your installation is and have no access to it nor can guess your settings nor what you wish to achieve. And don't want to have access. So please provide settings, screen-dumps, drawings, whatever needed to fully undestand context, with a precise question to get a precise reply.

The difficult art is to provide as little information as possible, but as much as needed.

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.

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.

Trying to guess: IF this is what you want to say: "There is a 'counter' field in a related table 'myCounts' where the 'id' column is the user id", then I guess again you want to have a Users-list SQL query that sorts with something like:


Then put in the Advanced Sorting of CB List Management something like:


If it's a different sorting and table, just adapt the SQL sub-statement of the ORDER BY advanced field.


In case: To debug your query and see page SQL queries, in Joomla Global Configuration, System Tab, activate Site Debug, then go to your users-list front-page and you will see Database Queries at bottom, when clicking on that accordion title.