Naveen, You can find reference to retrieving entries from multiple forms in the 7.6.4 C API Reference document provided by BMC. There is a section specific to this along with example in C and Java api. Beyond simple joins, it also covers recursion, and other interesting things, if needed. Hopefully that helps.
-Eric From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: Friday, November 01, 2013 8:27 AM To: arslist@ARSLIST.ORG Subject: Re: Java API for Query based upon a composite qualification ** 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<mailto: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_ _ARSlist: "Where the Answers Are" and have been for 20 years_ 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. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"