Messages

1

Help for ParamQuery Pro / Re: Set color and background-color of selected row

« on: April 13, 2016, 04:48:23 pm »

Perfect.

Thank you

2

Help for ParamQuery Pro / Set color and background-color of selected row

« on: April 12, 2016, 04:57:07 pm »

Hi,

I need a way to change color and background color of selected row; I think I need to change some css class but I don't know what to change and in the forum I couldn't find what I need.

Thanks for help.

3

News / Re: Upgrade to Pro Version 3.3.0

« on: March 17, 2016, 03:49:09 pm »

Ops, I didn't see 

Thank you

4

Help for ParamQuery Pro / Re: Disable multiple row selection

« on: March 16, 2016, 05:43:57 pm »

Done and all right.

Thank you

5

News / Re: Upgrade to Pro Version 3.3.0

« on: March 16, 2016, 04:43:02 pm »

Hi,
I can't find the page to download the new version. I've done the login but I only find the link to download the evaluation copy at http://paramquery.com/pro/download/evaluate
Perhaps I have to fill the form and wait for a link?

Thanks

6

Help for ParamQuery Pro / Disable multiple row selection

« on: March 16, 2016, 04:24:18 pm »

Hi,

if I use

Code: [Select]

selectionModel:{
    type: 'row',
    mode: 'single'
}

multiple record selection is still active using shift + left click.
Is it possible to disable it completely?

Thanks

Full code:

Code: [Select]

       $(function () {
        var data = [
            { rank: 1, company: 'Exxon Mobil', revenues: '339,938.0', profits: '36,130.0' },
            { rank: 2, company: 'Wal-Mart Stores', revenues: '315,654.0', profits: '11,231.0' },
            { rank: 3, company: 'Royal Dutch Shell', revenues: '306,731.0', profits: '25,311.0' },
            { rank: 4, company: 'BP', revenues: '267,600.0', profits: '22,341.0' },
            { rank: 5, company: 'General Motors', revenues: '192,604.0', profits: '-10,567.0' },
            { rank: 6, company: 'Chevron', revenues: '189,481.0', profits: '14,099.0' },
        ];

        var obj = {
            scrollModel: { autoFit: true },
            height: 400,
            editable: false,
            title: "No selections",
            minWidth: 30,
            colModel:
            [
                { title: "Rank", width: 100, dataType: "integer", dataIndx: "rank" },
                { title: "Company", width: 240, dataType: "string", dataIndx: "company" },
                { title: "Revenues ($ millions)", width: 180, dataType: "float", align: "right", dataIndx: "revenues" },
                { title: "Profits ($ millions)", width: 180, dataType: "float", align: "right", dataIndx: "profits" }
            ],
            dataModel: {
                data: data,
                location: "local",
                sorting: "local",
                sortIndx: "profits",
                sortDir: "down"
            },
            selectionModel:{
              type: 'row',
              mode: 'single'
            }
        }

        var $grid = $("#grid_rowhover").pqGrid(obj);

    });



7

Help for ParamQuery Pro / Re: Active cell shown in a thick box

« on: February 17, 2016, 03:50:00 pm »

Fine, thank you.

8

Help for ParamQuery Pro / Active cell shown in a thick box

« on: February 16, 2016, 09:39:19 pm »

Hi,
the active cell of pqgrid is shown in a thick box; how can I change its pq-grid-cell outline width (or other) so you can only see witch row is active but not wich cell? I found how to set editModel option but I have found no thing when cell itsn't in edit mode.

Thanks for help

9

Help for ParamQuery Pro / Re: Error manipulating strings in render function

« on: February 10, 2016, 09:16:00 pm »

Solved

Thank you

10

Help for ParamQuery Pro / Error manipulating strings in render function

« on: February 10, 2016, 08:23:53 pm »

Hi,

I'm looking to render a column output but I get the error "dt is undefined" if I write:

Code: [Select]

render: function( ui ){ var dt = ui.text; return dt.substring(0,8); }
or the error: "ui.text is undefined" if I write:

Code: [Select]

render: function( ui ){ ui.text.substring(0,8); }
but I have no error if I write:

Code: [Select]

render: function( ui ){ ui.text; }or

Code: [Select]

render: function( ui ){ var dt = 'abcd1234567890'; return dt.substring(0,4)+':'+dt.substring(4,8); }
Thank you

Code: [Select]

$(function () {
        var data = [[1, 'Exxon Mobil', '20160219.001', '339,938.0', '36,130.0'],
            [2, 'Wal-Mart Stores', '20160210.002', '315,654.0', '11,231.0'],
[39, 'Royal Dutch Shell', '20160210.001', '306,731.0', '25,311.0'],
[19, 'Crédit Agricole', '20160213.001', '110,764.6', '7,434.3'],
[20, 'American Intl. Group', '20160228.001', '108,905.0', '10,477.0']];

        var obj = {
            scrollModel: {autoFit: true},
            height: 400,
            colModel: [
                { title: "Rank", width: 100, dataType: "integer" },
                { title: "Company", width: 200, dataType: "string"},

// { title: "Date", width: 100, dataType: "string", render: function( ui ){ return ui.rowData[2].substring(0,4); } },
                // { title: "Date", width: 100, dataType: "string", render: function( ui ){ var dtx = ui.rowData[ui.rowData.rowIndx]; return dtx.substring(0,4); } },
                // { title: "Date", width: 100, dataType: "string", render: function( ui ){ return ui.rowData[ui.rowData.rowIndx].substring(0,4); } },
                // { title: "Date", width: 100, dataType: "string", render: function( ui ){ return ui.rowData[ui.rowData.rowIndx].substr(0,4) } }, //ERROR ->

// { title: "Date", width: 100, dataType: "string", render: function( ui ){ var dt = 'abcd1234567890'; return dt.substring(0,4)+':'+dt.substring(4,8); } },
{ title: "Date", width: 100, dataType: "string", render: function( ui ){ var dt = ui.text; return dt.substring(0,4)+':'+dt.substring(4,8); } },

                { title: "Revenues ($ millions)", width: 180, dataType: "float" },
                { title: "Profits ($ millions)", width: 180, dataType: "float" }
            ],
            dataModel: {
                data: data,
                sortIndx: 1,
                sortDir: "up"
            }
        };

        $("#grid_custom_sorting").pqGrid(obj);
    });


