- ERP System: All
- MarkView Version: 6.1 and earlier
- 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.
- 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