Table Join link options

[crowden]

Hi,

When you choose the 'Yes' radio button to join a table and enter "View" or whatever you want it to say...that is what shows up as the link to the joined table.

Look at:

http://fwc.tolsdevelopment.com/index.php?option=com_content&task=view&id=20&Itemid=28

Under the Services Offered header on the right, there is a table that lists Service Types. Is it possible to have those link as they are, without having to add the "View Projects" text?

So, Design/Build would be the hyperlink, not "View Projects".

Thanks!

 

[cheesegrits]

Offhand I can't think of any built-in way of doing it. Although as that looks like a custom template, you might be able to construct your own link.

Can you post the template.php for that template?

-- hugh

 

[crowden]

Ok,

This page:
http://fwc.tolsdevelopment.com/index.php?option=com_content&task=view&id=55&Itemid=81

Uses the projects template.

The area under Services Offered on this page:
http://fwc.tolsdevelopment.com/index.php?option=com_content&task=view&id=20&Itemid=28

Uses the services template.

I've put them in a zip file and added the name as a prefix to the template.php files.

 

[cheesegrits]

OK, I think you could do this with a bit more template tweaking.

We add the 'view' link (for the "tables with joins to this table"), it has a $label something like x-y-z_table_heading, where x, y and z are the table, form and element ID's of the joining table.

What you could do is, instead of showing your actual link label (whatever that is in the table, like the "General Construction"), grab the $row->$heading content for that element, and replace the $row->$heading for the View link with it.

So in "pseudo code" it would look like this, if your existing title element is called title_element ...

if ($label = 'title_element') {
$row->x-y-z_table_heading = $row->$heading;
}
else {
... print it ...
}

Of course, the trick is finding out what the x-y-z values need to be for the table_heading. You'll can either var_dump($row) in there one time to find that out, or work it out from your joining form/table/element details.

-- hugh