Query user groups for a SAP Business Objects BI instance.

Select

The following queries are processed server-side:

    SELECT * FROM UserGroups
    SELECT * FROM UserGroups WHERE Name='test'
    SELECT Id, Updated FROM UserGroups WHERE Updated > '2025-02-06T05:06:00.000-05:00'
    SELECT Id, Updated FROM UserGroups WHERE Updated >= '2025-02-06T05:06:00.000-05:00'

Insert

    INSERT INTO UserGroups (Name, Description) VALUES ('testGroup', 'test insert from CData')

Update

    UPDATE UserGroups SET Name='updatedName', Description='test update from CData' WHERE Id=8959
    UPDATE UserGroups SET Name='new updated name2', Description='test update from CData' WHERE Name='test'

Delete

    DELETE FROM UserGroups WHERE Id=8620

Columns