Email Configuration

オフライン

Can anyone help me with a sample email notification, with query which has a relationship to the item as well as html with a loop which displays that relationship. A good example can be of ECN to Affected items i.e. documents/

Parents
  • Hkhan,

    If you expand a bit more what kind of loop you want, I'm sure I can point you in a more specific direction, but a query with a relationship might look something like the following:


    <AML>
        <Item type="ECN" action="get">
            <id>[ID]</id>
            <Relationships>
                <Item type="ECN Affected Item" action="get"/>
            </Relationships>
        </Item>
    </AML>

    You'd have to sort out exactly what information you want- the above is just going to dump most of the output on you- but my understanding is you've got that part and you're just looking for how to get at relationships. For queries which you want to go deeper and deeper, an alternative to nesting can be something like getting repeating items with the same structure. Take a look at the GetItemRepeatConfig instruction in this article, and let me know if that helps.

    Skyler C

  • オフライン in reply to Skyler Crossman

    Hello Skyler,

    I was trying to add Document Numbers in ECN Affected Item relationship. Hence i need to loop them somehow as they can be 1:many. do you know how can i do that?

    -Haider

  • オフライン in reply to hkhan

    Haider,

    I'm having a little trouble picturing the situation, possibly because most of the ECNs I've seen link to Affected Items which connect to Parts. The above query will give you all of the ECN Affected Items. It's closer to a sql select than a javascript loop, if that makes sense. You're just looking for one property of the item the ECN Affected Item points to?

    -Skyler 

Reply
  • オフライン in reply to hkhan

    Haider,

    I'm having a little trouble picturing the situation, possibly because most of the ECNs I've seen link to Affected Items which connect to Parts. The above query will give you all of the ECN Affected Items. It's closer to a sql select than a javascript loop, if that makes sense. You're just looking for one property of the item the ECN Affected Item points to?

    -Skyler 

Children
No Data