Hi guys,

I successfully query the database, but want to accomplish the following.. the first column (company name) should be a link that displays a lightbox with the additional fields of that record.

basic table:

www.acp-ls.org/knowledge-center/vendor-directory

I am not seeing any examples how to accomplish this.
Also, it seems that the JQUERY UI is not loading properly, as no datatable styling is displayed, any ideas?

Thanks!

Hello,

jQuery UI themes are used by "ARI Data Tables" widget (set "Choose table type" parameter to "ARI Data Table" and "Choose table type -> ARI Data Table -> Using jQuery UI themes" parameter to "Yes").

It is not clear what links do you want to use for company names. Could you explain in more details how it can be generated?

Regards,
ARI Soft

Related to the JQ UI, had one value set wrong... thx that worked.

Related to the link question..
I have 5 columns displayed, however I have a total of 23 fields for this record. I want the first column (company name) to become a hyperlink, that can display a lightbox on top with the remaining field values for that record.

example: for none lightbox:datatables.net/release-datatables/examples/api/row_details.html

datatables.net/release-datatables/examples/plug-ins/html_sort.html

the html link could have a fancybox style and could render another query if required, preferably it would use the record data hidden in the datatable

ARI Sexy Lightbox can be used with "ARI Data Tables". It is possible to create a new instance of "ARI Data Tables" module which will show details about selected record, load this module into an article and then load this article into the lightbox. Send a record ID or other parameter which will be used by created module in "WHERE" clause of "SELECT" SQL query to retrieve data about selected record. For example if article with new instance of "ARI Data Tables" has ID equals to 19 and column which record ID is called "col_id", set "Columns settings -> ID" parameter to display_name value and "Columns settings -> Format" parameter to the following value:

<a href="index.php?option=com_content&view=article&id=19&tmpl=component&record_id={$columns:col_id}&TB_iframe=true&width=800&height=600" rel="sexylightbox">{$value}</a>

In created module instance can be used the next SQL query:


SELECT
*
FROM
tbl
WHERE
col_id = {$REQUEST:record_id}

Regards,
ARI Soft

Thanks will purchase the sexy lightbox too.. One more question about the article link.. I hope and assume that the lightbox is also supported in k2 items?

thanks

Yes, you can create a link to K2 item. We provided only a sample.

Regards,
ARI Soft