...
However, in some cases, the marketing department may prefer to simply pick a sub-set subset of records from the base set. In this case, random selection is very useful.
...
- Create a new list view for a service.
- For example, right-click the Persons service and select Create View to open the dialog for a new Persons view.
- This approach can be used to create random selections for any top-level service in Aptify.
- Enter a Name for the view.
- Select List View as the View Type.
- If you want to filter the records based on one or more filter criteria, click the Filters tab.
- For example, you could add a country filter so the view only selects records randomly from those Persons in North American countries.
- For example, you could add a country filter so the view only selects records randomly from those Persons in North American countries.
- Click the Fields tab and specify the set of fields that should appear in the view. You can skip this step if you want to display the default set of fields.
- Click the Paging tab and clear the Enable Paging option to disable paging.
- Click the Advanced (SQL) tab.
- Add the TOP keyword and the number of records to display after SELECT and before the list of fields, as shown below.
- Example 1: To display 50 records, enter TOP 50.
- Example 2: To display 10% of the total records, enter TOP 10 PERCENT.
- At the end of the SQL statement, add an ORDER BY NewID() clause, as shown below.
- Click OK to load the view.
...