Examples of WhereField

Examples of it.eng.qbe.query.WhereField

266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
  private void updatePromptableFiltersValue(Query query) {
    logger.debug("IN");
    List whereFields = query.getWhereFields();
    Iterator whereFieldsIt = whereFields.iterator();
    while (whereFieldsIt.hasNext()) {
      WhereField whereField = (WhereField) whereFieldsIt.next();
      if (whereField.isPromptable()) {
        // getting filter value on request
        String promptValue = this.getAttributeAsString(whereField.getName());
        logger.debug("Read prompt value [" + promptValue + "] for promptable filter [" + whereField.getName() + "].");
        if (promptValue != null) {
          whereField.getRightOperand().lastValues = new String[] {promptValue}; // TODO how to manage multi-values prompts?;
        }
      }
    }
    List havingFields = query.getHavingFields();
    Iterator havingFieldsIt = havingFields.iterator();
View Full Code Here

Examples of it.eng.qbe.query.WhereField

119
120
121
122
123
124
125
126
127
128
        String operator = "NOT EQUALS TO";
        if(valuesArray.length()>0){
          operator="IN";
        }

        whereFields.add(new WhereField("OptionalFilter"+i, "OptionalFilter"+i, false, leftOperand, operator, rightOperand, "AND"));
      }
    }
    return whereFields;
  }
View Full Code Here

Examples of it.eng.qbe.query.WhereField

