Adding and Deleting Output Fields For User Defined Function

Right click on User defined function option in Module Section of Project Tree. Select Create Functionl option. OR click on theUser defined function button on the Prescient Author Navigator dialog box.  Click on Add Output Field button.

Following are steps to add output field for the user defined function

1. You can add alias field by selecting Alias Field Check Box.
   • You can specify the name of the aliase field in the Name text box. This name should be same as the name of the alias field in the query.
   • Select the data type for alias field from Data Type combo box..
   • To add alias field as output feld you have to click on Add button. 
2. If you want to add the output field from the table then deselects the Alias Field Check Box.
   • You can select table name from which you want to select field as output field from Table combo box.
   • You have to select the field from Field combo box.
   • Click on Add Button to add selected field as the output field.
   • If you wan to add all fields of the table then click on Add All button.
3. Click on Ok Button.
4. If you want to delete added output field then you can select the field and click on Delete button.

Create User Defined Functions

Examples of Adding output function

Following example shows output field of the 'SelectIssuedBooksForMember_id ' function.