Email Notification with Table of objects

kklosson

I am trying to configure a notification message that includes a table of objects. It does not appear that the LIST_TABLE function can be used in the notification message initialization. So I created an HTML document with that function included and I declared that document in the HTML Message attribute of the notification. The notification is launched from a list of Investigators, so Investigator is in context.

The HTML document looks like this:

Hello <<Investigator.FirstName>>,

You currently have the following review assignments in POBITS:

Candidate, Purpose, Notes to Reviewer
<<LIST_TABLE('FIND Review WHERE Review.Reviewer=Investigator','CandidateName', 'Purpose', 'NotesToReviewer')>>

The message outputs like this:

Hello <>, You currently have the following review assignments in POBITS: Candidate, Purpose, Notes to Reviewer <>

I can fix the HTML issues but the problem is that nothing populates.

Jaymer

The Doc has to use < and >

kklosson

Thank you, but can you explain that, please?

Jaymer

In the html file, the one that is on the file system, the file get the gets imported as the template,
You cannot use the greater than and less than merge symbols like you do inside aware.
You must use the Html designation

kklosson

Thanks again.

My html doc looks like this:

Hello &lt&ltInvestigator.FirstName&gt&gt, 

You currently have the following review assignments in POBITS: 

&lt&ltLIST_TABLE('FIND Review WHERE Review.Reviewer=Investigator','CandidateName', 'Purpose', 'NotesToReviewer')&gt&gt

My email message looks like this:

Hello &lt&ltInvestigator.FirstName&gt&gt,

You currently have the following review assignments in POBITS:

&lt&ltLIST_TABLE('FIND Review WHERE Review.Reviewer=Investigator','CandidateName', 'Purpose', 'NotesToReviewer')&gt&gt

Jaymer

Hello <<Investigator.FirstName>>,<br><br>

tford

Kingsley,

Try simply placing your code in the Message attribute of the notification.

Hello <<Investigator.FirstName>>,

You currently have the following review assignments in POBITS:

Candidate, Purpose, Notes to Reviewer
<<LIST_TABLE('FIND Review WHERE Review.Reviewer=Investigator','CandidateName', 'Purpose', 'NotesToReviewer')>>

As a test to confirm since I haven't done this in V8.4, I put this in the Initial Value of the Message field of my SystemSettings BO & sent it. Result was table list of BDLs:

Dear <<SystemSettings.EmailAddress>>,

Here is the list you requested:
<<LIST_TABLE (SystemSettings.BDLs, Name, EmailAddress)>>

tford

Note that the ` I used around the attributes are the character below the tilde on the keyboard.

kklosson

Thanks, Tom.

I've tied putting in the message and in an HTML document. The <<Investigator.FirtName>> prints out fine either way. No matter how I do the LIST_TABLE, no good. It either prints the whole command string (when in the HTML document) or nothing at all (when in the message block).

Does anyone see anything wrong with my LIST_TABLE construct?

kklosson

Good call on the apostrophes; I always forget that. But still no joy. Here's the exact text in the HTML document:

Hello <<Investigator.FirstName>>,

You currently have the following review assignments in POBITS:

<<LIST_TABLE(FIND ALL Review,CandidateName,Purpose,NotesToReviewer)>>

Here's what I get:

Hello James,

You currently have the following review assignments in POBITS:

The LIST_TABLE function is simply ignored.

kklosson

I have also tried changing the query string in the function to call a query i.e.,

<<LIST_TABLE(InvestigatorOpenReviews,CandidateName,Purpose,NotesToReviewer)>>

What is the significance that the query in the documentation example is not quoted?
<<LIST_TABLE(Client.Children, ‘FirstName’, ‘LastName’, ‘Age,#’)>>

I also do not know what Client.Children might represent in database terms.

tford

Client.Children ...

Client is a BO with a reference attribute named Children. Children would be a Multiple Allowed reference.

kklosson

Tried that i.e., Investigator.Review, no joy.

tford

You can put a query name in the first parameter like this:

<<LIST_TABLE (A_BDL_Query,Name,EmailAddress)>>

That's the syntax I suggest because you can run the query independently to ensure it delivers the intended results before trying to put those results in an email.

hpl123

What Tom said 🙂.

Weird things happens with the LIST functions when trying to build the query/parameters in the tag so try that.

tford

I always feel better when Henrik agrees 8-)

kklosson

I did. 🙁

Jaymer

It’s unfortunate that dicking around with this takes up so much time.

aware_support

Check out the output of the Aware IM Server after you run the function - there must be some clues there.

kklosson

All of the logs indicate everything happened without a hitch. I see no errors or problems.