metatron-discovery icon indicating copy to clipboard operation
metatron-discovery copied to clipboard

Support multi-value filtering for group-by dimensions

Open navis opened this issue 3 years ago • 2 comments

navis avatar Jan 26 '22 02:01 navis

  @Test
  public void test3993() throws Exception
  {
    walker.getQueryConfig().getGroupBy().setGroupedUnfoldDimensions(true);
    walker.getQueryConfig().getGroupBy().setMultiValueDimensionFiltering(true);
    testQuery(
        "SELECT age_group, bks_event_d0, bks_event_d1, bks_event_d2, count(*) as cnt FROM cdis "
        + "WHERE svc_mgmt_num = '10000497' AND bks_event_d0 = 'APP' GROUP BY age_group, bks_event_d0, bks_event_d1, bks_event_d2",
        new Object[]{"10", "APP", "IT", "티월드다이렉트(tworlddirect.com)", 1L},
        new Object[]{"10", "APP", "생활", "도미노피자(Dominopizza)", 1L}
    );
    walker.getQueryConfig().getGroupBy().setMultiValueDimensionFiltering(false);
    testQuery(
        "SELECT age_group, bks_event_d0, bks_event_d1, bks_event_d2, count(*) as cnt FROM cdis "
        + "WHERE svc_mgmt_num = '10000497' AND bks_event_d0 = 'APP' GROUP BY age_group, bks_event_d0, bks_event_d1, bks_event_d2",
        new Object[]{"10", "APP", "IT", "티월드다이렉트(tworlddirect.com)", 1L},
        new Object[]{"10", "APP", "생활", "도미노피자(Dominopizza)", 1L},
        new Object[]{"10", "T114", "금융", "신용카드사", 1L},
        new Object[]{"10", "T114", "음식", "치킨", 1L}
    );
  }

navis avatar Jan 26 '22 03:01 navis

Only supported by IN and SELECTOR filter, currently

navis avatar Jan 26 '22 03:01 navis