Documentation

The LATEST Automation

The LATEST automation saves the most recent value in a child table up to the parent table. Consider the following YAML definition. In it we have a table of sporting events, and an automated feed is inserting updated scores into a child table.

column score

table games:
    module: sports
    description: Games
    
    # ....various columns here...

    # these two always have the latest
    # score from the child table.
    column score_a:
        suffix: _a
        description: Score Team A
        auto: latest,gamedetails.score_a
    column score_b:
        suffix: _b
        description: Score Team B
        auto: latest,gamedetails.score_b

# As score updates come in over the feed, we insert
# into this table, and the scores are saved up 
# to the game.  This keeps the game updated while
# also preserving a detailed history.
table gamedetails:
    module: sports
    description: Game Details
    
    foreign_key games:
    column score_a:
        suffix: _a
    column score_b:        
        suffix: _b