What does BR PA Cache buster exactly do

[Jacques Clement]

Hi,

Does anyone know what the business rule PA Cache buster exactly does? It runs on all operations against pa_scores_l1 table.

I am wondering whether it's safe to use setWorkflow(false) when manually inserting scores in pa_scores_l1 for manual indicators. I'm thinking that when adding multiple scores in a loop, I might not want this BR to always run.

The BR has only one line

SNC.PAScore.updateIndicatorScoreModifiedAtOn1stLevelTable(current.indicator); 

But I don't have access to the inside of this method. From the name it looks like it updates the aggregated score when a breakdown element score has been touched, but it's just my guessing.

Any intel?

[Kelly Logan]

Bumping. I'm curious as well.

[Kelly Logan]

Bump 2. Anyone?!?

[jeffrubinoff]

The only one I can think of who might know is @Adam Stout 

[Adam Stout · Accepted solution]

1) Inserting scores directly is a bit risky as it is undocumented and there is no API.

2) If you are going to do it, I would disable workflows and then bust the cache.  You do not want that running on every insert due to performance but you do need to ensure the cache is cleared (with the cache buster) after your inserts are complete.

Generally, I just put my data in a table and then run a normal automated collector on them, so I don't need to mess with the actual inserting of the data into the scores tables.