morning, all. i need to filter out child records in my body template that have a non-blank entry in โFinished Dateโ. how do i express filtering for child records in a template?
i presently have:
<<Start: ORDERBY(SELECT(STATE[LOCATION],TRUE),[LOCATION])>>
Name | Surname | Job Title | Phone | |
---|---|---|---|---|
<<Start: ORDERBY(SELECT([Related STAFF LISTs],TRUE),[SURNAME])>><<[Name]>> | <<[Surname]>> | <<[Job Title]>> | <> | <><> |
<>
i want to filter out child fields โFinish Dateโ<>"
thank you for your help
Tryโฆ
<<Start: ORDERBY(SELECT([Related STAFF LISTs],ISNOTBLANK([Finish Date])),[SURNAME])>><<[Name]>>
thanks, Alexi. but [Finish Date] is a column in the child table. the above errs "Error: Workflow rule โPREPARE STAFF LISTโ action โEMAIL STAFF LISTโ Attachment template. Expression โORDERBY(SELECT([Related STAFF LISTs],ISBLANK([Finish Date])),[SURNAME])โ is invalid due to: Unable to find column โFinish Dateโ. "
What column in the parent table is a Ref to the child table that contains the Finished Date column?
hi, Steve.
Parent table is STATE and ref column is LOCATION
child table is STAFF LIST and ref column to parent is also called LOCATION
What table has the Finished Date column?
hi, Steve.
the table STAFF LIST, child of STATE, has [Finish Date]
@Aleksi @Steve thanks for your help so far, guys.
iโm constantly thrown off course by how message exchanges hit this community and / or my gmail address. i think i should stick to the community blogg and ignore gmail messages.
iโve enabled definition access to aleksi.alkio@appsheet.intercom-mail.com (no response). how do i enable for Steve?
today i hit another snag:
<<Start: ORDERBY(SELECT(BIRTHDAYS AND ANNIVERSARIES HQ[LASTFIRST], TRUE),[SURNAME])><<[Name]>>
errs saying:
โError: Report โBIRTHDAYS AND ANNIVERSARIES HQโ action โBIRTHDAYS AND ANNIVERSARIES HQโ Body template. Expression โORDERBY(SELECT(BIRTHDAYS AND ANNIVERSARIES HQ[LASTFIRST], TRUE),[SURNAME])><<[Name]โ is invalid due to: Unable to find column โNameโ. Error: Report โBIRTHDAYS AND ANNIVERSARIES HQโ action โBIRTHDAYS AND ANNIVERSARIES HQโ Body template. Start expression โORDERBY(SELECT(BIRTHDAYS AND ANNIVERSARIES HQ[LASTFIRST], TRUE),[SURNAME])><<[Name]โ should generate a List of Ref values. Please verify that it generates a List and that the contents of the List are Ref values. Ref values should come from the โKeyโ column of the referenced table.โ,
similar to previous request for help. and this is by the โcreateโ option.
help, please?
It sounds that your [LastFirst] column is not a key column. With the Start: expression you always need to use Key column.
hi, @Aleksi.
โBIRTHDAYS AND ANNIVERSARIES HQโ was a slice with All Columns
of โSTAFF LISTโ where [LASTFIRST] is key
to make this one work, i had to make the slice Custom and include the key [LASTFIRST]
thanks for your time.
User | Count |
---|---|
38 | |
35 | |
27 | |
23 | |
18 |