Jump to content

Recommended Posts

Hi all,

When we tried to run a report with h_buz_activities table selected on Service Manager (within Reporting area), using "updated" column to filter out the report, it would not display anything. However if we used "Published" column, it does display data.

Is anyone experiencing similar issue that may be able to assist please?

Cheers,

Claire.

Link to comment
Share on other sites

I'm not sure what you're trying to achieve here, but reporting on this table is not recommended due to the size and complexity of the content, and because the restrictions we have in place to maintain performance will frequently cause reports to return an empty recordset as the query has timed out.

Link to comment
Share on other sites

Morning Steve,

We make use of data warehouse to pull data from Service Manager for PowerBi reporting with success, and use h_buz_activities table to display specific information not easily captured or displayed elsewhere (other tables).

Unfortunately for some unknown reason, in the last few weeks, we were not able to pull data from h_buz_activities, and upon some testing, found that "updated" column no longer show data. This is currently affecting a number of reports which relies on this particular table.

Cheers,

Claire.

Link to comment
Share on other sites

  • 2 months later...

Hi Steve

When we first set up the extract report, we used the Updated column and the Published column to pull rows that had been updated/published today.  This stopped returning rows as I assume that it is now timing out due to the restrictions you have in place.

The preview (limited to 500 rows) shows that the filter criteria does return rows, however when running the report, it results in a Processed [0] records message on completion.

Can you advise how we can extract a daily report for h_buz_activities so that we can load this data into our data warehouse using the goHornbillDataExport tool?

Thanks

Val 

Link to comment
Share on other sites

21 minutes ago, Val C said:

Can you advise how we can extract a daily report for h_buz_activities so that we can load this data into our data warehouse using the goHornbillDataExport tool?

Caveat: Please have this advice checked, because querying SQL isn't really my area, but I would guess that adding a date criteria to the query would achieve this.

As the goHornbillDataExport tool uses a Report, and Reporting has dynamic variables a daily schedule to add updates

BETWEEN {{DATE:startofyesterday}} AND {{DATE:endofyesterday}}

Should add the previous day's data to the existing table in your warehouse, for example.

 

Link to comment
Share on other sites

We have used the dynamic variables, however where including updated used to return rows for the reports, we are now getting zero processed rows, but the data preview shows rows being returned.

Has the Updated column been changed in any way which would explain why the reports isn't processing any records.

To clarify, one day the report was working and the next it wasn't.

Any clarification would be greatly appreciated.

image.thumb.png.f5d9cabf0cbaad2152505736681def0c.png

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...