Forum Discussion

Hargul_Sidhu's avatar
Hargul_Sidhu
Ideator I
2 years ago

Get item using multiple Where conditions and edit the item

I am trying to edit the State of a Part with a specific generation, "1". 

The output of the following is just  "<Result/>"
[embed:dc8ab71f-3b98-42d9-b0f6-e21e02a0f8e2:9a6a26a7-70fb-4a82-93de-26eefb432e27:type=text&text=Innovator%20innovator%20%3D%20this.getInnovator%28%29%3B%0Astring%20configId%20%3D%20this.getProperty%28%22config_id%22%29%3B%0AItem%20itm%20%3D%20this.newItem%28%22Part%22%2C%20%22edit%22%29%3B%0Aitm.setAttribute%28%22where%22%2C%22part.item_number%3D%2711-1-1D123%27%20AND%20part.generation%3D%271%27%22%29%3B%0Aitm.setProperty%28%22state%22%2C%22Released%22%29%3B%0Areturn%20itm.apply%28%29%3B]

However, if I use "setProperty" with "get" in separate lines I get the correct output. However, I can't use "setProperty" to filter with "edit" because it sets a new value for the property. Below is the code:
[embed:dc8ab71f-3b98-42d9-b0f6-e21e02a0f8e2:161b262a-2907-49f7-8c2f-47f2f3418f14:type=text&text=Innovator%20innovator%20%3D%20this.getInnovator%28%29%3B%0Astring%20configId%20%3D%20this.getProperty%28%22config_id%22%29%3B%0AItem%20itm%20%3D%20this.newItem%28%22Part%22%2C%20%22get%22%29%3B%0Aitm.setAttribute%28%22select%22%2C%20%22id%2Cgeneration%2Cmajor_rev%2Cstate%2Citem_number%22%29%3B%0Aitm.setProperty%28%22generation%22%2C%20%221%22%29%3B%0Aitm.setProperty%28%22item_number%22%2C%20%2211-1-1D123%22%29%3B%0Areturn%20itm.apply%28%29%3B]

AML
Server Methods

3 Replies

  • AngelaIp's avatar
    AngelaIp
    Ideator I
    2 years ago

    "State" property cannot be edited this way, cause state is changed due to promotion of the LifeCycle. So what you want to do requires the AML action "promoteItem" and not "edit".

    • Hargul_Sidhu's avatar
      Hargul_Sidhu
      Ideator I
      2 years ago

      Thanks!  Do you know why is the output "<Result/>" when more than one condition is used in the "where" clause. 
      Also, when the output is  "<Result/>"  it doesn't "edit" either. If  "<Result/>"  is just an item the part should at least be edited, correct?
      Also, where do I find more information on AML action "promoteItem". I need to see some examples of this or just some documentation outlining the use of methods in AML. Super new to Aras here. 

      • AngelaIp's avatar
        AngelaIp
        Ideator I
        2 years ago

        Classic promote looks like this:

        x.setAction("promoteItem");
        x.setProperty("state","Released");
        x.setProperty("comments", "it´s a lot of fun..."); // History comment
        x= x.apply();
        if (x.isError())

        Your empty result is not caused by more than one condition, but if one condition fu** things up.
        If you always include condition generation=1, but the item already have 12 generation, your query will fail. You cannot edit old generations of an item with AML. It´s something that is restricted. This requires editing via SQL, which I wouldn´t recommend to use in the beginning if you are not familiar with the database structure and it´s dependencies . From my POV Aras should allow editing old generation under certain conditions, but they will never change that.

        When you are an subscriber, try to attend in the dev trainings as soon as possible were a lot of this general query stuff is covered.