Connect Commune and Oracle Database

Both apps 30Commune 18Oracle Database 12

• Trigger
  Comment Edited

  Triggers when a comment is edited after it was posted.

• Trigger
  Comment Moderated

  Triggers when a comment is moderated to "Show to Poster/Admin only" visibility in your Commune community.

• Trigger
  New Attendee

  Triggers when a new attendee registers for the selected Commune event.

• Trigger
  New Comment

  Triggers when a new comment is posted in your Commune community, optionally limited to one post, commenter, box or category.

• Trigger
  New Event Created

  Triggers when a new event is created in your Commune community.

• Trigger
  New Post

  Triggers when a new post is created in your Commune community.

• Trigger
  New User

  Triggers when a new user joins your Commune community.

• Trigger
  User Account Deactivation

  Triggers when a community member's account is deactivated (the user resigns or is removed).

• Trigger
  User Added to Group

  Triggers when a user is added to the selected Commune group.

• Action
  Create Group

  Creates a new group in your Commmune community.

• Action
  Create Post

  Creates a new post in a Commune box and category, authored as the chosen user.

• Action
  Deactivate User’s Account

  Deactivates (removes) one or more user accounts from your Commune community.

• Action
  Find User

  Finds community users by email address, optionally narrowed by creation date, resigned status or admin role. Returns the matching users and the first match.

• Action
  Generate Invitation Link

  Creates member invitation links for one or more email addresses in your Commune community.

• Action
  Give Badge

  Gives a badge to a community member. Only badges in the "Specific users" category can be given.

• Action
  Give Points

  Adds points to one or more community members. By default the points count toward both their total earned and available points.

• Action
  Remove User From Group

  Removes one or more users from a group. Any badge tied to that group is removed from those users too.

• Action
  Send Direct Message

  Sends a direct message from the community admin to a user.

• Trigger
  New Column

  Fires when a new column appears on an Oracle table you choose.

• Trigger
  New or Updated Row

  Triggers when a new row is added or modified.

• Trigger
  New or Updated Row (Custom Query)

  Fires for each new or changed row returned by a SELECT statement you write against the connected Oracle database.

• Trigger
  New Row

  Triggers when you add a new row.

• Trigger
  New Table

  Fires when a new table appears in the connected Oracle user's own schema.

• Action
  Add Row

  Add one row to a table on the connected Oracle database.

• Action
  Delete Row

  Delete the rows in a table whose chosen column equals a value.

• Action
  Find Row

  Find the first row in a table whose chosen column matches a value.

• Action
  Find Rows via Custom Query

  Runs a SELECT statement you write against the connected Oracle database and returns every row it matches.

• Action
  Find Row via Custom Query

  Runs a SELECT statement you write against the connected Oracle database and returns the first row it matches.

• Action
  Run Custom Statement

  Runs a statement you write against the connected Oracle database that changes data rather than returning rows, and reports how many rows it changed.

• Action
  Update Row

  Change column values on every row of a table whose chosen column matches a value.

No trigger or action matches that. Ask your agent to add it: it reads the API documentation and builds what you describe.