Solved

Mass delete for technician skills

  • 30 April 2024
  • 1 reply
  • 51 views

Badge +1

I want to perform “MASS DELETE” on some selected skills in a screen. Is there any functionality in FSM that can do it or is there any way to do it? 

icon

Best answer by SAMLK 30 April 2024, 10:43

View original

1 reply

Userlevel 4
Badge +13

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>

 

Reply