186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
  public static void updatePromptableFiltersValue(Query query, AbstractQbeEngineAction action) {
    logger.debug("IN");
    List whereFields = query.getWhereFields();
    Iterator whereFieldsIt = whereFields.iterator();
    while (whereFieldsIt.hasNext()) {
      WhereField whereField = (WhereField) whereFieldsIt.next();
      if (whereField.isPromptable()) {
        // getting filter value on request
        List promptValuesList = action.getAttributeAsList(whereField.getName());
        if (promptValuesList != null) {
          String[] promptValues = (String[]) promptValuesList.toArray(new String[] {});
          logger.debug("Read prompts " + promptValues + " for promptable filter " + whereField.getName() + ".");
          whereField.getRightOperand().lastValues = promptValues;
        }
      }
    }
    List havingFields = query.getHavingFields();
    Iterator havingFieldsIt = havingFields.iterator();
View Full Code Here

Examples of it.eng.qbe.query.WhereField

271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
  private void updatePromptableFiltersValue(Query query) {
    logger.debug("IN");
    List whereFields = query.getWhereFields();
    Iterator whereFieldsIt = whereFields.iterator();
    while (whereFieldsIt.hasNext()) {
      WhereField whereField = (WhereField) whereFieldsIt.next();
      if (whereField.isPromptable()) {
        // getting filter value on request
        String promptValue = this.getAttributeAsString(whereField.getName());
        logger.debug("Read prompt value [" + promptValue + "] for promptable filter [" + whereField.getName() + "].");
        if (promptValue != null) {
          whereField.getRightOperand().lastValues = new String[] {promptValue}; // TODO how to manage multi-values prompts?;
        }
      }
    }
    List havingFields = query.getHavingFields();
    Iterator havingFieldsIt = havingFields.iterator();
View Full Code Here

Examples of it.eng.qbe.query.WhereField

344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
   */
  private JSONArray serializeFilters(Query query, IDataSource dataSource, Locale locale) throws SerializationException {
    JSONArray filtersJOSN = new JSONArray();
   
    List filters;
    WhereField filter;
    WhereField.Operand operand;
    JSONObject filterJSON;
    IModelField datamartFilter;
    String fieldUniqueName;
    Iterator it;
    IModelProperties datamartLabels;
    IModelField datamartField;
   
    filters = query.getWhereFields();
    Assert.assertNotNull(filters, "Filters cannot be null");
   
    datamartLabels = null;
    if(locale != null) {
      //datamartLabels =  QbeCacheManager.getInstance().getLabels( dataSource , locale );
      datamartLabels = dataSource.getModelI18NProperties(locale);
    }
   
    it = filters.iterator();
    while( it.hasNext() ) {
      filter = (WhereField)it.next();
     
      filterJSON = new JSONObject();
      try {
        filterJSON.put(QuerySerializationConstants.FILTER_ID, filter.getName());
        filterJSON.put(QuerySerializationConstants.FILTER_DESCRIPTION, filter.getDescription());
        filterJSON.put(QuerySerializationConstants.FILTER_PROMPTABLE, filter.isPromptable());
       
        operand = filter.getLeftOperand();
        filterJSON.put(QuerySerializationConstants.FILTER_LO_VALUE, operand.values[0]);
        if(operand.type.equalsIgnoreCase("Field Content")) {
          if(operand.values[0].contains("\"expression\":\"")){
            filterJSON.put(QuerySerializationConstants.FILTER_LO_DESCRIPTION, operand.description );
            String description = operand.values[0].substring(operand.values[0].indexOf("\"expression\":\"")+14);
            description.substring(0, description.indexOf("\""));
            filterJSON.put(QuerySerializationConstants.FILTER_LO_LONG_DESCRIPTION, description);           
          }else{
            datamartField = dataSource.getModelStructure().getField( operand.values[0] );
           
            String labelF, labelE;
            labelE = null;
            if(datamartLabels != null) {
              labelE = datamartLabels.getProperty(datamartField.getParent(), "label");
            }
            labelE = StringUtilities.isEmpty(labelE)? datamartField.getParent().getName(): labelE;
           
           
            labelF = null;
            if(datamartLabels != null) {
              labelF = datamartLabels.getProperty(datamartField, "label");
            }
            labelF = StringUtilities.isEmpty(labelF)? datamartField.getName(): labelF;
           
            filterJSON.put(QuerySerializationConstants.FILTER_LO_DESCRIPTION, labelE  + " : " + labelF );
           
            String loLongDescription = getFieldLongDescription(datamartField, datamartLabels);
            filterJSON.put(QuerySerializationConstants.FILTER_LO_LONG_DESCRIPTION, loLongDescription);
          }
        } else if(operand.type.equalsIgnoreCase("Subquery")) {
          String loLongDescription = "Subquery " + operand.description;
          filterJSON.put(QuerySerializationConstants.FILTER_LO_LONG_DESCRIPTION, loLongDescription);
         
          filterJSON.put(QuerySerializationConstants.FILTER_LO_DESCRIPTION, operand.description);
        } else if(operand.type.equalsIgnoreCase("Parent Field Content")) {
          String[] chunks = operand.values[0].split(" ");
          String parentQueryId = chunks[0];
          String fieldName = chunks[1];
          datamartField = dataSource.getModelStructure().getField( fieldName );
          String datamartFieldLongDescription = getFieldLongDescription(datamartField, datamartLabels);
          String loLongDescription = "Query " + parentQueryId + ", " + datamartFieldLongDescription;
          filterJSON.put(QuerySerializationConstants.FILTER_LO_LONG_DESCRIPTION, loLongDescription);
         
          filterJSON.put(QuerySerializationConstants.FILTER_LO_DESCRIPTION, operand.description);
        } else {
          filterJSON.put(QuerySerializationConstants.FILTER_LO_DESCRIPTION, operand.description);
        }
       
       
       
        filterJSON.put(QuerySerializationConstants.FILTER_LO_TYPE, operand.type);
        filterJSON.put(QuerySerializationConstants.FILTER_LO_DEFAULT_VALUE, operand.defaulttValues[0]);
        filterJSON.put(QuerySerializationConstants.FILTER_LO_LAST_VALUE, operand.lastValues[0]);
       
        filterJSON.put(QuerySerializationConstants.FILTER_OPERATOR, filter.getOperator());
       
        operand = filter.getRightOperand();
        filterJSON.put(QuerySerializationConstants.FILTER_RO_VALUE, JSONUtils.asJSONArray(operand.values));
        if(operand.type.equalsIgnoreCase("Field Content")) {
          datamartField = dataSource.getModelStructure().getField( operand.values[0] );
         
          String labelF, labelE;
          labelE = null;
          if(datamartLabels != null) {
            labelE = datamartLabels.getProperty(datamartField.getParent(), "label");
          }
          labelE = StringUtilities.isEmpty(labelE)? datamartField.getParent().getName(): labelE;
         
         
          labelF = null;
          if(datamartLabels != null) {
            labelF = datamartLabels.getProperty(datamartField, "label");
          }
          labelF = StringUtilities.isEmpty(labelF)? datamartField.getName(): labelF;
         
          filterJSON.put(QuerySerializationConstants.FILTER_RO_DESCRIPTION, labelE  + " : " + labelF );
         
          String roLongDescription = getFieldLongDescription(datamartField, datamartLabels);
          filterJSON.put(QuerySerializationConstants.FILTER_RO_LONG_DESCRIPTION, roLongDescription);
        } else if(operand.type.equalsIgnoreCase("Subquery")) {
          String roLongDescription = "Subquery " + operand.description;
          filterJSON.put(QuerySerializationConstants.FILTER_RO_LONG_DESCRIPTION, roLongDescription);
         
          filterJSON.put(QuerySerializationConstants.FILTER_RO_DESCRIPTION, operand.description);
        } else if(operand.type.equalsIgnoreCase("Parent Field Content")) {
          String[] chunks = operand.values[0].split(" ");
          String parentQueryId = chunks[0];
          String fieldName = chunks[1];
          datamartField = dataSource.getModelStructure().getField( fieldName );
          String datamartFieldLongDescription = getFieldLongDescription(datamartField, datamartLabels);
          String loLongDescription = "Query " + parentQueryId + ", " + datamartFieldLongDescription;
          filterJSON.put(QuerySerializationConstants.FILTER_RO_LONG_DESCRIPTION, loLongDescription);
         
          filterJSON.put(QuerySerializationConstants.FILTER_RO_DESCRIPTION, operand.description);
        } else {
          filterJSON.put(QuerySerializationConstants.FILTER_RO_DESCRIPTION, operand.description);
        }
        filterJSON.put(QuerySerializationConstants.FILTER_RO_TYPE, operand.type);
        filterJSON.put(QuerySerializationConstants.FILTER_RO_DEFAULT_VALUE, JSONUtils.asJSONArray(operand.defaulttValues));
        filterJSON.put(QuerySerializationConstants.FILTER_RO_LAST_VALUE, JSONUtils.asJSONArray(operand.lastValues));
       
        filterJSON.put(QuerySerializationConstants.FILTER_BOOLEAN_CONNETOR, filter.getBooleanConnector());
       
      } catch(JSONException e) {
        throw new SerializationException("An error occurred while serializing filter: " + filter.getName(), e);
      }
      filtersJOSN.put(filterJSON);
    }
   
    return filtersJOSN;
View Full Code Here

Examples of it.eng.qbe.query.WhereField

889
890
891
892
893
894
895
896
897
898
899
        }
        str += (i==0?"": " " + filterExp.getValue());
        str += " " + childStr;
      }
    } else {
      WhereField whereField = query.getWhereFieldByName( filterExp.getValue() );
      str += buildUserProvidedWhereField(whereField, query, entityAliasesMaps);
    }
   
    return str;
  }
