Examples of MQuery

com.echonest.api.v4.util.MQuery
org.compiere.model.MQuery
.net/tracker/?func=detail&aid=2860022&group_id=176962&atid=879332 The changes created a bug that removed parameter listings from the first page header of the Financial Reports and the Statement of Accounts.

Examples of org.compiere.model.MQuery

    Integer M_Product_ID = getSelectedRowKey();
    if (M_Product_ID == null)
      return;
  //  AEnv.zoom(MProduct.Table_ID, M_Product_ID.intValue(), true);  //  SO
    
    MQuery query = new MQuery("M_Product");
    query.addRestriction("M_Product_ID", MQuery.EQUAL, M_Product_ID);
    query.setRecordCount(1);
    int AD_WindowNo = getAD_Window_ID("M_Product", true);  //  SO
    zoom (AD_WindowNo, query);
  }  //  zoom

View Full Code Here

Examples of org.compiere.model.MQuery

    }
    
    setCursor(Cursor.getPredefinedCursor(Cursor.WAIT_CURSOR));
    if (m_drillDown)
    {
      MQuery query = m_viewPanel.getDrillDown(point);
      if (query != null)
      {
        log.info("Drill Down: " + query.getWhereClause(true));
        executeDrill(query);
      }
    }
    else if (comboDrill.getSelectedItem() != null && comboDrill.getSelectedIndex() > 0)
    {
      MQuery query  = m_viewPanel.getDrillAcross(point);
      if (query != null)
      {
        NamePair pp = (NamePair)comboDrill.getSelectedItem();
        query.setTableName(pp.getID());
        log.info("Drill Accross: " + query.getWhereClause(true));
        executeDrill(query);
      }
    }
    cmd_drill();  //  setCursor
  }  //  mouse_clicked

View Full Code Here

Examples of org.compiere.model.MQuery

   */
  static public void main (String[] args)
  {
    Login.initTest(true);


    MQuery q = new MQuery("C_Invoice");
    q.addRestriction("C_Invoice_ID", MQuery.EQUAL, new Integer(103));


    //  102 = Invoice - 100 = Order
    PrintInfo i = new PrintInfo("test", X_C_Invoice.Table_ID, 102, 0);
    MPrintFormat f = MPrintFormat.get (Env.getCtx(), 102, false);
    ReportEngine re = new ReportEngine(Env.getCtx(), f, q, i);

View Full Code Here

Examples of org.compiere.model.MQuery

    }
    
    cmd_save(false);


    //  Query
    MQuery query = new MQuery(m_curTab.getTableName());
    //  Link for detail records
    String queryColumn = m_curTab.getLinkColumnName();
    //  Current row otherwise
    if (queryColumn.length() == 0)
      queryColumn = m_curTab.getKeyColumnName();
    //  Find display
    String infoName = null;
    String infoDisplay = null;
    for (int i = 0; i < m_curTab.getFieldCount(); i++)
    {
      GridField field = m_curTab.getField(i);
      if (field.isKey())
        infoName = field.getHeader();
      if ((field.getColumnName().equals("Name") || field.getColumnName().equals("DocumentNo") )
        && field.getValue() != null)
        infoDisplay = field.getValue().toString();
      if (infoName != null && infoDisplay != null)
        break;
    }
    if (queryColumn.length() != 0)
    {
      if (queryColumn.endsWith("_ID"))
        query.addRestriction(queryColumn, MQuery.EQUAL,
          new Integer(Env.getContextAsInt(m_ctx, m_curWindowNo, queryColumn)),
          infoName, infoDisplay);
      else
        query.addRestriction(queryColumn, MQuery.EQUAL,
          Env.getContext(m_ctx, m_curWindowNo, queryColumn),
          infoName, infoDisplay);
    }


    new AReport (m_curTab.getAD_Table_ID(), aReport.getButton(), query, this, m_curWindowNo, m_curTab.getWhereExtended());

View Full Code Here

