Trouble seeing the images? Right click on images and open in new tab to enlarge or zoom in on the page (Ctrl + mousewheel).
In this article we provide information and steps on using defined fields with database functions in VDM.
Why Use Defined Fields?
Defined fields can be used as filter criteria. If users have been set up in WebReports you can apply / do data restrictions based off user defined fields or return the field in the columns to do additional work.
Where Can You Use Defined Fields In VDM?
Defined Fields can be returned in the views data (detail, FR, Visualize, etc.) or as filter criteria in the FSGS.
Steps To Use Defined Fields In VDM (Database functions).
1. Open or create a view in VDM.
2. Right click in the tables and field section and select Add Custom Field/Function.
3. Enter the database function to return the defined field.
IMPORTANT NOTE: The database function will be the query identifier set when adding the defined fields in WebReports. You will also need to add any object identifier around the query identifier. This example uses a string so I will add the single quotes ( ' ) around my query identifier.
4. Enter the name for the defined field column.
5. Make sure the database function is set to your WebReports connection.
6. Click Add to finish creating the database function.
OPTIONAL: Repeat steps 2-6 until you have all the defined fields you want being returned from the database function.
7. Run the view and verify your database functions are returning what you would expect.
NOTE: If they are not correct, verify they are setup properly in WebReports and that the database function was created properly.