Skip to main content
Solved

Update Part Usage XML Business Rule Error

  • May 1, 2024
  • 4 replies
  • 125 views
M
Sidekick (Customer)
Forum|alt.badge.img+7

I am attempting to update all part usage lines on a Task when task.user_def4 is set to a particular value.

I have setup a Custom Process XML business rule with TASK as the Primary Table and this is firing when task.user4 is set. The Custom Process is shown below.

I want to update part_usage.part_line_code on all part usage lines on the task. The Business Rule is shown below.

The error I get when my BR fires is  “Attempt to update a record without providing all Primary Key information”.

My XML is as follows.

 

<update_part_usage>
<part_usage>
<part_usage>@task_id</part_usage>
<part_line_code>MIS</part_line_code>
<update/>
</part_usage>
</update_part_usage>

 

Any guidance on where i have gone wrong would be appreciated.

Thanks,

Barry

Best answer by AdrianEgley

@MWAMAITTEAM 

 

The primary key will relate to not knowing which PU_ID to update. The other option would be to use a mass_update XML.

 

<mass_update_part_usage>
  <hierarchy_select>
    <primary_table>part_usage</primary_table>
    <attrs>
      <attr>part_usage.pu_id</attr>
    </attrs>
    <from>
      <table>part_usage</table>
    </from>
    <where>
      <data_constraint>
        <constraint>
          <left_operand>part_usage.task_id</left_operand>
          <operator>eq</operator>
          <right_operand>@task_id</right_operand>
        </constraint>
      </data_constraint>
    </where>
  </hierarchy_select>
  <part_usage>
    <part_line_code>MIS</part_line_code>
    <update />
  </part_usage>
  <transaction_size>100</transaction_size>
  <synchronous>Y</synchronous>
</mass_update_part_usage>

This should locate all Part Usages and set the Line Code based on that task id.

 

Ady

4 replies

S
Do Gooder (Employee)
Forum|alt.badge.img+4
  • sujoin
  • Do Gooder (Employee)
  • May 1, 2024

Hi @MWAMAITTEAM ,

 

     Can you try this code?

<update_part_usage>
  <part_usage>
    <pu_id />
<part_usage>@task_id</part_usage>
<part_line_code>MIS</part_line_code>
    <update />
  </part_usage>
</update_part_usage>

 

Thanks

Sumit 

M
Sidekick (Customer)
Forum|alt.badge.img+7
  • MWAMAITTEAM
  • Author
  • Sidekick (Customer)
  • May 1, 2024

Hi Sumit,

I have updated the XML as per your code but still seeing the error below when it fires.

 

 

Thanks,

Barry

AdrianEgley
Hero (Customer)
Forum|alt.badge.img+14
  • AdrianEgley
  • Hero (Customer)
  • Answer
  • May 1, 2024

@MWAMAITTEAM 

 

The primary key will relate to not knowing which PU_ID to update. The other option would be to use a mass_update XML.

 

<mass_update_part_usage>
  <hierarchy_select>
    <primary_table>part_usage</primary_table>
    <attrs>
      <attr>part_usage.pu_id</attr>
    </attrs>
    <from>
      <table>part_usage</table>
    </from>
    <where>
      <data_constraint>
        <constraint>
          <left_operand>part_usage.task_id</left_operand>
          <operator>eq</operator>
          <right_operand>@task_id</right_operand>
        </constraint>
      </data_constraint>
    </where>
  </hierarchy_select>
  <part_usage>
    <part_line_code>MIS</part_line_code>
    <update />
  </part_usage>
  <transaction_size>100</transaction_size>
  <synchronous>Y</synchronous>
</mass_update_part_usage>

This should locate all Part Usages and set the Line Code based on that task id.

 

Ady

Shneor Cheshin
M
M
Sidekick (Customer)
Forum|alt.badge.img+7
  • MWAMAITTEAM
  • Author
  • Sidekick (Customer)
  • May 1, 2024

Many thanks Ady.

Thats works just how we need it to.

Regards,

Barry

AdrianEgley
Terms & ConditionsCookie settingsAccessibility statement