Table Of Contents
Table Of Contents

2024-02-28 - Self Tile Joins

Release

Status: Available

Type: App-Features

Date: 2024-02-28

Problem

Magicians are unable to join a Tile to itself in the Change Rules Step screen because the aliases for the Tile names would be the same and there is no way to refer to the joined tile (with the same name as the driving tile).

Solution

Extended the functionality of the existing “Relationship Multi Table” rule type to handle Tiles being joined on themselves.

Leverage the Magic

You can now use the Rule Step to join a Tile to itself, and the backend will magically deal with the naming so it is valid.

ADI

Nailed it!

I can see this being used for a lot of dirty data use cases.

Customer

Bingo!

Now I can just add the same Tile twice and all that complex SQL code is taken care of without me having to think about it.

Magician Partner

The updated pattern in the “Relationship Multi Table” attribute is:

alias : join conditions : join type
at a minimum this attribute expects a join condition , eg table_a.key = table_b.key
examples:
join condition (existing)
table_a.key = table_b.key
outer join (existing)
table_a.key = table_b.key : left join
aliased join (new)
table_xxx : table_a.key = table_xxx.key
aliased join with with outer join (new)
table_xxx : table_a.key - table_xxx.key : outer
the alias allows the magician to refer to the same source table multiple times in a change rule, because you can alias the second/third etc copy of that table

Last Refreshed

Doc Refreshed: 2024-05-20