Xataface Forums

Hiya,

In my SiteData.php I have the following:

Code: Select all

function titleColumn(){
    return "concat(SiteData.SiteName , '[',SiteData.MPAN1,']')";
}


If "MPAN1" was held in another table (perhaps "MPANSTUFF" for example instead of SiteData) would the above concat still be possible (even though both items I want to display are in separate tables)?

Thanks

Paul

Yes. 2 parts. First graft the field you want onto the table using the __sql__ directive of the fields.ini file. Then you'll be able to reference it from the titleColumn() method like any other column of the table.

Uber quick

Many Thanks. I'd thought as much so that hopefully means that I'm finally getting to grips with Xtaface... Love it!