Hornbill Reports Row limit?

[AR001]

Is there a 10,000 row limit per report? Can the limit be set higher/removed?

Alternatively is there a way to pull only changed rows from the Requests and Activities table?

[Steve Giller]

The limit is 25,000 and is controlled by the api.xmlmc.queryExec.maxResultsAllowed setting.

[AR001]

3 hours ago, Steve Giller said:

The limit is 25,000 and is controlled by the api.xmlmc.queryExec.maxResultsAllowed setting.

Steve, thanks for the reply.

Is there a documented way to pull only new and changed rows from the Requests and Activities APIs? (new and changed since the last time the report was run)

If we're pulling all rows each time I'm thinking we will hit the 25k limit as well in a few months

[Steve Giller]

10 minutes ago, AR001 said:

Is there a documented way to pull only new and changed rows from the Requests and Activities APIs? (new and changed since the last time the report was run)

This would be a question for your SQL experts and whether they are able to design an appropriate WHERE clause/filter. Without a detailed breakdown of what you are trying to achieve and what information you are gathering from which tables, and how frequently/regularly you are reporting there simply isn't enough information to begin to comment.

 

[AR001]

35 minutes ago, Steve Giller said:

This would be a question for your SQL experts and whether they are able to design an appropriate WHERE clause/filter. Without a detailed breakdown of what you are trying to achieve and what information you are gathering from which tables, and how frequently/regularly you are reporting there simply isn't enough information to begin to comment.

 

Currently this Report is a basic pull of all data from the Requests API, no other Table Joins, and with no Filters set. (screenshots of this attached)

I have used the Python script available on the Hornbill Power BI Reporting wiki to pull the data from the Report into Power BI. I would want to refresh the data 3-4 times an hour. There will probably be 10 new requests and a few changes to existing requests on each pull. 

I see that there is a h_datelastmodified column on the requests table. My question is around whether this column (or other col(s) ) can be used to pull only new and changed requests? 

Currently I am just pulling the entire Requests dataset to refresh the Power BI dashboard but clearly that will fall over at some point given the 25k row limit.

Any other info that will help please let me know. Thanks.

 

[Steve Giller]

One would assume that if h_datelastmodied > the date of the last report that would signify a change in data for that row.

You would have to be able to track and present the last report date in your script, however.

[AR001]

54 minutes ago, Steve Giller said:

One would assume that if h_datelastmodied > the date of the last report that would signify a change in data for that row.

You would have to be able to track and present the last report date in your script, however.

Does a Report support a parameter value passed to it? Any detail on how to do this?