Query report comments for a SAP Business Objects BI instance.

Select

The add-in uses the SAP BusinessObjects BI API to process search criteria that refer to the DocumentId and ReportId columns. The add-in processes other filters client-side within the driver. For example, the following queries are processed server side:

    SELECT * FROM ReportComments
    SELECT * FROM ReportComments WHERE DocumentId=1
    SELECT * FROM ReportComments WHERE DocumentId=1 AND ReportId=3

Insert

The following example illustrates how to insert into the ReportComments table.

    INSERT INTO ReportComments (DocumentId, ReportId, ElementId, Value) VALUES (5486, 1, 258, 'test comment from cdata connector')

Update

The following examples illustrate how to update the ReportComments table.

    UPDATE ReportComments SET Value='updated comment from cdata connector' WHERE DocumentId=5486 AND ReportId=1 AND Id=5 AND ElementId=259
    UPDATE ReportComments SET Value='updated comment from cdata connector' WHERE DocumentId=5486 AND ReportId=1 AND Id=5
    UPDATE ReportComments SET Value='updated comment from cdata connector' WHERE DocumentId=5486 AND ReportId=1

Delete

The following examples illustrate how to delete a row in ReportComments where DocumentId is 5486, ReportId is 1, and ElementId is 259:

    DELETE FROM ReportComments WHERE DocumentId=5486 AND ReportId=1 AND Id=5 AND ElementId=259
    DELETE FROM ReportComments WHERE DocumentId=5486 AND ReportId=1 AND Id=5
    DELETE FROM ReportComments WHERE DocumentId=5486 AND ReportId=1

Columns