I am using Faceted Search in Oracle APEX 19 and I am getting this error "Distinct value limit (2000) exceeded for facet NAME." below is the stack trace. Any help is appreciated.
I am not sure how to limit the number of rows in FACETED search in Oracle APEX
Technical Info (only visible for developers)
is_internal_error: true apex_error_code: APEX.FS.FACET_VALUE_LIMIT_EXCEEDED component.type: APEX_APPLICATION_PAGE_REGIONS component.id: 1619304516260125450 component.name: SEARCH error_backtrace: ----- PL/SQL Call Stack ----- object line object handle number name 0x63076c20 1033 package body APEX_190200.WWV_FLOW_ERROR.INTERNAL_GET_ERROR 0x63076c20 1101 package body APEX_190200.WWV_FLOW_ERROR.INTERNAL_ADD_ERROR 0x63076c20 1493 package body APEX_190200.WWV_FLOW_ERROR.RAISE_INTERNAL_ERROR 0x74e491a8 501 package body APEX_190200.WWV_FLOW_FACETED_SEARCH.FACET_VALUE_LIMIT_EXCEEDED 0x74e491a8 1313 package body APEX_190200.WWV_FLOW_FACETED_SEARCH.ADD_LOV_VALUES 0x74e491a8 2255 package body APEX_190200.WWV_FLOW_FACETED_SEARCH.RENDER 0xc15ee6d0 2405 package body APEX_190200.WWV_FLOW_REGION_NATIVE.RENDER_REGION 0xb982da20 2212 package body APEX_190200.WWV_FLOW_PLUGIN.RENDER_REGION 0xc2f9edf8 1422 package body APEX_190200.WWV_FLOW_DISP_PAGE_PLUGS.DISPLAY_PLUG_BODY 0xc2f9edf8 1881 package body APEX_190200.WWV_FLOW_DISP_PAGE_PLUGS.DISPLAY_PLUG 0xc2f9edf8 977 package body APEX_190200.WWV_FLOW_DISP_PAGE_PLUGS.DISPLAY_PAGE_PLUGS 0x9d32ca20 2630 package body APEX_190200.WWV_FLOW_PAGE.EMIT_BODY 0x9d32ca20 2810 package body APEX_190200.WWV_FLOW_PAGE.RENDER 0xc28d4848 4838 package body APEX_190200.WWV_FLOW.SHOW 0xa1846d10 173 procedure APEX_190200.F 0x6c6db8a8 35 anonymous block