MarkView Lists Of Values (LOVs) - Long List LOVs Querying All Values
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
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
- Must be rewritten as:
- select a.col1, b.col2 from table1 a, table2 b where
You can modify the LOV using MarkView Administration to meet the requirements.
To make the change, in MarkView Administration :
- Select the Lists of Values (LOV) tab.
- Click Details next to the LOV you wish to make Static
- In the LOV Type drop-down, select Static.
- Enter the SQL in the Query field.
- 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