Create a complex dataset for building child tables in a report table via python

I am working on a report for shutdown cause identification. The underlying code works and I can determine the cause of the shutdown based on a few values in tag historian and alarms in the journal. The problem is that I want to use child tables [Table Grouping - Child Table Video at Inductive University] (Table Grouping - Child Table Video at Inductive University) in the report to display all alarms occuring within +3/-1 seconds of a shutdown, but I cannot seem to get the child tables functional.

The documentation (Table Groups - Ignition User Manual 8.1 - Ignition Documentation) says:

Creating child tables requires having a complex dataset. Go to the Nested Queries page and complete the Equipment Downtime example at the bottom if you want to use the same datasets for this example.

My data is spread between the tag historian and the alarm journal, and so requires a bit of formatting, which requires scripting, but I cannot seem to create a complex dataset through scripting. I can create a dataset with a column of datasets, but that isn't treated as a 'complex dataset' in the report designer's key browser. The dataset column is just not treated as a dataset.

If anyone knows how to do this, I would appreciate knowing, too! :slight_smile:

  • Ignition 8.1.26

You should find this thread interesting. Essentially use the DatasetBuilder class to construct your dataset.

3 Likes

I don't know how I didn't find that when I was searching!? LOL!

I'm going to try it...

1 Like

Worked perfectly! Thank you!

And special thanks to @pturmel for the original code!

2 Likes