ChronoConnectivity vs. jomsocial

Question

Hey there

I have a problem with ChronoConnectivity - and no idea how to solve it.
I would like to present the id, name and city of each user saved in the usr_community_fields_values table.

Usually, I would define the column names (something like: model.column:TITLE).
That doesn't work here because the informations are arranged in rows - not in columns!

So, if I would like to present all cities, I have to use the following statement:
select value from usr_community_fields_values where field_id = 41;

and if I would like to present all names, I have to use the following statement:
select value from usr_community_fields_values where field_id = 20;

because every field_id "represents" a column.

Well, what do I have to do now to create a table which presents all ids (field_id = 52), names (field_id = 20) and cities (field_id = 41)??

[attachment=0]screen.jpg[/attachment]

Help!! 😢

GreyHead · Accepted Answer

Hi nebelparder,

I'm sorry I don't know if this is possible in CC using the usual data models.

I have done something similar before but using a custom layout in CC and adding a database query in each row to get the infor for that row. Not idea ideal but it will work.

It might also be possible to set up a MySQL view with the data you need and point ChronoConnrctivity to that - I did that once before IIRC it required a small hack to the code to give access to a View.

Bob

Forums

ChronoConnectivity vs. jomsocial