Data form different tables in 1 portal

[QCOL]

Hey,

 

I have the following tables:

sidebar_items
-------------
id
listable_id
listable_type

pages_pages
-----------
id

events_events
--------------
id

Now in my sidebar_items portal I want to display data from both the pages_pages table and events_events based on the listable_type.

So if listable_type is page I want it to grab data from the page_pages table and if listable_type is events it needs to display data from events_events.

 

hope anyone can help me!

[comment]

So if listable_type is page I want it to grab data from the page_pages table and if listable_type is events it needs to grab data from events_events.

 

Not sure what you mean by "grab data". If you mean display records from two separate tables in the same portal, that's not possible.

 

 

Perhaps you should explain in more detail what this is about, so a more suitable approach can be suggested.