Recent Posts

1

Help for ParamQuery Pro / Re: Spreadsheet functionality with table data

« Last post by paramvir on December 16, 2024, 01:59:41 pm »

There is no online example doing the exact thing, but conceptually yes, it's feasible.

Spreadsheet functions are stored in pq_fn property of rowData as shown in this example: https://paramquery.com/pro/demos/excel_formula

you can add extra column in the table to save Spreadsheet formula corresponding to each column expecting a formula.

When data is posted to remote server, extract formula from pq_fn and save in respective columns.

When data is fetched from the server, add pq_fn property ( containing the formulas ) back to the rowData in json data.

2

Help for ParamQuery Grid (free version) / Re: Is there a way format a date column inside the colModel?

« Last post by paramvir on December 16, 2024, 12:12:04 am »

it's simply format: 'mm/dd/yyyy'

3

Help for ParamQuery Grid (free version) / Re: Is there a way format a date column inside the colModel?

« Last post by pbassey on December 15, 2024, 10:18:39 pm »

Below is the format command I used, but it seemed to have no effect to the screen output:

        {
            title: "Date", dataType: "String", dataIndx: "createdDate", editable: false, minWidth: '20%',
            format: function (val) {
                return [ 'mm/dd/yyyy'][val];
            }
        }

Can you tell me what I did wrong?

4

Help for ParamQuery Grid (free version) / Re: Is there a way format a date column inside the colModel?

« Last post by paramvir on December 15, 2024, 06:56:03 am »

Please use column.format property

https://paramquery.com/pro/api#option-column-format

5

Help for ParamQuery Grid (free version) / Is there a way format a date column inside the colModel?

« Last post by pbassey on December 15, 2024, 01:56:42 am »

I have the following colModel definition and I would like the syntax to format the createDate column as mm/dd/yyyy:
    var colModel = [
        { title: "Title", dataType: "string", dataIndx: "title", editable: false, minWidth: '30%', },
        { title: "Content Owner", dataType: "String", dataIndx: "ownerId", editable: false, minWidth: '10%', },
        { title: "Node", dataType: "string", dataIndx: "contentLayout", editable: false, minWidth: '10%', },
        { title: "Type", dataType: "string", dataIndx: "contentType", editable: false, minWidth: '10%', },
        { title: "Status", dataType: "String", dataIndx: "status", editable: false, minWidth: '10%', },
        { title: "Date", dataType: "String", dataIndx: "createdDate", editable: false, minWidth: '20%', }
    ];

6

Help for ParamQuery Grid (free version) / Re: Column with cell wrapping

« Last post by paramvir on December 14, 2024, 11:03:18 pm »

set 'white-space' property to 'normal' in column.style

Reference: https://paramquery.com/pro/demos/wrap

7

Help for ParamQuery Grid (free version) / Re: Column width

« Last post by paramvir on December 14, 2024, 10:58:27 pm »

you also need to set column.minWidth

https://paramquery.com/pro/api#option-column-minWidth

8

Help for ParamQuery Grid (free version) / Column with cell wrapping

« Last post by pbassey on December 14, 2024, 10:58:05 pm »

I am trying to figure out how to have document name field wrap the text inside the cell while sill only being 200px.  How do I do that??  Below is what I have:
    var colModel = [
        {
            title: "Actions", dataType: "string", dataIndx: "ID", editable: false, align: "left", width: 10, wrap: false
            , render: function (ui) {
                var DocId = ui.cellData;
                return "<button type='button' onClick=javascript:getDocuments(" + DocId + ") class='btn btn-primary'><i class='bi bi-file-earmark-pdf' data-bs-toggle='tooltip' data-bs-placement='bottom' title='Click here to download this document.'></i></button>"
                    + "";
            }
        },
        { title: "Document Name", dataType: "String", width: 200, wrap: true, dataIndx: "DocName", editable: false },
        { title: "Resource Category", dataType: "string", dataIndx: "categoryDesc", editable: false },
        { title: "Document Date", dataType: "string", dataIndx: "DocDateTime", editable: false },
        { title: "Document Desc", dataType: "string", dataIndx: "DocDesc", width: 200, editable: false }
    ];

9

Help for ParamQuery Grid (free version) / Column width

« Last post by pbassey on December 14, 2024, 10:55:12 pm »

I am trying to figure out how to set a column to a specific width.  When I use, width: 10, inside the colModel definition, it does not appear to have an effect. Below is what I have in my javascript:

    var colModel = [
        {
            title: "Actions", dataType: "string", dataIndx: "ID", editable: false, align: "left", width: 10, wrap: false
            , render: function (ui) {
                var DocId = ui.cellData;
                return "<button type='button' onClick=javascript:getDocuments(" + DocId + ") class='btn btn-primary'><i class='bi bi-file-earmark-pdf' data-bs-toggle='tooltip' data-bs-placement='bottom' title='Click here to download this document.'></i></button>"
                    + "";
            }
        },
        { title: "Document Name", dataType: "String", width: 500, wrap: true, dataIndx: "DocName", editable: false },
        { title: "Resource Category", dataType: "string", dataIndx: "categoryDesc", editable: false },
        { title: "Document Date", dataType: "string", dataIndx: "DocDateTime", editable: false },
        { title: "Document Desc", dataType: "string", dataIndx: "DocDesc", width: 200, editable: false }
    ];

What can I do to always make the first column 10px long?

10

Help for ParamQuery Pro / Spreadsheet functionality with table data

« Last post by entwine.llc.wi on December 12, 2024, 08:06:40 am »

Is it possible to load data from a database table and then allow users to add/manipulate a custom formula column? If it is possible, can the new formula column be saved as part of the Grid State?