6 posts by 2 authors in: Forums > CMS Builder
Last Post: November 13, 2014   (RSS)

I have a section in CMS where Im pulling data from another table: Related Records

How can I get that data to be shown in the CMS ListPage?

Hi there

Getting related record info is a little tricky. There is no really simple way, but the one I will recommend is using two getRecords queries - one to get the initial record, and another to get the records in the second table using the key from the initial record.

It's difficult to give an example of this without knowing more about the tables in question, but does that make sense at least?

--------------------

Claire Ryan
interactivetools.com

Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

This would be in the head of the listPage, below the first getRecords call and inside the php tags.

--------------------

Claire Ryan
interactivetools.com

Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

hmm i dont think we are on same page here...

Do I need to edit the schema page for that table?

see attached..

Okay, now I see - I thought you were referring to a front end viewer file.

This isn't possible using the standard CMS. There's no functionality for Related Record information to be showed on the list pages. Every time it's required, it has to be added using a custom plugin. There's no easy way of doing it.

You can email consulting@interactivetools.com if you'd like to get a quote for us to create such a plugin. Very sorry I don't have any better options for you.

--------------------

Claire Ryan
interactivetools.com

Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/