Skip to main content
Kofax

MarkView All Components - In Web Inquiry; toggling between the Basic and Advanced modes; can result in an incorrect result set.

Summary

4156

Applies To

  • ERP System: All
  • MarkView Version: 6.1 and earlier

Behavior

  • In Web Inquiry, toggling between the Basic and Advanced modes, can result in an incorrect result set.
  • This is a known issue (reference SPR00082369) with MarkView Web Inquiry, which is resolved in version 6.1.2 and later.

Resolution

  • The workaround for the issue is to simply enable all advanced mode querying functionality in basic mode, thus removing the need to toggle between modes.
    This can be achieved by running the following update statement in the MarkView schema:
    update mvt_web_display_query_field dqf
        set dqf.include_yn_default = 'Y'
    where dqf.include_yn_default = 'A'
        and dqf.display_type_id =
            (select wdt.display_type_id
                from mvt_web_display_type wdt
            where wdt.display_type_name = 'APINVOICE');
    
    commit;

Keywords: Web Inquiry Basic Advanced 25218