I'm have attempted to write a multi-table select query. I get it to display in phpmyadmin, unfortunately I'm running into a problem when ari returns the data.


SELECT ief_rsticketspro_tickets.code, ief_rsticketspro_ticket_messages.Date, ief_rsticketspro_custom_fields_values.value, CONCAT('<a href="pond.turtlesoutheast.com/index.php/current-tickets/view-ticket/' ,ief_rsticketspro_tickets.id ,'-equipment-down' , '</a>') AS weblink
FROM ief_rsticketspro_custom_fields_values INNER JOIN (ief_rsticketspro_ticket_messages INNER JOIN ief_rsticketspro_tickets ON ief_rsticketspro_ticket_messages.ticket_id = ief_rsticketspro_tickets.id) ON ief_rsticketspro_custom_fields_values.ticket_id = ief_rsticketspro_tickets.id
WHERE (((ief_rsticketspro_custom_fields_values.custom_field_id)=1))

Hello,

What problem do you have? Is "Server side pagination" parameter is enabled?

Regards,
ARI Soft

I'm using concat to create a link once the table is displayed. But it doesn't return any data in the weblink column.

What value of "Server side pagination" parameter from module settings?

Regards,
ARI Soft

Sorry was trying to attach the output. It is set to yes.

The extension doesn't support complex queries (with sub-queries) when "Server side pagination" is enabled. If you need a server side pagination, a possible solution creates a view in a database and selects data from this view with a query without sub-queries.

Regards,
ARI Soft