Search in a Calculation Matrix (Managed Package)

For the managed package runtime, you can search for specific values in a calculation matrix that has many rows.

1. Find the column or columns for which you want to restrict values.
2. Enter the value you're looking for into the field next to the magnifying glass.
   

   Note

   Don't use wildcards when you search in a matrix. Use exact values.

3. Click the Search button above the columns.

   Vlocity displays the matrix rows containing the specified value in the selected column.

4. If your search returns no results, note the following:

   • By default, Vlocity returns only the first 2000 results of your search.

   • For multi-column searches, Vlocity searches one column at a time, in order.

     You can enter search parameters into multiple columns and click Search. Vlocity searches the first column, then uses the second parameter to search the results from the first column.

5. To improve search results:

   • Set the General Setting CalculationMatrixRowPrettify = true (if it's set to false).

     1. To set this setting, go to Setup | Custom Settings | General Settings | Manage.

     2. Either add the setting manually, or if it exists already, edit it.

   • For calculation matrices created before the Summer '19 release, click the Update JSON button before you search.