TEMA:

Hello,

I have a question about displaying data in views. I want to provide a view to show at one place a userlist with their roles and access rights.
As these informations are distributed to different tabels I'm wondering if I can create one single view to display these kind of information with CB?

Thanks.

Hi,

ContentBuilder by default supports one table, only.

If you need to combine 2 tables, you can:
create a view within your database that merges the 2 tables and then use that view as datastorage in CB->Data Storages (In phpmyadmin you can make a query for join 2 tables and put result in a third one ( this third table use as view in CB -> Data Storages))

Example for join:
stackoverflow.com/questions/12352048/mys...w-joining-two-tables

Hope this helps

Regards,
Tihana

Thank you. Now I created a view which lists all my user entries and related assigned groups. I choosed this view as source in CB view.

But trying to open this CB view I get error

1054 Unknown column 'r.created_by' in 'field list'

Yes thats correct. The view do not have such field ..

Hi,

please check this database and see if there is 'r.created_by' coulmn

Regards,
Tihana

This is not a database, it is a view. And in a view I cannot add columns ...

also creating the CB database referring to a view gives me the following error:

1347 'joom_test.anm_userlist' is not of type 'BASE TABLE'

However the CB database is created ....