Skip to main content
Kofax

MarkView Lists Of Values (LOVs) - Long List LOVs Querying All Values

  1. Last updated
  2. Save as PDF
I have a List of Values (LOV) in MarkView It is defined as a Custom Long List, and I am encountering performance issues - e.g. accessing the list is slow, and queries include all values, rather than reducing based on search criteria. 4164
Article # 304619 - Page views: 103

Summary

I have a List of Values (LOV) in MarkView It is defined as a Custom Long List, and I am encountering performance issues - e.g. accessing the list is slow, and queries include all values, rather than reducing based on search criteria. 4164

How do I correct this issue?

This behavior is a known issue with Custom Long List LOVs. Kofax is investigating a software correction.

In the meantime, to workaround this issue, please ensure your LOVs adhere to the following requirements:

  • The Long List LOV must be a Static LOV
  • The LOV query must be under 1900 Characters.
  • The Query cannot use table aliases, for example:
    • select a.col1, b.col2 from table1 a, table2 b where
      • Must be rewritten as:
        select col1, col2 from (select col1 from table1 where...) q1, (select col2 from table2 where...) q2 where

You can modify the LOV using MarkView Administration to meet the requirements.

To make the change, in MarkView Administration :

  1. Select the Lists of Values (LOV) tab.
  2. Click Details next to the LOV you wish to make Static
  3. In the LOV Type drop-down, select Static.
  4. Enter the SQL in the Query field.
  5. Save your changes.

For all systems changes, Kofax Technical Support recommends that you follow the best practices when making the changes, as outlined in the Answer below:

Keywords: 23423