Solved

Set null value using xml update

  • 20 December 2022
  • 1 reply
  • 104 views
M
Rank
Userlevel 4
Badge +9
  • Miraj
  • Sidekick (Partner)
  • 59 replies

Hi Experts,

Is it possible to set a null value with an xml update?

ex: 
update task set person_id=null where task_id=123

how to do this with an xml?
I tried the following but didn’t work

<update_task>
  <task>
    <task_id>123</task_id>
    <person_id></person_id>
    <update />
  </task>
</update_task>

icon

Best answer by anmise 21 December 2022, 07:49

View original

1 reply

A
Rank
Userlevel 7

I have a vague memory that you need to use = to set null. 
 

<update_task>
  <task>
    <task_id>123</task_id>
    <person_id>=</person_id>
    <update />
  </task>
</update_task>

 

Reply


Terms & ConditionsCookie settings