Eric, I see no reason why you wouldn’t be able to use that method to create the QualifierInfo object….I’m not entirely sure of the code you are using to get the cast error. Please feel free to contact me offlist if you would like, but I would love to try to help J
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Eric Roys Sent: Sunday, April 15, 2012 9:02 PM To: arslist@ARSLIST.ORG Subject: Multi schema join parse qualfier ** For you java api folks… ARS 7.6.4 sp2 Java api 7.6.4 build 2 Java 7 Is there a parse qual method for translating a query string (i.e. ‘This’ = $This$ AND ‘That’ = $That$) for the QualifierInfo required by com.bmc.arsys.api. <eclipse-javadoc:%E2%98%82=ARS%20API%20Examples/C:%5C/rem_api%5C/arapi7604_build002.jar%3Ccom.bmc.arsys.api(QuerySourceForm.class%E2%98%83QuerySourceForm> QuerySourceForm.setJoin( <eclipse-javadoc:%E2%98%82=ARS%20API%20Examples/C:%5C/rem_api%5C/arapi7604_build002.jar%3Ccom.bmc.arsys.api(QuerySourceForm.class%E2%98%83QuerySourceForm~setJoin~Lcom.bmc.arsys.api.IQuerySource;~I~Lcom.bmc.arsys.api.QualifierInfo;%E2%98%82IQuerySource> IQuerySource arg0, int arg1, <eclipse-javadoc:%E2%98%82=ARS%20API%20Examples/C:%5C/rem_api%5C/arapi7604_build002.jar%3Ccom.bmc.arsys.api(QuerySourceForm.class%E2%98%83QuerySourceForm~setJoin~Lcom.bmc.arsys.api.IQuerySource;~I~Lcom.bmc.arsys.api.QualifierInfo;%E2%98%82QualifierInfo> QualifierInfo arg2) method [or does one have to embrace the long hand version and write out as indicated in the appendix of the C API reference doc (excerpt below)? I was hoping that the parseQualification(String queryString, List<Field> fieldList1, List<Field> fieldList2, int queryContext, boolean exceptionWhenFieldNotFound) method would do the trick but it seems the getListEntryObjects fails with a cast exception (java.lang.Integer cannot be cast to com.bmc.arsys.api.QueryFormField). Excerpt: // Create join qualifier, which is used to generate the SQL query’s // ON clause. ArithmeticOrRelationalOperand field1 = new ArithmeticOrRelationalOperand(240001002, prodCat); ArithmeticOrRelationalOperand field2 = new ArithmeticOrRelationalOperand(240001002, products); RelationalOperationInfo relOp = new RelationalOperationInfo(RelationalOperationInfo.AR_REL_OP_EQUAL, field1, field2); QualifierInfo joinQual = new QualifierInfo(relOp); Thanks, Eric CONFIDENTIALITY NOTICE: This email communication is intended only for the personal and confidential use of the recipient(s) designated above and may contain information which is subject to Federal and/or State privacy laws. In the event that you are not the intended recipient or the agent of the intended recipient, you are hereby notified that any review, disclosure, or use of the information contained herein is strictly prohibited. Do not copy or use the information contained within this communication, or allow it to be read, copied or utilized in any manner by any other person(s). If you have received this communication in error, please notify the sender immediately, either by response e-mail or by phone, and permanently delete the original e-mail, any attachment(s), and copies. _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
