4 Replies Latest reply: Nov 22, 2012 12:44 AM by Jagadeesh P RSS

    Question BS to read only a particular CHAR Type

    954933
      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
          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
            Thank you Luckys,it works.
            • 3. Re: Question BS to read only a particular CHAR Type
              954933
              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
                it should be
                move "CM_PREM/elevation" to "CmTestBO/eCharVal";