Package de.elo.ix.jscript

Class FindSordsByObjKeys

java.lang.Object
de.elo.ix.jscript.FindObjects
de.elo.ix.jscript.FindSordsByObjKeys
public class FindSordsByObjKeys extends FindObjects
This class allows to select Sord objects by index field values when searching for objects with FindByRegisteredFunction.
See Also:

  • Constructor Details

    • FindSordsByObjKeys

      public FindSordsByObjKeys(String okeyName, Object jsOkeyValues)
      Constructor
      Parameters:
      okeyName - An index field group name.
      jsOkeyValues - Index field values. Either one value, an array of values or a table of values whereby the first column contains the index field values.

    • FindSordsByObjKeys

      public FindSordsByObjKeys(Object jsOkeyNameAndValues)
      Constructor
      Parameters:
      jsOkeyNameAndValues - A table of values whereby the first column contains the index field (group) name and the second column contains the values.

  • Method Details

    • getAlias

      public String getAlias()
      Description copied from class: FindObjects
      Get alias table name for the Sords (objekte) table. Optional. This alias must be used in the where clause for every column name of the Sords table. This function is only called for the first object.
      Overrides:
      getAlias in class FindObjects
      Returns:
      alias name

    • bindParams

      public void bindParams(PreparedStatement pstmt, int startCol) throws SQLException
      Description copied from class: FindObjects
      Submit parameters for the JDBC Statement. The calling function creates a PreparedStatement based on the return values of getAlias, getFrom and getWhere. With a call to this function, all parameters conatined in the Prepared statement should be bound.
      Overrides:
      bindParams in class FindObjects
      Throws:
      SQLException

    • getFrom

      public String getFrom()
      Description copied from class: FindObjects
      Get the table name or a comma separated list of table names to select from. E. g. to select from Sords and document versions return "objekte,dochistory". This function is only called for the first object.
      If an alias for the Sords table should be used, the alias must follow the table name. E.g. getAlias()="o", getFormat()="objekte o, dochistory d", getWhere()="o.objid=d.objectid and ..."
      Overrides:
      getFrom in class FindObjects
      Returns:
      table name(s)

    • getWhere

      public String getWhere()
      Description copied from class: FindObjects
      Where clause. This function is only called for the first object. Use PreparedStatement placeholders for the Sord ID and other parameters (if there are any).
      If an alias for the Sords table should be used, the alias must prefix the column names. E.g. getAlias()="o", getFormat()="objekte o, dochistory d", getWhere()="o.objid=d.objectid and ..."
      Overrides:
      getWhere in class FindObjects
      Returns:
      where clause

    • next

      public boolean next() throws SQLException
      Description copied from class: FindObjects
      Move to next object.
      Overrides:
      next in class FindObjects
      Returns:
      false, if no more objects available
      Throws:
      SQLException

    • getCurrentPosAsString

      public String getCurrentPosAsString()
      Description copied from class: FindObjects
      Get information about the current position. E. g. return the parameters set into the PreparedStatement in the bindParams function.
      Overrides:
      getCurrentPosAsString in class FindObjects
      Returns:
      Information string