This discussion is archived
4 Replies Latest reply: Nov 21, 2012 10:44 PM by Jagadeesh P RSS

Question BS to read only a particular CHAR Type

954933 Newbie
Currently Being Moderated
I am developing a BS, in the BS schema i want to read some Premise information and only a particular char type to read, i don’t want to display all the characteristics on the UI.

BS schema
<schema>
<premiseId mapField="PREM_ID" fkRef="PREM"/>
<address1 mapField="ADDRESS1"/>
<city mapField="CITY"/>
<county mapField="COUNTY"/>
<state mapField="STATE"/>
<premiseCharacteristic type="list" mapList="PREM_CHAR">
<characteristicType mapField="CHAR_TYPE_CD"/> want to restrict only for 'ELEVAT' char type cd
<characteristicValue mapField="CHAR_VAL"/>
<effectiveDate mapField="EFFDT"/>
</premiseCharacteristic>
</schema>

when i use this BS, i get all the characteristics for that Premise, but i want to retrieve only for the char type cd 'ELEVAT', want to know who to restrict in Schema to get data only for 'ELEVAT' char type code, help is appreciated.

Thanks,
Pavan
  • 1. Re: Question BS to read only a particular CHAR Type
    Luckys Pro
    Currently Being Moderated
    You can restrict that both at the UI Map or at the Business Service level. Basically you have to flatten the element. At the UI Map level, you can filter the list with the specific value, similar to XPATH, e.g. ".../resultList/charVal[charTypeCd='XYZ']"
    <schema>
      <premiseId mapField="PREM_ID" fkRef="PREM" />
      <address1 mapField="ADDRESS1" />
      <city mapField="CITY" />
      <county mapField="COUNTY" />
      <state mapField="STATE" />
      <elevation mapField="CHAR_VAL">
        <row mapList="PREM_CHAR">
          <CHAR_TYPE_CD is="ELEVAT" />
          <EFFDT is="%effectiveDate" />
        </row>
      </elevation>
    </schema>
  • 2. Re: Question BS to read only a particular CHAR Type
    954933 Newbie
    Currently Being Moderated
    Thank you Luckys,it works.
  • 3. Re: Question BS to read only a particular CHAR Type
    954933 Newbie
    Currently Being Moderated
    all,

    i am calling the above BS in my BPA and trying to move the value from Char Val to other BO , for some reason i am not able to. here is the code any one tell me hoe to move the value.

    <schema>
    <premiseId mapField="PREM_ID" fkRef="PREM" />
    <address1 mapField="ADDRESS1" />
    <city mapField="CITY" />
    <county mapField="COUNTY" />
    <state mapField="STATE" />
    <elevation mapField="CHAR_VAL">
    <row mapList="PREM_CHAR">
    <CHAR_TYPE_CD is="ELEVAT" />
    <EFFDT is="%effectiveDate" />
    </row>
    </elevation>
    </schema>

    In BPA
    tried following three
    1. move "CM_PREM/elevation/resultList/charVal" to "CmTestBO/eCharVal";
    2. move "CM_PREM/resultList/charVal" to "CmTestBO/eCharVal";
    3. move "CM_PREM/resultList[0]/charVal" to "CmTestBO/eCharVal";
    none of the above worked.
  • 4. Re: Question BS to read only a particular CHAR Type
    Jagadeesh P Newbie
    Currently Being Moderated
    it should be
    move "CM_PREM/elevation" to "CmTestBO/eCharVal";

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points