Filter Related Child table in PDF attachment

[Louwrens]

Good day All,

I believe there is a simple solution to this but, I am unable to figure it out.

I have a report that is generated from my Parent Table - Fleet information.
The report is sent when the status of the vehicle in the Fleet information table is changed from Active to Workshop.

I have a child table with vehicle issues that need attention when the vehicle is in the workshop but, I only want to send the incomplete (<> Completed ) issues to the report.
This is the CheckListLog

Hope the request is clear enough.

[Marc_Dillon]

This START expression here is what is controlling which records from the child table are shown in the PDF. START expressions require a list of row key values, so you just need to replace the [Related...] portion with an expression that generates the key values that you want. In your case, something like:

SELECT( child-table[child-table-key-column] , [status] <> "Complete" )

For reference:

help.appsheet.com

Template Start Expressions

Using Start expressions in your workflow templates.

help.appsheet.com

SELECT()

Gather column values from row in table or slice

[Louwrens]

Thanks. The SELECT() is working but, it is not filtering the issues for only the one vehicle but, it is sending a list of all issue which is <> Completed

[Marc_Dillon]

My mistake, I steered you wrong. Instead of

Marc_Dillon:

child-table[child-table-key-column]

You can use List-Dereference on the existing [Related…] column:

[Related...][child-table-key-column]

help.appsheet.com

List Dereference

Dereference the items of a list in bulk to produce a list of the resulting values.

[Louwrens]

This is where I normally get stuck.

'SELECT(Related CheckListLog[Reported Date] , [status] <> “Completed” )

My Reported date is my KEY to the child table CheckListLog

[Marc_Dillon]

[Louwrens]

[Marc_Dillon]

[Louwrens]

If I want to Orderby Days out?

<<Start: ORDERBY(
SELECT([Related CheckListLogs][Reported Date] , [status] <> “Completed” ),[Days Out])>>

Does that look right?

[Marc_Dillon]

Louwrens:

Does that look right?

yes

[Louwrens]

[Marc_Dillon]

Please show the whole template.

[Louwrens]

Thanks so much for the help @Marc_Dillon.

You are a champion

[Louwrens]

[Marc_Dillon]

I don’t see any issue.

Copy the whole START expression, without the “START” and the angle brackets, and paste it into a new virtual column on the Table that you’re triggering the Bot from. Does the expression assistant return any error?

Revert back to the working template, and slowly add the new parts back in.

[Louwrens]

It works when creating a virtual column

I came across a post of other user getting the same issue, or somewhat of the same issue.

Body template. Found 1 unmatched 'End'. They are: <p class="c4"><span class="c7"><<END>></span></p> Questions

Can’t seem to get this workflow to run Report ‘E9 - Renewal Date M-6’ action ‘Remins’ Body template. Found 1 unmatched ‘End’. They are: <<[Valid Until]>><>

[Marc_Dillon · Accepted solution]

In that post it is suggested to remove any line breaks in your expression, which is exactly what I was going to suggest next. You have at least one line break in the expression assistant screenshot that you posted, after “ORDERBY(”.

[Louwrens]

Thanks

[Marc_Dillon]

Removing the line breaks fixed it?

[Louwrens]

Just like that!!!