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 ...
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.