TOPIC:

Creating a view with data from multiple sources (tables) 4 months 3 weeks ago #254962

  • Topic Author
  • Maago
  • Offline
  • Senior Breezer
  • Senior Breezer
  • Posts: 158
  • Thanks: 0
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.

Please Log in or Create an account to join the conversation.

Creating a view with data from multiple sources (tables) 4 months 3 weeks ago #254963

  • tihana.krivic's Avatar
  • tihana.krivic
  • Offline
  • Moderator
  • Moderator
  • Posts: 6455
  • Karma: 3
  • Thanks: 456
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

Please Log in or Create an account to join the conversation.

Creating a view with data from multiple sources (tables) 4 months 2 weeks ago #255410

  • Topic Author
  • Maago
  • Offline
  • Senior Breezer
  • Senior Breezer
  • Posts: 158
  • Thanks: 0
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 ..

Please Log in or Create an account to join the conversation.

Creating a view with data from multiple sources (tables) 4 months 2 weeks ago #255412

  • tihana.krivic's Avatar
  • tihana.krivic
  • Offline
  • Moderator
  • Moderator
  • Posts: 6455
  • Karma: 3
  • Thanks: 456
Hi,

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

Regards,
Tihana

Please Log in or Create an account to join the conversation.

Creating a view with data from multiple sources (tables) 4 months 2 weeks ago #255415

  • Topic Author
  • Maago
  • Offline
  • Senior Breezer
  • Senior Breezer
  • Posts: 158
  • Thanks: 0
This is not a database, it is a view. And in a view I cannot add columns ...

Please Log in or Create an account to join the conversation.

Creating a view with data from multiple sources (tables) 4 months 2 weeks ago #255416

  • Topic Author
  • Maago
  • Offline
  • Senior Breezer
  • Senior Breezer
  • Posts: 158
  • Thanks: 0
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 ....

Please Log in or Create an account to join the conversation.

Moderators: ForumSupport
Time to create page: 0.052 seconds

BreezingForms Pro 1.4.7 for WordPress Released!

Available in the membership section.

September Discount!

Massive discounts on all subscriptions!

Get Your Subscription Here

Quick Links

Downloads

BreezingForms

ContentBuilder

BreezingCommerce

Templates

Documentation

BreezingForms

ContentBuilder

BreezingCommerce

Apprendre BreezingForms (French Community)

Apprendre et maîtriser BreezingForms par des tutoriels et exemples, le tout en français

breezingforms.eddy-vh.com

Questions et réponses sur les forums de l'AFUJ

AFUJ

Special Offer

Summer Sale! All subscriptions at a special price!

Includes prio support, all of our current and future Joomla!® extensions and Joomla!® templates for the duration of your membership.

Get it from here

3rd Party Discount - 25% Off

We help you to keep your costs under control. If you are a new member and purchased a form building tool from a different form vendor, then you'll get a 25% discount on our subscription plans.

How to receive the discount:

Send us a quick email to sales@crosstec.org with a proof of purchase (for example a paypal receipt), await payment instructions and enjoy your membership!