export excel query
Hello everyone, I have installed the Excel Export plugin by Dennis Koch. It works fine within resources, but when applied to a page created with the ManageRelatedRecords command, the export query is incorrect.
For example, I have the resource "editions" and the page "calendars", with the following relationships set:
2 Replies
public function calendars()
{
return $this->hasMany(Calendar::class);
}
public function edition()
{
return $this->belongsTo(Edition::class);
}
I am getting this error:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'editions.id' in 'where clause'
SELECT
*
FROM
calendars
WHERE
calendars.edition_id = 2
AND calendars.edition_id IS NOT NULL
AND editions.id IN (125, 126, 127)
ORDER BY
calendars.id ASC
limit
100 OFFSET 0
The issue seems to be related to the incorrect inclusion of the editions.id column in the query.
It's worth noting that 125, 126, and 127 are the calendar IDs and not the edition IDs.
Can someone help me please?Maybe ask directly in the plug-in channel. #pxlrbt-excel