Examples with NE org.hisp.dhis.common.QueryOperator.NE used on opensource projects

Example 1 with NE

use of org.hisp.dhis.common.QueryOperator.NE in project dhis2-core by dhis2.

the class EventsAnalyticsManagerTest method verifyGetEventsWithMissingValueNeFilter.

@Test
void verifyGetEventsWithMissingValueNeFilter() {
    String expected = "ax.\"fWIAEtYVEGk\" is not null";
    testIt(NE, NV, Collections.singleton((capturedSql) -> assertThat(capturedSql, containsString(expected))));
}

Example 2 with NE

use of org.hisp.dhis.common.QueryOperator.NE in project dhis2-core by dhis2.

the class EnrollmentAnalyticsManagerTest method verifyGetEnrollmentsWithMissingValueNeFilter.

@Test
void verifyGetEnrollmentsWithMissingValueNeFilter() {
    String subSelect = "(select \"fWIAEtYVEGk\" from analytics_event_" + programA.getUid() + " where analytics_event_" + programA.getUid() + ".pi = ax.pi and \"fWIAEtYVEGk\" is not null and ps = '" + programStage.getUid() + "' order by executiondate desc limit 1 )";
    String expected = subSelect + " is not null";
    testIt(NE, NV, Collections.singleton((capturedSql) -> assertThat(capturedSql, containsString(expected))));
}