Create the search-inventory web service operation

The search-inventory operation is an AQL-based Web Service that accepts a text search string and runs an AQL select statement on the MVDEMO INVENTORY file using the DESCRIPTION ADI.

1. Right-click the mvs Web Service from the MV Web Service Explorer and select the Create Web Service Operation option.

   The Create a Web Service Operation dialog box opens.

   
2. Select localserver from the Database Connection drop-down list, and then click Connect to display the list of accounts.
3. Select the MVDEMO account from the Account drop-down, and then click Next.

   The Select a Web Service Operation Type dialog box opens.

   
4. Select the AQL Statement option, and then click Next.

   The Construct the AQL Statement dialog box opens.

   
5. Type search-inventory in the Operation Name text box and select the INVENTORY file from the File Name drop-down list.
6. Select the Selection Criteria tab.
   
7. Click Add to add your selection criteria.
8. Click the top-most cell in the Attribute Name column and select the DESCRIPTION ADI.
9. Click the top-most cell in the Relational Operator column and select the = (equals) operator.
10. Click the top-most cell in the Value column and type @DESC.
    This will generate a variable in the Web Service Operation and its value will be supplied by the client.
11. Click Finish to create the Web Service Operation.