View Full Code Here

Examples of it.eng.qbe.query.WhereField

183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
  public void updateParameters(Query query, Map parameters) {
    logger.debug("IN");
    List whereFields = query.getWhereFields();
    Iterator whereFieldsIt = whereFields.iterator();
    while (whereFieldsIt.hasNext()) {
      WhereField whereField = (WhereField) whereFieldsIt.next();
      if (whereField.isPromptable()) {
        String key = getParameterKey(whereField.getRightOperand().values[0]);
        if (key != null) {
          String parameterValues = (String) parameters.get(key);
          if (parameterValues != null) {
            String[] promptValues = new String[] {parameterValues}; // TODO how to manage multi-values prompts?
            logger.debug("Read prompts " + promptValues + " for promptable filter " + whereField.getName() + ".");
            whereField.getRightOperand().lastValues = promptValues;
          }
        }
      }
    }
    List havingFields = query.getHavingFields();
View Full Code Here

Examples of it.eng.qbe.query.WhereField

220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
  public void updateParameters(it.eng.qbe.query.Query query, Map parameters) {
    logger.debug("IN");
    List whereFields = query.getWhereFields();
    Iterator whereFieldsIt = whereFields.iterator();
    while (whereFieldsIt.hasNext()) {
      WhereField whereField = (WhereField) whereFieldsIt.next();
      if (whereField.isPromptable()) {
        String key = getParameterKey(whereField.getRightOperand().values[0]);
        if (key != null) {
          String parameterValues = (String) parameters.get(key);
          if (parameterValues != null) {
            String[] promptValues = new String[] {parameterValues}; // TODO how to manage multi-values prompts?
            logger.debug("Read prompts " + promptValues + " for promptable filter " + whereField.getName() + ".");
            whereField.getRightOperand().lastValues = promptValues;
          }
        }
      }
    }
    List havingFields = query.getHavingFields();
View Full Code Here

Examples of it.eng.qbe.query.WhereField

79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
   
    //Get the where fields
    List<WhereField> whereFields = query.getWhereFields();
    if(whereFields!=null){
      for(int i=0; i<whereFields.size(); i++){
        WhereField whereField = whereFields.get(i);
        Operand leftOperand = whereField.getLeftOperand();
        if(statement.OPERAND_TYPE_FIELD.equalsIgnoreCase(leftOperand.type)){
          datamartField = statement.getDataSource().getModelStructure().getField( leftOperand.values[0] );
          concernedEntities.add(datamartField.getPathParent());
        }
        Operand rightOperand = whereField.getLeftOperand();
        if(statement.OPERAND_TYPE_FIELD.equalsIgnoreCase(rightOperand.type)){
          datamartField = statement.getDataSource().getModelStructure().getField( rightOperand.values[0] );
          concernedEntities.add(datamartField.getPathParent());
        }
      }
View Full Code Here

Examples of it.eng.qbe.query.WhereField

838
839
840
841
842
843
844
845
846
847
848
        }
        str += (i==0?"": " " + filterExp.getValue());
        str += " " + childStr;
      }
    } else {
      WhereField whereField = query.getWhereFieldByName( filterExp.getValue() );
      str += buildUserProvidedWhereField(whereField, query, entityAliasesMaps);
    }
   
    return str;
  }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.