if (assetID.indexOf ("-item-") != -1) return getManifestSql(dbConfig, runID);
  protected String getSql(DatabaseConfig dbConfig, int runID){    //For select:    String aiOwner="ai."+DGPSPConstants.COL_OWNER;    String apType="ap."+DGPSPConstants.COL_ALP_TYPEID;    String apNomen="ap."+DGPSPConstants.COL_ALP_NOMENCLATURE;    String aiName="ai."+DGPSPConstants.COL_NAME;    String aiAgg="ai."+DGPSPConstants.COL_AGGREGATE;    String apAClass="ap."+DGPSPConstants.COL_ASSET_CLASS;    String apAType="ap."+DGPSPConstants.COL_ASSET_TYPE;    String cccDimWeight=DGPSPConstants.COL_WEIGHT;    String cccDimWidth=DGPSPConstants.COL_WIDTH;    String cccDimHeight=DGPSPConstants.COL_HEIGHT;    String cccDimDepth=DGPSPConstants.COL_DEPTH;    String cccDimArea=DGPSPConstants.COL_AREA;    String cccDimVolume=DGPSPConstants.COL_VOLUME;    String cccDimCCC=DGPSPConstants.COL_CARGO_CAT_CODE;    String sql="select "+      aiOwner+", "+      apType+", "+      apNomen+", "+      aiName+", "+      aiAgg+", "+      apAClass+", "+      apAType+", "+      cccDimWeight+", "+      cccDimWidth+", "+      cccDimHeight+", "+      cccDimDepth+", "+      cccDimArea+", "+      cccDimVolume+", "+      cccDimCCC+      "\nfrom " +getFrom  (runID) + "\n" +      "where "+getWhere (runID) + "\n" +      "order by " + aiOwner +"," +apType+","+apNomen+","+aiName;    if (debug)       TPFDDLoggerFactory.createLogger().logMessage(Logger.NORMAL, Logger.GENERIC, "AssetAssetDetailRequest.getSql - sql is\n" + sql);      return sql;  }