My Page quarry is
SELECT
MAX("public"."Worklogs"."IssueKey") AS "IssueKey",
"public"."Worklogs"."AuthorDisplayName" AS "AuthorDisplayName",
DATE("Worklogs"."Created") AS "Created",
CAST(SEC_TO_TIME(CAST (SUM("TimeSpentSeconds")AS INTEGER )) AS interval) AS "TimeSpent",
MAX("public"."UsersGroup"."UserGroupId") AS "UserGroupId"
FROM "public"."Worklogs"
INNER JOIN "public"."UsersGroup" ON "public"."Worklogs"."AuthorDisplayName" = "public"."UsersGroup"."USER_NAME"
GROUP BY "public"."Worklogs"."AuthorDisplayName", DATE("Worklogs"."Created"), "public"."Worklogs"."IssueId"
ORDER BY DATE("Worklogs"."Created") DESC
I want to show only login user data. on the report page
adding After table initialize
$current_user_id = $_SESSION["DisplayName"];
$query->addWhere("'AuthorDisplayName'='" .$current_user_id."'");
or
$query->addWhere($strWhereClause, "'AuthorDisplayName'='" .$current_user_id."'");
not working.
how to solve?