I have XML type Business Rule from where I am firing the xml:
<perform_batch>
<sequential_dependent>
<hierarchy_select result_name="select_task1">
<primary_table>task</primary_table>
<from>
<table>task</table>
<table>tdc_central</table>
</from>
<attrs>
<attr>task.task_id</attr>
<attr>task.user_def11</attr>
<attr>tdc_central.circuit</attr>
<attr>tdc_central.skill</attr>
</attrs>
<where>
<data_constraint>
<constraint>
<left_operand>task.task_id</left_operand>
<operator>eq</operator>
<right_operand>@task_id</right_operand>
</constraint>
<constraint>
<left_operand>task.task_type</left_operand>
<operator>eq</operator>
<right_operand>CABLE_FAULT</right_operand>
</constraint>
<constraint>
<left_operand>tdc_central.skill</left_operand>
<operator>ne</operator>
<right_operand>null</right_operand>
</constraint>
</data_constraint>
<join_constraint>
<constraint>
<left_operand>task.user_def11</left_operand>
<operator>equi</operator>
<right_operand>tdc_central.circuit</right_operand>
</constraint>
</join_constraint>
</where>
</hierarchy_select>
<update_task_skill>
<task_skill>
<task_id xpath_node="//task_hierarchy_select_result[@result_name='select_task1']/task/task_id" />
<skill xpath_node="//task_hierarchy_select_result[@result_name='select_task1']/task/tdc_central/skill" />
<insert />
</task_skill>
</update_task_skill>
</sequential_dependent>
</perform_batch>
In this xml query there is join constrant:
<join_constraint>
<constraint>
<left_operand>task.user_def11</left_operand>
<operator>equi</operator>
<right_operand>tdc_central.circuit</right_operand>
</constraint>
</join_constraint>
Here Task.user_def11 may return camel case value or lower case value, we are not sure about case combination but tdc_central.circuit will give always a UPPER CASE value. Is there any way we can ignore the case in this join constraint so that it works for all combination of value in the column Task.user_def11?