11

Help for ParamQuery Pro / Re: Sorting by central europe date format

« on: February 10, 2016, 03:33:19 pm »

Ok, it seems that it's possible using the custom sorting like in http://paramquery.com/pro/demos (Sorting -> Custom Sorting)

Thank you

12

Help for ParamQuery Pro / Re: Sorting by central europe date format

« on: February 10, 2016, 03:21:31 pm »

Thank you, it's a possibility but it seems too complex because it's an application with many date fields that go TO and FROM a database (inserted from manual input) and the dates of the database are used by another application that use the standard European format.

Is it possible to order a column with the values of another hidden column?

13

Help for ParamQuery Pro / Sorting by central europe date format

« on: February 09, 2016, 09:47:19 pm »

Hi,
I have a problem sorting a column with localized Central Europe date format (dd/mm/yyy); I was wrong about something or I need to implement some custom sorting?

Thank you for help.

Code: [Select]

$(function () {
        var data = [
[1, 'Exxon Mobil', '20/02/2015', '339,938.0', '36,130.0'],
            [2, 'Wal-Mart Stores', '01/01/2016', '315,654.0', '11,231.0'],
[3, 'Royal Dutch Shell', '01/12/2015', '306,731.0', '25,311.0'],
[4, 'BP', '20/02/2016', '267,600.0', '22,341.0'],
[5, 'General Motors', '31/12/2016', '192,604.0', '-10,567.0'],
[11, 'ZZZ General Electric', '20/02/2017', '157,153.0', '16,353.0']
]


        var obj = {
            scrollModel: {autoFit: true},
            height: 400,
            colModel: [
                { title: "Rank", width: 100, dataType: "integer" },
                { title: "Company", width: 200 },
                { title: "Date", width: 180, dataType: "date" },
                { title: "Revenues ($ millions)", width: 180, dataType: "float" },
                { title: "Profits ($ millions)", width: 180, dataType: "float" }
            ],
            dataModel: {
                data: data,
                sortIndx: 2,
                sortDir: "up"
            }
        };

$.extend($.paramquery.pqGrid.prototype.options, $.paramquery.pqGrid.regional['it']);
$.extend($.paramquery.pqPager.prototype.options, $.paramquery.pqPager.regional['it']);

        $("#grid_custom_sorting").pqGrid(obj);
    });



14

Help for ParamQuery Pro / Re: Get data of current row in selectChange()

« on: December 21, 2015, 07:00:26 pm »

Thank you

15

Help for ParamQuery Pro / Get data of current row in selectChange()

« on: December 21, 2015, 06:25:40 pm »

I want to read the cells value of current selected row in selectChange() event.

I saw and changed the demo in http://paramquery.com/pro/demos/selection_row but I don't know how to read the id or the company of the current row.

Thank you

Code: [Select]

$(function () {

        var data = [
            { id: 1, company: 'Exxon Mobil', revenues: '339938.0', profits: '36130.0' },
            { id: 2, company: 'Wal-Mart Stores', revenues: '315654.0', profits: '11231.0' },
            { id: 3, company: 'Royal Dutch Shell', revenues: '306731.0', profits: '25311.0' },
            { id: 4, company: 'BP', revenues: '267600.0', profits: '22341.0' },
            { id: 5, company: 'General Motors', revenues: '192604.0', profits: '-10567.0' },
            { id: 6, company: 'Chevron', revenues: '189481.0', profits: '14099.0' },
        ];
        var obj = {
            scrollModel: { autoFit: true },
            height: 200,
showBottom: false,
            resizable: true,
            editable: false,
            numberCell: { show: false },
            selectionModel: { type: 'row', fireSelectChange: true },
            swipeModel: { on: false }
        };
        obj.colModel = [
            { title: "ID", width: 100, dataType: "integer", dataIndx: "id" },
            { title: "Company", width: 200, dataType: "string", dataIndx: "company" },
            { title: "Revenues ($ millions)", width: 150, dataType: "float", align: "right", dataIndx: "revenues" },
            { title: "Profits ($ millions)", width: 150, dataType: "float", align: "right", dataIndx: "profits" }
        ];
        obj.dataModel = {
            data: data
        };

        obj.selectChange = function (evt, ui) {
           alert( this.selection().??????? );

           // $("#select_change_div").html(JSON.stringify(address));
        }
       
        var $grid = $("#grid_row_selection").pqGrid(obj);
    });