How to find out that an alerter had worked?

[former_member395301]

Hi everyone!

How to find out that an alerter had worked via RESTful Web Services?

I looked through some links:

.../documents/documentId/alerters

.../documents/documentId/alerters/alerterId

but there aren't needed tags.

We use BO 4.1 SP 6

Regards, Uladzislau

[former_member395301 · Accepted solution]

Is there any sign in the state of document that indicates, that the alerter's (formatting rule's) condition is fulfilled and cells' formatting must be changed?

I also tried the following URL without accept header ".../documents/documentId/" as most full and detailed description of a document but there is no sign of alerter either.

E.g.:

<document unit="pixel">

<media>

<property name="mode.selected">

normal

</property>

<property name="mode.web.page.extra-padding-bottom">

1000

</property>

<property name="mode.web.page.extra-padding-right">

1000

</property>

<property name="mode.web.page.min-height">

38400

</property>

<property name="mode.web.page.min-width">

48000

</property>

<property name="output.dpi">

96

</property>

<property name="output.format.xls.optimised">

yes

</property>

<property name="output.format.xml.valuemode">

no

</property>

<property name="output.limit.size">

15360

</property>

<property name="output.selected">

xml.ro

</property>

<property name="output.unit">

pixel

</property>

<property name="page.records.horizontal.limit">

1000

</property>

<property name="page.records.vertical.limit">

1000

</property>

<property name="xelement.xml.object">

yes

</property>

</media>

<report rid="1">

<styledict>

<style sid="-11">

<font face="Arial" size="12" rgb="#333333" bold="false" italic="false" strike="false" underline="false" wraptext="false" orientation="normal" />

<border side="all" rgb="#ebebeb" thick="1" style="plain" />

<background rgb="#f8fbfc" />

<valign value="bottom" />

<halign value="right" />

</style>

<style sid="-10">

<font face="Arial" size="12" rgb="#333333" bold="false" italic="false" strike="false" underline="false" wraptext="false" orientation="normal" />

<border side="all" rgb="#ebebeb" thick="1" style="plain" />

<background rgb="#f8fbfc" />

<valign value="bottom" />

<halign value="right" />

</style>

<style sid="-9">

<font face="Arial" size="12" rgb="#333333" bold="false" italic="false" strike="false" underline="false" wraptext="false" orientation="normal" />

<border side="all" rgb="#ebebeb" thick="1" style="plain" />

<background rgb="#f8fbfc" />

<valign value="bottom" />

<halign value="left" />

</style>

<style sid="-8">

<font face="Arial" size="12" rgb="#333333" bold="false" italic="false" strike="false" underline="false" wraptext="false" orientation="normal" />

<border side="all" rgb="#ebebeb" thick="1" style="plain" />

<background rgb="#f8fbfc" />

<valign value="bottom" />

<halign value="left" />

</style>

<style sid="-7">

<font face="Arial" size="12" rgb="#ffffff" bold="true" italic="false" strike="false" underline="false" wraptext="false" orientation="normal" />

<border side="left" rgb="#3877a6" thick="1" style="plain" />

<border side="right" rgb="#3877a6" thick="1" style="plain" />

<border side="top" rgb="#3877a6" thick="1" style="plain" />

<border side="bottom" rgb="#a5a5b1" thick="1" style="plain" />

<background url="boimg://TopHeaderBlue.png" type="htile" halign="left" valign="top" innerwidth="0" innerheight="0" rgb="#0b64a0" />

<valign value="bottom" />

<halign value="left" />

</style>

<style sid="-6">

<font face="Arial" size="12" rgb="#ffffff" bold="true" italic="false" strike="false" underline="false" wraptext="false" orientation="normal" />

<border side="left" rgb="#3877a6" thick="1" style="plain" />

<border side="right" rgb="#3877a6" thick="1" style="plain" />

<border side="top" rgb="#3877a6" thick="1" style="plain" />

<border side="bottom" rgb="#a5a5b1" thick="1" style="plain" />

<background url="boimg://TopHeaderBlue.png" type="htile" halign="left" valign="top" innerwidth="0" innerheight="0" rgb="#0b64a0" />

<valign value="bottom" />

<halign value="left" />

</style>

<style sid="-5">

<font face="Arial" size="12" rgb="#ffffff" bold="true" italic="false" strike="false" underline="false" wraptext="false" orientation="normal" />

<border side="left" rgb="#3877a6" thick="1" style="plain" />

<border side="right" rgb="#3877a6" thick="1" style="plain" />

<border side="top" rgb="#3877a6" thick="1" style="plain" />

<border side="bottom" rgb="#a5a5b1" thick="1" style="plain" />

<background url="boimg://TopHeaderBlue.png" type="htile" halign="left" valign="top" innerwidth="0" innerheight="0" rgb="#0b64a0" />

<valign value="bottom" />

<halign value="left" />

</style>

<style sid="-4">

