Page Comparison

Create a Database Object to hold the SQL you want to execute.

Create a new Service Data Objects record. (The Service Data Objects service is available in the Web Services application.) 

• Name: The name to use when accessing the Service Data Object. Generally this will be identical to the Name of the Database Object used by the Service Data Object.
• To apply Security, select the Enable Security option. If security is enabled then add at least one record on the Security tab.

• Database Object: Enter the Database Object you created in step 1 here.
  
   

Specify which applications can access the object on the Applications tab. 

• This will restrict use of the Service Data Object to a particular Service Application.
  

  Note
  title Applications Filter Required
  Starting with Aptify 5.5.4, you must specify at least one service application.

  
  
  
  
  

• This will restrict the use of the Service Data Object to the chosen Users, Groups, and/or Web Groups. (This is an additional level of restriction on top of the Grant SQL in the Database Object.) 
  

  Note
  Enabling security can result in a reduction in system performance. This is most likely going to be noticed if you have users accessing the system that do not have access to a service data object, and groups are being used.

  
   

If the Database Object (or other SQL) requires parameters, enter each parameter on the Parameters tab. Use the Name of the parameter as it is defined in the SQL.

The Service Data Object is now created. You can call it via Aptify Javascript API or via Aptify SOA.