search

shannah / xataface

Framework for building data-driven web applications in PHP and MySQL
http://xataface.com
GNU General Public License v2.0
134 stars 57 forks source link

Get data from two tables on list view #108

Closed daniel2504 closed 5 years ago

daniel2504 commented 5 years ago

Hello together,

i got stucked on the point I want to get data from two tables in my default list view.

I have two tables:

  1. adbwebsite

messageaddress | date | time | message

From this table I get the fields "messageaddress", "date", "time", "message" and some more. Its the main table.

  1. addressrecords

Address | AddressDescription | Location

From this table I want to get the data from the field "AdressDescription" in the list view where Address matches messageaddress.

Address is for example 1234567 and messageaddress is 1234567 (The is always added by software on the Address-Field in the addressrecords table. On the match comparision it should be ignorated)

There are some messages from messageaddresses where no AddressDescription is available yet.

My target is to get the following output in the default list view:

date | time | messageaddress | AddressDescription | message

In cases where AddressDescription is not available for, the data from adbebsite should be shown and the field AddressDescription should be left empty.

I would thank you soo much, if somone could help me with this. I tried for hours but failed always.

BTW: Sorry for my english skills.

Regards, Dan

shannah commented 5 years ago

This was answered in the mailing list.