Description of problem: Error message while trying to display this timeline: Error building timeline PG::UndefinedTable: ERROR: missing FROM-clause entry for table "miq_sets" LINE 1: ...s"."ems_id" AS t0_r15 FROM "policy_events" WHERE ("miq_sets"... ^ : SELECT "policy_events"."id" AS t0_r0, "policy_events"."miq_event_definition_id" AS t0_r1, "policy_events"."event_type" AS t0_r2, "policy_events"."miq_event_definition_description" AS t0_r3, "policy_events"."miq_policy_id" AS t0_r4, "policy_events"."miq_policy_description" AS t0_r5, "policy_events"."result" AS t0_r6, "policy_events"."timestamp" AS t0_r7, "policy_events"."target_id" AS t0_r8, "policy_events"."target_class" AS t0_r9, "policy_events"."target_name" AS t0_r10, "policy_events"."chain_id" AS t0_r11, "policy_events"."username" AS t0_r12, "policy_events"."host_id" AS t0_r13, "policy_events"."ems_cluster_id" AS t0_r14, "policy_events"."ems_id" AS t0_r15 FROM "policy_events" WHERE ("miq_sets"."created_on" BETWEEN '2018-03-19 00:00:00' AND '2018-03-25 23:59:59.999999') Version-Release number of selected component (if applicable): Version 5.9.1.0.20180314203929_67fd99d How reproducible: Always Steps to Reproduce: 1. setup a vm and a policy 2. generate a policy event and make sure it is appearing on the vm timeline. 3. copy the report (cloud intel/reports/reports) policy event for the last 7 days and change the filter to This Week Actual results: Error message mentioned before Expected results: see the timeline and the events Additional info: Worked in the previous versions
https://github.com/ManageIQ/manageiq/pull/17191
New commit detected on ManageIQ/manageiq/master: https://github.com/ManageIQ/manageiq/commit/8b167fd420f6d7e2ef1d4a3d52e4b9bf92ee4127 commit 8b167fd420f6d7e2ef1d4a3d52e4b9bf92ee4127 Author: Harpreet Kataria <hkataria> AuthorDate: Fri Mar 23 11:05:51 2018 -0400 Commit: Harpreet Kataria <hkataria> CommitDate: Fri Mar 23 11:05:51 2018 -0400 Fixed case of expression in OOTB report. This was causing an issue when copying this report and trying to change an expression of new report. Fixes https://bugzilla.redhat.com/show_bug.cgi?id=1558087 product/reports/520_Events - Policy/120_Policy Events2.yaml | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-)
Verified in 5.10.0.2