garyjoomla wrote:
Hi,

Please excuse my limited knowledge. I just want to confirm that the example you kindly provided will work in Joomla 1.6. Also, that example will display an outcome? Providing I have entered the coding and such as you have described.Please disregard this question!

Thank you!

Hello again!

I have worked through the first half of the "Categories" (a couple of threads ago)coding with complete success. Again thank you for that! However, I cannot get the second half working, where it calls the complete "Article". Here is what I have that works:

In Column Settings "Format":

<a href="index.php?option=com_content&view=article&id=74&selCatId={$columns:id}">{$value}</a>

This works excellent!

Then in the SQL Query:



This also does what is needs to do. You guys set me up with this a couple of days ago!

However, I can't come up with the correct coding or whatever to make the actual "Article" (my actual form with the complete data set) appear. I have tried a number a variances from what you supplied, but it is just not working for me. Here is what I have:




I just can't make the connection on how to make it work. If you could help out, it would be greatly appreciated.

Thanks in advanced!!

Hello,

Sorry, but FacileForms data doesn't have a relationship with articles. In your case you can enter the values in "Columns Settings -> Columns Settings" parameter in the first module:

"ID" parameter -> id

"Format" parameter -> <a href="index.php?option=com_content&view=article&id=74&recordId={$columns:id}">{$value}</a>

For the second module use the next SQL query:



Regards,
ARI Soft

admin wrote:
Hello,

Sorry, but FacileForms data doesn't have a relationship with articles. In your case you can enter the values in "Columns Settings -> Columns Settings" parameter in the first module:

"ID" parameter -> id

"Format" parameter -> <a href="index.php?option=com_content&view=article&id=74&recordId={$columns:id}">{$value}</a>

For the second module use the next SQL query:

Code:

SELECT   * FROM   #__facileforms_subrecords WHERE   record = {$REQUEST:recordId|filter:int}

Regards,
ARI Soft
Good Day,

Ok thanks! So, my first module remains unchanged right? I leave my SQL query as is, along with the Format Parameter and the IDs. That works.

Now I have placed the code in the second Module. When I click on the Hyperlinked record being displayed by the first module, it links to the second module where it is embedded in that page. However, there is no information displayed via the second module on that page.

I tried work many scenarios with your code, but to no avail, my knowledge it limited in this regard. I think at this point, I would be interested in taking this off line with your organization and pay for your services to complete what I need.

Please let me know if this is an option.

Thank You

If you provide temporary access to your Joomla! backend by email, we will be glad to configure the extension.

Regards,
ARI Soft

Hello,

Thanks for your help yesterday.

Everything is working well with one exception. The Module to display the complete table (ARI Article Module) always displays "No data available." This occurs until an actual record is selected from the ARI Category Module. Once the record is selected and the link opens the data the "No data available." goes away.

Also, the ARI Article Module must be displayed on all pages in Menu Assignment -> Module Assignment. If any other selection is made the data will not display. Can you point me in the right direction to resolve?


Thanks