Linkable fields

Hi Folks,

I have been struggling for a week now with linkable fields, even after reading forum. Are there other resources I should be reading?

Currently:
My form "RecentHandovers" displays correctly and the "on load" event calls a chronoconnection action "RecentHandoverDisplay" to generate the required data, which is a table of all handovers in the past month. Each entry of the table contains minimal data.

I made the date created field linkabke so that I could open a table of thaa single handover with ALL its data, but this is where I get stuck, what do I put in this "frontend listing" "Linkable Field(s)" box?

Currently I have:
cf_created:recenthandoverdisplay&single_view={cf_uid}

Where "single_view" is a task on my form "RecentHandovers" which has "Show HTML" and "Debugger" actions.

Thank-you in advance,
Andrew

Hi Andrew,

I don't understand this myself: Max gets it to work though.

Here's what he appears to have set up in the FAQs listing here.

The 'view' form is called KnowledgeBase and it has an 'event' called 'on view' with the actions to display the FAQ in it (mainly some PHP to get the data, format and display it).

In the CC listing the Front Editing tab has 'KnowledgeBase' as the FrontForm and 'view' as the Custom Data task. This matches up to the 'on view' event in the form above.

On the Frontend List settings | General tab there is a corresponding entry in the Linkable Fields box

Article.title:view&cb={Article.id}&alias={Article.alias}

Here I think the 'view' is linking back to the Custom Data Task; and the &cb={Article.id} is passing the article id back to the form.

I hope this helps a bit.

Bob

Thanks GreyHead,

I'd missed the bit about setting the "app" field, to make the view form selectable in the "Front Edit" tab.

But things still don't work😟

I get the following error when I click on my front end table:
There is no connection with this name or may be the connection is not published, Please check the available connections in the Connections Manager.

The link does not look correct:
<!-- w --><a class="postlink" href="http://www.xxxxx.com/index.php/component/chronoconnectivity/view/?Itemid=188&alias=">www.xxxxx.com/index.php/component/chron ... 188&alias=</a><!-- w -->

Now this is probably because I am using your code which uses the MODEL_ID format (somkething else I don't understand!)

If I change the CC "Front end listing->linkable field(s)" box to something I understand:
cf_created:view&cb={cf_id}

But I get the same error???

I can't see how the link sends the browser to the correct chronoconnectivity connection? I can see that the "view" will tell the connection to do the view and the connection knows which form to use, because we set it in the "Front Edit->Front form" box.

Still confused😟

Andrew

Hi Andrew,

The Model ID is a way of handling data from several table and keeping it separate. Essentially it puts the data into a sub-array. In this case the 'Article.' prefix is a convenient way of labeling the article data - it is set in the Model ID box on the General tab of the listing.

Please try turning off SEF URLs temporarily to see if your listing them works. The URL you posted has nothing in it to identify the record that you want to edit. (The ItemID is a menu identifier.) You probably don't need the alias value either - it's used to identify articles in the FAQ example.

Bob

Please try turning off SEF URLs temporarily to see if your listing them works.

Not so easy, this is a live site😟

The URL you posted has nothing in it to identify the record that you want to edit.

Yep that's what I don't understand. I thought the "&cb={cf_id}" bit would erturn the ID of the record I want to edit in "cb", but the link produced does not contain a field "cb"?

Using:
cf_created:view&cb={cf_id}

Gives:
./index.php/component/chronoconnectivity/view/1259?Itemid=188

Andrew

Also, using:
cf_created:view&my_id={cf_id}

Returns the link:
./index.php/component/chronoconnectivity/view?Itemid=188&my_id=1259

Andrew

I Switched off SEF and used the MODEL_ID format called "Handover".

CC Frontend List->Linkable Fields:
cf_created:view&cb={Handover.cf_id}&alias={Handover.cf_created}

This resulted in a link:
./index.php?option=com_chronoconnectivity&view=article&Itemid=188&task=view&cb=1277&alias=2013-04-08+18:02:10

Which when clicked gave a blank HTML page with just the text:
Connection name can NOT be empty!

:(

Hmm, plz try:

cf_created:view&cb={Handover.cf_id}&alias={Handover.cf_created}&view=connection

Or simply add the connection's name to that link!

Regards,
Max

Hi,

I tried the following with SEF on and OFF:

cf_created:view&cb={Handover.cf_id}&alias={Handover.cf_created}&view=recenthandoverdisplay

It returns the link:
http://www.freewheelers.org.uk/index.php/component/chronoconnectivity/view/1282?Itemid=188&alias=2013-04-12%2018:25:48

And still reports "no connection", I even removed the "&alias={Handover.cf_created}" part and it still failed. It's as if I am missing something very basic??


What difference does SEF make?

If it was a SEF problem what could I do to fix it?

Regards
Andrew

Hi Andrew,

No, you should either have "view=connection" (literally) or "chronoconnection=CONNECTION_NAME" (insert your connection's name)

Regards,
Max

OK, I tried:

cf_created:view&cb={Handover.cf_id}&alias={Handover.cf_created}&view=connection

Which gave a table with the correct field linkable, the link was:
./index.php/component/chronoconnectivity/view/1287?Itemid=188&alias=2013-04-15%2020:24:35

When i clicked it I got the reply:
"There is no connection with this name or may be the connection is not published, Please check the available connections in the Connections Manager."

I removed the "alias" field:

cf_created:view&cb={Handover.cf_id}&view=connection

and that gave a link of:
./index.php/component/chronoconnectivity/view/1287?Itemid=188

Which resulted in the same reply.

I turned SEF OFF and got the reply:
Connection name can NOT be empty!

Andrew

Hi Andrew,

Then please try my 2nd suggestion:

&chronoconnection=CONNECTION_NAME

And insert your own connection's name!

Regards,
Max

And insert your own connection's name!

:(

I tried this (and many other URLs typed into the address bar by hand):

cf_created:view&cb={Handover.cf_id}&chronoconnection=RecentHandoverDisplay

This gave a link of:
./index.php/component/chronoconnectivity/view/1287?Itemid=188

And the same error message "No connection name".

In both of your suggestions, there is no connection name in the generated URL??

Thank-you for your patience, this will turn out to be something very obvious that I have missed, I'm sure. If I could create a link manually I might be able to work out how to configure the linkable field correctly, but even this is proving difficult.

Best regards
Andrew

Hi Andrew,

Please try turning off the SEF URLs temporarily and see if that solves the problem. If so then you may need a work-around for the SEF Engine, I've used the Joomla! ReDirect component to do this before now but that may not work if you have many broken URLs.

Bob

Ok, turning off SEF with the code below gives a sensible looking URL, but when I click the link I get no data back, but I don't get the error either, so that's progress I guess? :-)

cf_created:view&cb={Handover.cf_id}&chronoconnection=RecentHandoverDisplay

./index.php?option=com_chronoconnectivity&view=article&Itemid=188&task=view&cb=1287&chronoconnection=RecentHandoverDisplay

So now I need to make this work with SEF on... I am only able to control the chrono... parts of the site and I am not allowed to turn SEF off permenantly :-(

Regards
Andrew

Hi Andrew,

Well, it will never work if the SEF process mutilates the URLs so badly that the critical info is missing. I don't know enough about this to say much more, Max has looked into Joomla! URLs more and may be able to help.

Bob

Hi,

Are you using the Joomla core SEF or some 3rd party one ? we use the Joomla SEF here, also the list is displayed under a page of type ChronoConnectivity (menu item)

You may also contact me through the contact us page to get the new version, which may help you somehow, it can work in parallel with the current one, so you can simply test and see!🙂

Regards,
Max