Get query ranges (for user info on report)

Hi,

I am trying to create an util class to be used on our reports so the user can see the query ranges on the report header. The code below works for a query for only shows the ranges that are already on the query. If the user adds ranges to the querie I can not get these values. Any ideas?

Thanks

static void getQueryRanges(Args _args)
{
  Query                   query;
  QueryRun                queryRun;
  QueryBuildDataSource    qbd; 
  QueryBuildRange         range;
  int                     cnt, i,j;
  DictTable dictTable;
  DictField dictField;
  str fieldLabel;
  ;
 
  query = new query(queryStr(smmSalesCustItemStatistics));
  queryRun = new QueryRun(query);

  queryRun.prompt();
  query = queryRun.query();

 
  for(i = 1; i <= query.dataSourceCount(); i++) 
  { 
    cnt = query.dataSourceNo(i).rangeCount();     
    dictTable = new DictTable(query.dataSourceNo(i).table());  

    for (j=1 ; j<=cnt; j++)
    {                 
         range = queryRun.query().dataSourceNo(i).range(j);
         dictField = new DictField(query.dataSourceNo(i).table(), fieldname2id( query.dataSourceNo(i).table(), range.AOTname()));
         if (range.value())
         {
            info(strfmt("%1, %2. Range = %3",dictTable.label(), dictField.label(), range.value()));
         }
    }
  }
}

Reply

• POSTED BY DANIEL ESSER  ON 5 OCT 2012 12:20 PM  VERIFIED ANSWER VERIFIED BY PEDRO RODRIGUEZ

  I think user input are defined as filters in the query.

  try this:

  static void getQueryRanges2(Args _args)
  {
   Query query;
   QueryRun queryRun;
   QueryBuildDataSource qbd;
   QueryBuildRange range;
   QueryFilter filter; int cnt, filtercnt, i,j, k;
   DictTable dictTable;
   DictField dictField; str fieldLabel;
   ;
   query = new query(queryStr(smmSalesCustItemStatistics));
   queryRun = new QueryRun(query);
   queryRun.prompt();
   query = queryRun.query();  for(i = 1; i <= query.dataSourceCount(); i++)
   {
      cnt = query.dataSourceNo(i).rangeCount();
      filtercnt = 0;    if(!query.dataSourceNo(i).embedded())
      {
          filtercnt = query.queryFilterCount(query.dataSourceNo(i));
      }
      dictTable = new DictTable(query.dataSourceNo(i).table());     for (k=1; k<= filtercnt; k++)
      {
          filter = query.queryFilter(k, query.dataSourceNo(i));
          dictField = new DictField(query.dataSourceNo(i).table(), fieldname2id(query.dataSourceNo(i).table(), filter.field()));
          info (strFmt("%1, %2. Range = %3", dictTable.label(), dictField.label(), filter.value()));
      }    for (j=1; j<=cnt; j++)
      {
          range = queryRun.query().dataSourceNo(i).range(j);
          dictField = new DictField(query.dataSourceNo(i).table(), fieldname2id( query.dataSourceNo(i).table(), range.AOTname()));
          if(range.value())
          {
              info(strfmt("%1, %2. Range = %3",dictTable.label(), dictField.label(), range.value()));
          }
      }
   }
  }

  
  

  Reply

• POSTED BY MARTIN DRÁB  ON 5 OCT 2012 6:36 AM

  You need the actual query used in the report (ReportRun.query()), not just the query as defined in AOT.

  Martin "Goshoom" Dráb | UK/Czech rep. | Goshoom.NET Dev Blog

          

  Reply
• POSTED BY DANIEL ESSER  ON 5 OCT 2012 12:20 PM  VERIFIED ANSWER VERIFIED BY PEDRO RODRIGUEZ

  I think user input are defined as filters in the query.

  try this:

  static void getQueryRanges2(Args _args)
  {
   Query query;
   QueryRun queryRun;
   QueryBuildDataSource qbd;
   QueryBuildRange range;
   QueryFilter filter; int cnt, filtercnt, i,j, k;
   DictTable dictTable;
   DictField dictField; str fieldLabel;
   ;
   query = new query(queryStr(smmSalesCustItemStatistics));
   queryRun = new QueryRun(query);
   queryRun.prompt();
   query = queryRun.query();  for(i = 1; i <= query.dataSourceCount(); i++)
   {
      cnt = query.dataSourceNo(i).rangeCount();
      filtercnt = 0;    if(!query.dataSourceNo(i).embedded())
      {
          filtercnt = query.queryFilterCount(query.dataSourceNo(i));
      }
      dictTable = new DictTable(query.dataSourceNo(i).table());     for (k=1; k<= filtercnt; k++)
      {
          filter = query.queryFilter(k, query.dataSourceNo(i));
          dictField = new DictField(query.dataSourceNo(i).table(), fieldname2id(query.dataSourceNo(i).table(), filter.field()));
          info (strFmt("%1, %2. Range = %3", dictTable.label(), dictField.label(), filter.value()));
      }    for (j=1; j<=cnt; j++)
      {
          range = queryRun.query().dataSourceNo(i).range(j);
          dictField = new DictField(query.dataSourceNo(i).table(), fieldname2id( query.dataSourceNo(i).table(), range.AOTname()));
          if(range.value())
          {
              info(strfmt("%1, %2. Range = %3",dictTable.label(), dictField.label(), range.value()));
          }
      }
   }
  }

  
  

  Reply
• POSTED BY PEDRO RODRIGUEZ  ON 5 OCT 2012 3:08 PM

  Thanks!