Consolidated Queries or Report Timed notification HTML table not working

General question about the package, problems, solutions
rafaelrmontes
Posts: 28
Joined: Thu Jul 18, 2013 5:07 pm

Consolidated Queries or Report Timed notification HTML table not working

Postby rafaelrmontes » Wed Jun 08, 2016 9:00 am

Hello,
I'm using RETURN_QUERY_RESULTS_AS_HTML_TABLE in order to pint the records pre-defined, and when it send the email with the report, it show an empty table with the number of rows of the query, seems like the problem in the code are the methods: count getlabel, etc. do I miss something?
thanks

Pavel
Posts: 281
Joined: Fri Dec 12, 2008 12:19 am

Re: Consolidated Queries or Report Timed notification HTML table not working

Postby Pavel » Wed Jun 08, 2016 9:09 am

Hi,

Do you use valid query path as a parameter?

Thank you,
Pavel

rafaelrmontes
Posts: 28
Joined: Thu Jul 18, 2013 5:07 pm

Re: Consolidated Queries or Report Timed notification HTML table not working

Postby rafaelrmontes » Wed Jun 08, 2016 9:35 am

I have use SQL query that works good in web interface, I ran and it display all information I need.
I'm using ClearQuest 8.0.1.11
this how it looks in the email, like empty records, seems like is detecting the number of rows in the query but not getting the properties, I have print out the count, label and seems like they are not getting values.
but the sql resultset has all information and is working.
see the attached file.
Attachments
problem.png
problem.png (1.15 KiB) Viewed 1211 times

rafaelrmontes
Posts: 28
Joined: Thu Jul 18, 2013 5:07 pm

Re: Consolidated Queries or Report Timed notification HTML table not working

Postby rafaelrmontes » Wed Jun 08, 2016 10:36 am

Pavel,
I have figure out that since SQL query it requires different methods, your code is not for SQL


Return to “Email Notification Package Q&A”

Who is online

Users browsing this forum: No registered users and 1 guest

cron