FSM XML Busines Rule

Thank you very much that fixed my issue

@Mike The FSM TechnoGeek  Thank you for your help previously. i have a new requirement to add to this. I now need to grab another field that is on the place table to use in the expression. say place.external reference. how would i go about adding that you the xml business rule i am assuming i need to do a hierarchy select against the place table but how would i add the result to the expression.

Thanks again for your help.

Graeme

Graeme -

You can use the xpath attribute in the field tag for the field value to refer to previous results.  Have a look at this, fourth line from the bottom.

 

<perform_batch>
 <sequential_dependent/>
 <hierarchy_select result_name="SelectPlace01">
 <attrs>
 <attr>place.place_id</attr>
 <attr>place.external_reference</attr>
 </attrs>
 <primary_table>place</primary_table>
 <from>
 <table>place</table>
 </from>
 <where>
 <data_constraint>
 <constraint>
 <left_operand>place.place_id</left_operand>
 <operator>eq</operator>
 <right_operand>24379</right_operand>
 </constraint>
 </data_constraint>
 </where>
 </hierarchy_select>
 <update_rid_settlement regex_validated="true">
 <rid_settlement>
 <insert is_initialized="false"/>
 <charge_group>STANDARD</charge_group>
 <cost_split>ALL</cost_split>
 <charge_code>@expression["S-" + request.place_id + "-M"]</charge_code>
 <request_id>@request_id</request_id>
 <place_ext_ref xpath_node="//place_hierarchy_select_result[@result_name='SelectPlace01']/place/external_reference"/>
 </rid_settlement>
 </update_rid_settlement>
</perform_batch>

@Mike The FSM TechnoGeek Thanks if I want use the xpath value in the expression instead of the request.place_id how would I update it

@expression["S-" + place.external_reference + "-M"]

Pretty much just like that.  HOWEVER, you will need to have a custom metadata relationship defined (presumably) from the request table to the place table.  I suggest using a join type relationship.  Expressions are resolved for other tables via metadata relationships.