Hi @TDCANJANA 

You can perform a mass delete using a XML BR based on the input conditions. Please refer the sample xml message below. The message is quite similar to mass update, and the only difference is that we need to replace the ‘update’ element with ‘delete’ right after the hierarchy select.

<mass_update_invoice>
  <hierarchy_select>
    <attrs>
      <attr>invoice.invoice_id</attr>
    </attrs>
    <primary_table>invoice</primary_table>
    <from>
      <table>invoice</table>
    </from>
    <where>
      <data_constraint>
        <constraint>
          <left_operand>invoice.user_def2</left_operand>
          <operator>eq</operator>
          <right_operand>N</right_operand>
        </constraint>
      </data_constraint>
    </where>
  </hierarchy_select>
  <invoice>
    <user_def2>Y</user_def2>
    <delete />
  </invoice>
  <transaction_size>1</transaction_size>
</mass_update_invoice>