public String getAnyValueExistsClauseAnalyticsSql( String expression, AnalyticsType analyticsType ) { Set<String> uids = ProgramIndicator.getDataElementAndAttributeIdentifiers( expression, analyticsType ); if ( uids.isEmpty() ) { return null; } String sql = StringUtils.EMPTY; for ( String uid : uids ) { sql += statementBuilder.columnQuote( uid ) + " is not null or "; } return TextUtils.removeLastOr( sql ).trim(); }
for ( String uid : ProgramIndicator.getDataElementAndAttributeIdentifiers( expression, analyticsType ) ) for ( String uid : ProgramIndicator.getDataElementAndAttributeIdentifiers( expression, analyticsType ) )