Using A VDMList

Cory Fifield -

Trouble viewing images? Click on images to enlarge.

 

This article will cover the process of using a list of values inside VDM. A VDMList is a text file that is used to apply to the query.

 

 

If you would like to preview the structure of a VDMList download a sample list below.

Sample ExmployeeID List -Download
Sample OrderDate List - Download
Sample ContactName List - Download

 

Using a VDMList

 

1. Open / Create a View.

 

 

2. Go into the FSGS tab under Query Builder.

mceclip2.png

 

 

3. Add a Field and set the operator you want to use for the filter statement.

mceclip1.png

 

 

4. Click the drop down on the Value and select Add Saved List.

mceclip0.png

 

 

5. Select the list that you wish to use for the values. Confirm the list referenced is present and in the correct format. (Saved Lists will be stored in VDMLists directory for VDM by default)

mceclip3.png

 

 

6. Run the View using the new Filter Statement that leverages a VDMList.

mceclip5.png

 

 

 

Have more questions? Submit a request

Comments