0 Replies Latest reply: Aug 16, 2011 11:36 PM by 881538 RSS

    Find Criteria problem in ADF BC framework with DataServices for tables 1to1

    881538
      Hi..

      I have built a DataService (Database tables exposed as WebServices) using ADF BC framework in JDeveloper.

      I have used 2 tables Cqualitycategory(Parent) and Cqualitycategoryxref(child) with 1 to 1 relationship on id Cqualitycategoryid.

      This service exposes operations such as Create, Update, Find, delete & etc.

      After providing this service WSDL path to SOAP UI tool and when I try to hit the find criteria(*childFindCriteria*) using the below request I receive all the records of the child for a single parent table(Having multiple records for the child tables). But according to the below request(childFindCriteria filter) I should only get the records which matches the filter along with the Parent record.

      ---&-----------------------------------&-------------------------&----------------------------------&----------------------------&-----------------------------&
      <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:typ="/com/abc/csim/ebo/module/common/types/" xmlns:typ1="http://xmlns.oracle.com/adf/svc/types/">
      <soapenv:Header/>
      <soapenv:Body>
      <typ:findCqualitycategoryBO>
      <typ:findCriteria>
      <typ1:fetchStart>0</typ1:fetchStart>
      <typ1:fetchSize>-1</typ1:fetchSize>
      <typ1:filter>
      <typ1:group>
      <typ1:upperCaseCompare>true</typ1:upperCaseCompare>
      <typ1:item>
      <typ1:upperCaseCompare>true</typ1:upperCaseCompare>
      <typ1:attribute>Cqualitycategoryid</typ1:attribute>
      <typ1:operator>like</typ1:operator>
      <typ1:value>209</typ1:value>
      </typ1:item>
      </typ1:group>
      </typ1:filter>
      <typ1:childFindCriteria>
      <typ1:filter>
      <typ1:group>
      <typ1:item>
      <typ1:upperCaseCompare>true</typ1:upperCaseCompare>
      <typ1:attribute>Cqualitycategorycode</typ1:attribute>
      <typ1:operator>=</typ1:operator>
      <typ1:value>P1234</typ1:value>
      <typ1:nested/>
      </typ1:item>
      </typ1:group>
      </typ1:filter>
      <typ1:childFindCriteria/>
      </typ1:childFindCriteria>
      </typ:findCriteria>
      <typ:findControl>
      <typ1:retrieveAllTranslations>false</typ1:retrieveAllTranslations>
      </typ:findControl>
      </typ:findCqualitycategoryBO>
      </soapenv:Body>
      </soapenv:Envelope>
      %--------------------------------%--------------------------------------%---------------------%----------------------------%---------------------------------%


      But the same kind of request (find criteria) is perfectly works fine by giving the desired result(childFindCriteria) with 1 Parent tables and 2-3 childs(1 to many relationship).

      It seems to be an issue with the ADF BC Framework for the tables with 1 to 1 relationship.

      Please suggest me a solution or a work around so that the childFindCriteria works for tables with 1 to 1 relationship.

      Mahesh

      Edited by: user13174911 on Aug 17, 2011 10:03 AM

      Edited by: user13174911 on Aug 17, 2011 10:05 AM