Thank you Misi, I think this is the method that is likely used getListEntryObjects
public List <http://java.sun.com/j2se/1.5.0/docs/api/java/util/List.html?is-external=true><QuerySourceValues <file:///C:/Users/llongwing/Documents/ARJavaLib/ardoc81_build001/com/bmc/arsys/api/QuerySourceValues.html>> *getListEntryObjects*(RegularQuery <file:///C:/Users/llongwing/Documents/ARJavaLib/ardoc81_build001/com/bmc/arsys/api/RegularQuery.html> query, int firstRetrieve, int maxRetrieve, boolean useLocale, OutputInteger <file:///C:/Users/llongwing/Documents/ARJavaLib/ardoc81_build001/com/bmc/arsys/api/OutputInteger.html> nMatches) throws ARException <file:///C:/Users/llongwing/Documents/ARJavaLib/ardoc81_build001/com/bmc/arsys/api/ARException.html> Returns a list of QuerySourceValues<file:///C:/Users/llongwing/Documents/ARJavaLib/ardoc81_build001/com/bmc/arsys/api/QuerySourceValues.html> objects that match the provided criteria. Supports joins, subqueries and hierarchical queries constructs. *Parameters:*query - RegularQuery<file:///C:/Users/llongwing/Documents/ARJavaLib/ardoc81_build001/com/bmc/arsys/api/RegularQuery.html> query that determines the set of entries to retrievefirstRetrieve - first entry to retrieve. A value of 0 represent the first entry.maxRetrieve - maximum number of entries to retrieveuseLocale - boolean flag that controls whether the result includes only entries based on locale (1 or TRUE) or all enties (0 or FALSE). The Localize Server option must be selected for the AR System server to return only localized entries. For information about the Localize Server option, see the *Configuring* guide.nMatches - returns the number of (accessible) entries that match the qualification criteria. Specify null for this parameter if you do not want to retrieve this count.*Returns:*list of QuerySourceValues<file:///C:/Users/llongwing/Documents/ARJavaLib/ardoc81_build001/com/bmc/arsys/api/QuerySourceValues.html> objects that match the provided criteria*Throws:*ARException<file:///C:/Users/llongwing/Documents/ARJavaLib/ardoc81_build001/com/bmc/arsys/api/ARException.html> - if list is not returned where 'RegularQuery' is defined as The RegularQuery class is used to define the properties of a dynamic query. So this definitely looks like the method used to query 'dynamic' forms :) On Fri, Nov 1, 2013 at 7:31 AM, Misi Mladoniczky <m...@rrr.se> wrote: > Hi, > > There is indeed a new API-call introduced in verison 7.6.04, to allow BIRT > to > do ad-hoc joins. > > The C-API call is ARGetListEntryWithMultiSchemaFields(), and there should > be a > Java-API equivalent. > > Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) > > Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13): > * RRR|License - Not enough Remedy licenses? Save money by optimizing. > * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. > Find these products, and many free tools and utilities, at http://rrr.se. > > > Naveen, > > To the best of my knowledge, the API itself cannot do this, never really > > has been able to...but some versions ago (I think it was 7.6.04) BMC > > introduced 'Multi-Form Search', or MFS....if you read the docs you can > read > > up a bit about it, and once configured, the API would be able to utilize > > your MFS Form to do what you want, I think. > > > > > https://docs.bmc.com/docs/display/public/ars81/Creating+a+form+and+workflow+to+search+across+multiple+forms > > > > > > On Thu, Oct 31, 2013 at 9:57 PM, Setya, Naveen <nse...@columnit.com> > wrote: > > > >> ** > >> > >> Greetings, **** > >> > >> ** ** > >> > >> Can someone please provide an example of java API that can be used to > >> retrieve data from a form based upon a composite qualification?**** > >> > >> ** ** > >> > >> e.g. Form A and Form B**** > >> > >> ** ** > >> > >> Retrieve Data from Form A where FormA.Field1=FormB.Field2 ** ** > >> > >> ** ** > >> > >> Thanks in advance **** > >> > >> Naveen **** > >> > >> ** ** > >> > >> ** ** > >> _ARSlist: "Where the Answers Are" and have been for 20 years_ > > > > > _______________________________________________________________________________ > > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > > "Where the Answers Are, and have been for 20 years" > > > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > "Where the Answers Are, and have been for 20 years" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"