Displaying Portals with multiple table data

[Michael Maher]

I understand that to display a portal, I use the CDML inline approach of querying the portal table directly. But in my portal, I have fields from tables two or more deep, as we can now do in v7.

Is there a way to get these values via some '::' style coding, or do I have to create a calculation field in the table of the portal, as we used to do pre7.

If that is the way, it is a bit of a nuisance, as using the Data Separation Model, my main table relationships are in the logic file - I would need to duplicate them in the data file to store values in calculation fields.

(I am seriously questioning the value of the Data Separation Model)

Michael

[Martin Brändle]

I think PHP and XSLT use the same XML result tree, don't they? Then it is possible.

[Garry Claridge]

Here is how a Portal is presented using the fmresultset grammar:

   

      

         Home

      

      

         1/1/2001

      

   

   

      

         Restoration

      

      

         12/15/2001

      

   

This is an example from the "fmsa7_custom_web_guide.pdf"

If you are using the FX class you can display the whole result of a query with:

echo print_r($myresult)

This may show you where and how the Portal data is presented.

All the best.

Garry