Examples of org.compiere.model.MQuery

    log.info("ID=" + record_ID);
    if (record_ID <= 0)
      return;


    //  Query
    MQuery query = new MQuery();
    //  Current row
    String link = m_curTab.getKeyColumnName();
    //  Link for detail records
    if (link.length() == 0)
      link = m_curTab.getLinkColumnName();
    if (link.length() != 0)
    {
      if (link.endsWith("_ID"))
        query.addRestriction(link, MQuery.EQUAL,
          new Integer(Env.getContextAsInt(m_ctx, m_curWindowNo, link)));
      else
        query.addRestriction(link, MQuery.EQUAL,
          Env.getContext(m_ctx, m_curWindowNo, link));
    }
    new AZoomAcross (aZoomAcross.getButton(), 
      m_curTab.getTableName(), query);
  }  //  cmd_zoom

View Full Code Here

Examples of org.compiere.model.MQuery

    //  Gets Fields from AD_Field_v
    GridField[] findFields = GridField.createFields(m_ctx, m_curWindowNo, 0, m_curTab.getAD_Tab_ID());
    Find find = new Find (Env.getFrame(this), m_curWindowNo, m_curTab.getName(),
      m_curTab.getAD_Tab_ID(), m_curTab.getAD_Table_ID(), m_curTab.getTableName(), 
      m_curTab.getWhereExtended(), findFields, 1);
    MQuery query = find.getQuery();
    find.dispose();
    find = null;


    //  Confirmed query
    if (query != null)

View Full Code Here

Examples of org.compiere.model.MQuery

    m_AD_Table_ID = AD_Table_ID;
    m_tableName = tableName;
    m_whereExtended = whereExtended;
    m_findFields = findFields;
    //
    m_query = new MQuery (tableName);
    m_query.addRestriction(Env.parseContext(Env.getCtx(), m_targetWindowNo, whereExtended, false));
    //  Required for Column Validation
    Env.setContext(Env.getCtx(), m_targetWindowNo, "Find_Table_ID", m_AD_Table_ID);
    //  Context for Advanced Search Grid is WINDOW_FIND
    Env.setContext(Env.getCtx(), Env.WINDOW_FIND, "Find_Table_ID", m_AD_Table_ID);

View Full Code Here

Examples of org.compiere.model.MQuery

   *  Simple OK Button pressed
   */
  private void cmd_ok_Simple()
  {
    //  Create Query String
    m_query = new MQuery(m_tableName);
    // 2009-06-24 rgliddon: Removed following line which was not present in 352a.  New line is limiting
    // searches to records selected in initial search query.
//    m_query.addRestriction(Env.parseContext(Env.getCtx(), m_targetWindowNo, m_whereExtended, false));
    if (hasValue && !valueField.getText().equals("%") && valueField.getText().length() != 0)
    {

View Full Code Here

Examples of org.compiere.model.MQuery

   */
  private void cmd_save(boolean saveQuery)
  {
    advancedTable.stopEditor(true);
    //
    m_query = new MQuery(m_tableName);
    // 2009-06-24 rgliddon: Removed following line which was not present in 352a.  New line is limiting
    // searches to records selected in initial search query.
//    m_query.addRestriction(Env.parseContext(Env.getCtx(), m_targetWindowNo, m_whereExtended, false));
    StringBuffer code = new StringBuffer();
    for (int row = 0; row < advancedTable.getRowCount(); row++)

View Full Code Here

Examples of org.compiere.model.MQuery

          old_AD_PrintFormat_ID = AD_PrintFormat_ID;
        }
        format.setLanguage(language);
        format.setTranslationLanguage(language);
        //  query
        MQuery query = new MQuery("C_Invoice_Header_v");
        query.addRestriction("C_Invoice_ID", MQuery.EQUAL, new Integer(C_Invoice_ID));


        //  Engine
        PrintInfo info = new PrintInfo(
          DocumentNo,
          X_C_Invoice.Table_ID,

View Full Code Here

0 1 2

TOP

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.