I am trying to use the below rawSQL query. Can you please assist me on how to pass the :UserId parameter. protected function dataSource()
{
return dbDashboard::rawSQL("
SELECT *
FROM SQLSERVER_Table
WHERE IDSec = :UserId
");
I have tried to pass the parameter on chart creation, but it doesn't seem to work LineChart::create()->params([ "UserId"=>$_SESSION["login_id"] ]),