How to integrate JQXGrid in oracle apex

[sujayshetMember]

Hi,

I am new to this jqx grid environment.

I need to understand how to integrate JQX Grid in oracle apex, which will dynamically generate query based on oracle query.
What ever examples are shown till now are based on static values.

Does JQX Grid have any plugin which can be downloaded into Oracle APEX and can be used? If yes, then please provide me link to download it.

Any help is appreciated !

Thanks,
Sujay

[Peter StoevKeymaster]

Hi Sujay,

Unfortunately, we do not have such integration plug-in, help tutorials or any samples about that.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[maxandsoftParticipant]

I try it

[maxandsoftParticipant]

[maxandsoftParticipant]

— AP_JSON_TEST
DECLARE
  v_sql VARCHAR2 (4000);
BEGIN
  — Note: This query is meant to return no rows
  v_sql := ‘SELECT ename FROM emp WHERE 1 = 2’;
  �
  — Print JSON result set
  apex_util.json_from_sql (v_sql);
END;

JSON and JQWidgets is friends

[maxandsoftParticipant]

excuse for my Russian

[maxandsoftParticipant]

select parsing in apex_collection

FUNCTION PARSE_FIELDS(p_sql VARCHAR2, p_region_id IN varchar2)
  RETURN CLOB
  IS
    t_cur    PLS_INTEGER;
    t_cols   DBMS_SQL.desc_tab2;
    t_ncols  PLS_INTEGER;
    t_dummy  PLS_INTEGER;
    t_d      DATE;
    t_n      NUMBER;
    t_v      VARCHAR2(32767);
    t_json   CLOB;--VARCHAR2(32767);
    t_object CLOB;--VARCHAR2(32767);
  BEGIN
    t_cur := DBMS_SQL.open_cursor;
    DBMS_SQL.parse(t_cur, p_sql, DBMS_SQL.native);
    DBMS_SQL.describe_columns2(t_cur, t_ncols, t_cols);
    APEX_COLLECTION.CREATE_OR_TRUNCATE_COLLECTION(p_collection_name => p_region_id);
    FOR i IN 1 .. t_ncols
    LOOP
      CASE
        WHEN t_cols(i).col_type IN (2, 100, 101) THEN DBMS_SQL.define_column(t_cur, i, t_n);
          APEX_COLLECTION.ADD_MEMBER(p_collection_name => p_region_id, p_c001 => t_cols(i).col_name, p_c002 => 'number');    
        WHEN t_cols(i).col_type IN (12, 180, 181, 231) THEN DBMS_SQL.define_column(t_cur, i, t_d);
          APEX_COLLECTION.ADD_MEMBER(p_collection_name => p_region_id, p_c001 => t_cols(i).col_name, p_c002 => 'date');   
        ELSE DBMS_SQL.define_column(t_cur, i, t_v, 4000);
          APEX_COLLECTION.ADD_MEMBER(p_collection_name => p_region_id, p_c001 => t_cols(i).col_name, p_c002 => 'string');   
      END CASE;
    END LOOP;
  
    DBMS_SQL.close_cursor(t_cur);
   
    return 'true';
END;

[maxandsoftParticipant]

isn’t present that impossible

[Author]

Posts