<font face="Arial" size="12" rgb="#ffffff" bold="true" italic="false" strike="false" underline="false" wraptext="false" orientation="normal" />

<border side="left" rgb="#3877a6" thick="1" style="plain" />

<border side="right" rgb="#3877a6" thick="1" style="plain" />

<border side="top" rgb="#3877a6" thick="1" style="plain" />

<border side="bottom" rgb="#a5a5b1" thick="1" style="plain" />

<background url="boimg://TopHeaderBlue.png" type="htile" halign="left" valign="top" innerwidth="0" innerheight="0" rgb="#0b64a0" />

<valign value="bottom" />

<halign value="left" />

</style>

<style sid="-3">

<font face="Arial" size="13" rgb="#333333" bold="false" italic="false" strike="false" underline="false" wraptext="false" orientation="normal" />

<border side="all" rgb="#000000" thick="0" />

<valign value="bottom" />

<halign value="left" />

</style>

<style sid="-2">

<font face="Arial" size="12" rgb="#333333" bold="false" italic="false" strike="false" underline="false" wraptext="false" orientation="normal" />

<border side="all" rgb="#000000" thick="0" />

<background rgb="#ffffff" />

<valign value="bottom" />

<halign value="left" />

</style>

<style sid="-1">

<font face="Arial" size="12" rgb="#333333" bold="false" italic="false" strike="false" underline="false" wraptext="false" orientation="normal" />

<border side="all" rgb="#000000" thick="0" />

<hlinkcolor state="active" rgb="#000000" />

<hlinkcolor state="hover" rgb="#000000" />

<hlinkcolor state="link" rgb="#0000ff" />

<hlinkcolor state="visited" rgb="#000000" />

<valign value="bottom" />

<halign value="left" />

</style>

</styledict>

<page sid="-1" num="1" px="1" lastpx="true" py="1" lastpy="true" format="normal" h="159" w="623" lastpage="true">

<page_element type="body" ref="1.2" bid="2" h="159" w="623" sid="-2" rinfo="0:0;1:121;" cinfo="0:0;1:585;">

<block-infos>

<pval name="hier-sign-size">

13

</pval>

</block-infos>

<table class="vtable" ref="1.G" bid="16" x="59" y="75" h="46" w="526" sid="-3" nbrow="2" nbcol="4">

<cband w="526" bg="0" ed="3" oc="0" />

<rband fold="false" hd="1" hdh="31" h="46" bg="0" ed="1" oc="0" />

<freezeinfos freeze_vertical_header="false" freeze_horizontal_header="false" freeze_column_number="0" freeze_row_number="0" />

<col x="0" w="137" c="0" />

<col x="137" w="124" c="1" />

<col x="261" w="122" c="2" />

<col x="383" w="143" c="3" />

<tr h="31" y="0" r="0" type="header">

<td c="0">

<cell ref="1.A" bid="10" h="31" w="137" pad="8,7,9,7" sid="-4">

<ct>

Customer region

</ct>

</cell>

</td>

<td c="1">

<cell ref="1.B" bid="11" h="31" w="124" pad="8,7,9,7" sid="-5">

<ct>

Customer city

</ct>

</cell>

</td>

<td c="2">

<cell ref="1.C" bid="12" h="31" w="122" pad="8,7,9,7" sid="-6">

<ct>

Fact revenue

</ct>

</cell>

</td>

<td c="3">

<cell ref="1.D" bid="13" h="31" w="143" pad="8,7,9,7" sid="-7">

<ct>

Number of sales

</ct>

</cell>

</td>

</tr>

<tr h="15" y="31" r="1">

<td c="0">

<cell ref="1.5.0" bid="5" h="15" w="137" pad="6,7" sid="-8" />

</td>

<td c="1">

<cell ref="1.6.0" bid="6" h="15" w="124" pad="6,7" sid="-9" />

</td>

<td c="2">

<cell ref="1.7.0" bid="7" h="15" w="122" pad="6,7" sid="-10" />

</td>

<td c="3">

<cell ref="1.8.0" bid="8" h="15" w="143" pad="6,7" sid="-11" />

</td>

</tr>

</table>

</page_element>

</page>

</report>

</document>

[daniel_paulsen · Accepted solution]

There's no way to determine if an alerter has been triggered.  You can get the details of an alerter and you can figure out if a cell is associated to an alerter, but you can't tell if the conditional formatting of a cell has been applied using the REST APIs.

Dan

[former_member395301 · Accepted solution]

Thanks for your answer, Dan!

Maybe you know if it's possible to see such APIs in future versions?

Regards,

Uladzislau

[daniel_paulsen · Accepted solution]

The best way to have this looked at for future consideration is to post it on ideaplace.  This will ensure that our Product Management sees it and others can vote for it as well.

SAP BusinessObjects BI Platform: Ideas

Dan

[former_member395301]

If you are interested in the solution, please vote for the idea on ideas.sap.com:

No REST API to determine if an alerter (conditional formatting) has been triggered for WebI docs : V...