KACE Product Support

Hi guys,

I am trying to update an "update field" in a series of reports, using a ticket rule. 

This is the "SMARTY_REPORT" database and the one that has all the reports.

so an example would be...

UPDATE SMARTY_REPORT 

set QUERY = 

"

select

  "Cost Account:" as 'Item'

  ,COST_ACCOUNT_ASSET.NAME as 'Type'

  ,concat("Department: ", COST_ACCOUNT_ASSET_DATA.FIELD_10025) as 'ID'

  ,concat("Site: ", COST_ACCOUNT_ASSET_DATA.FIELD_10026) as 'Assigned User'

  ,"" as 'Unit Cost'

  ,null as 'ASSET_NAME'

  ,null as 'SORT_ORDER'

  ,COST_ACCOUNT_ASSET.NAME as 'COST_ACCOUNT'

  ,-1 as 'SECTION_ORDER'

from

  ASSET COST_ACCOUNT_ASSET

"

My problem is that I can't seem to make the ticket rule work because.... (I'm assuming), it's because

of all the quotes in the query. I have wrapped the entire query in my very own quotes of course.

So it seems there is a clash of quotes.

So basically I am trying to use an "update query" to add a "Query" to a database table.

Has anyone tried this before? Any ideas?

Thanks