Hi there,

Regarding the Dashboard -> datatable/grid. If I have a query including a join like:

$query->leftJoin("masterman", "settings.method_id","=","masterman.method_id")
                ->select("settings.id")
                ->select("masterman.description")
                ->select("settings.description")->alias("description_setting")

... and performing a search in the searchbox, then it qives me a SQL message (SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'description' in where clause is ambiguous). How is this possible while I am using an "alias" ?

With kind regards, Marloes

Text::create("description")->label("Whatever"). I've also tried naming both aliases. But is doesn't make any sense because while searching it probably is searching both columnnames in the same query despite it's alias.

And if I do this:

->select("settings.description")->alias("description_setting")

Text::create("description_setting")
                ->label("Ladidaaaa")
                ->searchable(true)
                ->sortable(true),

It shows me the right description in the table, but while searching on it it says "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'description_setting' in 'where clause'"