Forum Discussion

frank_guarino_murata_com's avatar
frank_guarino_murata_com
Creator III
2 years ago

Query String for Email. Can you perform a JOIN statement with AML?

Two of my tables will always stay separate in terms of relationship, although, one of the tables, Table A, does have table B's ID as a related field.

If I'm using the query string for the Email notifications, this becomes tricky, because the query string is sent specifically as AML only, and moreover as one-time batch of AML. Therefore I must somehow select from Table B, where a Table A record has table B's id.

My other option is to query all of Table B, and then in the Body of the email, use XPath to find the B record who's ID is in the A record.

2 Replies

  • angela's avatar
    angela
    Catalyst II
    2 years ago

    I haven´t fully understand your question, but I would say "yes".

    There are a few common types to connect to tables. Relationships are used most of the time, but property item connections are widespread too.

    Maybe this site contains something helpful?

    gist.github.com/.../38a5e8413c504b2817e2ddf745e11267

    • frank_guarino_murata_com's avatar
      frank_guarino_murata_com
      Creator III
      1 year ago

      Hey so I found out a way.

      The email notification's Query string I had fetch the 1 item I was looking for.

      In the HTML output, XPath querying is possible, even for foreign Item properties, which let me access the Table B's item.