Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - resolvecomputing

Pages: [1] 2 3
1
Help for ParamQuery Pro / Filter by JSON data
« on: April 16, 2019, 04:33:58 pm »
Hi team,
when i get data from database have column type is Json, it save object like this
{
 name: "john",
age: 20
}

i can query and display with postgres and paramquery, but when i filter on it, is always return value is undefined

help me , please!
Thanks!

2
Help for ParamQuery Pro / Re: Error when upgrade new version
« on: October 24, 2018, 01:27:02 pm »
It's woked,thanks!

3
Help for ParamQuery Pro / Error when upgrade new version
« on: October 24, 2018, 01:13:00 pm »
I have tried update new version, but after I updated it's have some problems in attachment file.
- Don't show page to page input
- groupModel placeholder show Undefined and when don't have data also.

4
Help for ParamQuery Pro / Compare or Check what is cell change
« on: October 02, 2018, 03:59:59 pm »
I example, I have 5 rows, and I have changed 1 of 5 rows. So how can I kno, what row and cell I just change and update status to hidden attribute, because I free User edit, don't have confirm or update button.

5
Help for ParamQuery Pro / Init checkbox
« on: September 26, 2018, 04:33:01 pm »
In the edit screen i have init some checkbox is checked in the pqGrid. Can you tell me the way to do that.
the image below i want to set checked for checkbox is same checkbox in the under grid.

Thanks!

6
Help for ParamQuery Pro / Re: Multiple select value in row
« on: September 26, 2018, 02:58:37 pm »
It's working now, thanks!

7
Help for ParamQuery Pro / Re: Multiple select value in row
« on: September 25, 2018, 04:46:57 pm »
I changed but selected value still gone.

8
Help for ParamQuery Pro / Multiple select value in row
« on: September 25, 2018, 04:09:59 pm »
I have 1 case with multiple select in row, and I tried create model for that Column like below:
Code: [Select]
{ title: tran('users'), dataType: "html", dataIndx: "users",
                    editor: {
                        type: "select",
                        attr: "multiple",
                        valueIndx: "user_name",
                        labelIndx: "user_name",
                        options: function() {
                            return usersList
                        },
                        listeners: 'change',
                        init: function(ui) {
                            ui.$editor.pqSelect({
                                bootstrap: { on: true } ,
                                checkbox: true,
                                radio: true,
                            });
                        }
                    }
                },
And it's working for choosing, but after I choose and comeback, selected value gone.
Can you help me, thanks!

9
Help for ParamQuery Pro / Re: Display with vietnamese not correctly
« on: June 06, 2018, 01:31:19 pm »
It's working, thanks!

10
Help for ParamQuery Pro / Display with vietnamese not correctly
« on: June 05, 2018, 04:07:50 pm »
When I try display data with Vietnamese, I example with text: "Võ Ngọc Nhật".
I have tried with free version, it's ok, but with pro version it's display not correctly.
Please check for me.

11
Help for ParamQuery Pro / Do pivot with bigdata?
« on: May 09, 2018, 04:58:40 pm »
If I do pivot with more than 3 million record, the paramquery posible do that?

12
1. the ClHeight is available calculate screen's height.
2. I found the reason why it's slow, When i try to render with small data, it works well. But when i try with big data and setting "checkbox: true" or do some condition with checkbox function, it becomes hanging. Can you try simple treeGrid with big JSON which have more than 2000 objects and setting "checkbox : true" then see what is result. I don't know how checkbox function works.

Thanks!

13
Now i using ParamQuery 5
This is my setting.Can you check and tell me something wrong. Thanks!

            height: 'flex',
            height: ClHeight,
            resizable: false,
            virtualX: true, virtualY: true,
            title: tran('adjustment'),
            rowBorders: false,
            rowHt: 20,
            toggle: function( event, ui ) {
                if (ui.state == 'max') {
                    $('#'+ event.target.id).css('top', '34px');
                }
            },
            filterModel: {
                on: true,
                mode: "AND",
                header: true
            },
            swipeModel: {
                on: 'touch'
            },
            treeModel: {
                dataIndx: 'chart_of_account_name',
                chk_dataIndx: 'state',
                cascade: true,           
                checkbox: function(rd) {
                    return !(rd.variance == undefined) &&  !(rd.variance == 0);
                },

                render: function (ui) {
                    if (ui.rowData.variance == undefined) {
                        var checked = ui.rowData.state?"checked":"";
                        return {
                            text: "<input type='checkbox' checked " + checked +" disabled style='width:18px;'/>" + ui.rowData.chart_of_account_name
                        };
                    } else if(ui.rowData.variance == 0) {
                        return {
                            text: "<input type='checkbox' checked "+ checked +" disabled style='width:18px;'/>" + ui.rowData.chart_of_account_name
                        };
                    }
                }
            },
            sortModel: {
                ignoreCase: true
            },
            scrollModel: {
                autoFit: true
            },
            colModel: [{
                dataIndx: 'chart_of_account_name',
                title: dbtran('chart_of_account_name'),
                exportRender: true,
                filter: {
                    type: 'textbox',
                    attr: 'autocomplete="off"',
                    condition: "contain",
                    listener: 'keyup'
                },
                editable: false
            },
            {
                dataIndx: 'chart_of_account_code',
                title: dbtran('chart_of_account_code'),
                align: 'center',
                filter: {
                    type: 'textbox',
                    attr: 'autocomplete="off"',
                    condition: "contain",
                    listener: 'keyup'
                },
                maxWidth: 150,
                width: 150,
                editable: false
            },{
                dataIndx: 'currency_iso',
                title: dbtran('currency_iso'),
                align: 'center',
                maxWidth: 60,
                width: 60,
                editable: false
            }, {
                dataIndx: 'calculate_ledger_balance',
                title: dbtran('calculate_ledger_balance'),
                dataType: 'float',
                format: '#,###.00',
                maxWidth: 150,
                width: 100,
                align: 'right',
                editable: false,
                summary: {
                    type: "sum"
                }
            }, {
                dataIndx: 'closing_balance',
                title: dbtran('closing_balance'),
                dataType: 'float',
                format: '#,###.00',
                maxWidth: 150,
                width: 100,
                align: 'right',
                editable: false,
                summary: {
                    type: "sum"
                },
                render: function (ui) {
                   // if (ui.rowData.ledger_balance != undefined && ui.rowData.ledger_balance.length > 0) {
                       return {closing_balance: 1000};
                   // }
                }
            }, {
                dataIndx: 'variance',
                title: dbtran('variance'),
                dataType: 'float',
                format: '#,###.00',
                maxWidth: 150,
                width: 100,
                align: 'right',
                editable: false,
                summary: {
                    type: "sum"
                }
            }],

            dataModel: {
                location: "remote",
                dataType: "JSON",
                method: "GET",
                url: "/adjustments/chartofaccounts?report_date=" + reportDate,
                getData: function (res) {
                    return {data: res};
                }
            },
            groupModel: groupModel

14
I am developing a screen using gridview, the query returned the results as JSON in few microseconds but loading into the grid takes a long time. The table that is being queried has around 2500 rows. What could be the possible reason for such behavior?



15
Help for ParamQuery Pro / Re: Multiple filter in pivot
« on: April 24, 2018, 12:38:01 pm »
Do paramquery have change event in pgSelect?

Pages: [1] 2 3