X-Git-Url: https://gerrit.onap.org/r/gitweb?a=blobdiff_plain;f=auth%2Fauth-batch%2Fsrc%2Fmain%2Fjava%2Forg%2Fonap%2Faaf%2Fauth%2Fbatch%2Fhelpers%2FCreator.java;h=a4e4112ff28f174b820f30026fd1d622d027283f;hb=3d1706fcbe7f95830ff6fd23cf679ee55c6d0595;hp=152c6331fa723f255b0ec133b26e97c2c9131332;hpb=343481da5dac494c0b063f0b5b0ddb865fa1f214;p=aaf%2Fauthz.git

diff --git a/auth/auth-batch/src/main/java/org/onap/aaf/auth/batch/helpers/Creator.java b/auth/auth-batch/src/main/java/org/onap/aaf/auth/batch/helpers/Creator.java
index 152c6331..a4e4112f 100644
--- a/auth/auth-batch/src/main/java/org/onap/aaf/auth/batch/helpers/Creator.java
+++ b/auth/auth-batch/src/main/java/org/onap/aaf/auth/batch/helpers/Creator.java
@@ -27,11 +27,23 @@ public abstract class Creator<T> {
     public abstract T create(Row row);
     public abstract String select();
     
+    public String suffix() {
+        return "";
+    }
+    
     public String query(String where) {
         StringBuilder sb = new StringBuilder(select());
         if (where!=null) {
             sb.append(" WHERE ");
-            sb.append(where);
+            int index = where.indexOf(" ALLOW FILTERING");
+            if(index< 0 ) {
+                sb.append(where);
+                sb.append(suffix());
+            } else {
+                sb.append(where.substring(0, index));
+                sb.append(suffix());
+                sb.append(" ALLOW FILTERING");
+            }
         }
         sb.append(';');
         return sb.toString();