Messages

1

Help for ParamQuery Pro / Angular JS custom editor demo 404 error

« on: February 21, 2017, 12:10:01 am »

I'm not sure if this is the best place to post this, but the http://angularjsgrid.com/pro/demos/custom-editor example is getting error:

http://angularjsgrid.com/pro/content/invoice.json?pq_datatype=JSON&_=1487615468117 Failed to load resource: the server responded with a status of 404 (Not Found)
pqgrid.min.js:138 Uncaught Error : Not Found

Looking forward to seeing this example in action.
Thank you

2

Suggest new features / Expand all/collapse all options on grouping toolmenu

« on: January 03, 2017, 09:40:22 pm »

The grouping features added in 3.3 release are great.

The call out option menu that includes options for Merge cells, Fix columns, and Grand summary could be enhanced by including options to "Expand all" groups and also "Collapse all" groups.  I think they may work as check box options also in that once they are checked they trigger that behavior (in other words they always appear unchecked on the menu).

This may seem like a small enhancement, but when you have 4 levels of grouping or many groups, it is helpful.

3

Help for ParamQuery Pro / Re: Initial range filter values based on min and max column/dataIndx value

« on: December 16, 2016, 09:54:38 pm »

Awesome thank you.  Wanted to make you aware that you have minDatE and maxDatA in the code - just something to be aware of with your variable names.

Also, I ended up implementing this after the grid gets defined so that I could show the initial values.

Code: [Select]

               
                var column = grid.getColumn({dataIndx: 2});
                var filter = column.filter;
               
                //get minimum and maximum dates in Order Date column.
                var arr = grid.option('dataModel.data').map(function(rd){
                    return rd[2];
                });
             
                var minDate = pq.aggregate.min(arr, column),
                    maxDate = pq.aggregate.max(arr, column);
                //set default From date
                filter.value = minDate;
                filter.value2 = maxDate;

Thank you sir!

4

Help for ParamQuery Pro / Initial range filter values based on min and max column/dataIndx value

« on: December 16, 2016, 03:00:33 am »

I can set the initial date range filter using value & value2.

Is it possible to set the initial date range filter values based on the min and max value of the associated dataIndx/column values?  I don't necessarily need to apply the filter because it is inclusive of all results (already), but I just want to make it convenient for user to see the range of values and to initialize the pqdatePicker.

I've tried to initialize with getData like I would a pqSelect, but not sure how to get a min/max value on that subset.

With this in mind, this may be consideration for adding helper methods like getColMinValue/getColMaxValue(dataIndx).

5

Suggest new features / Classic Office template

« on: December 12, 2016, 09:27:24 pm »

Please consider bringing back the "Office" theme in v3.2 as "Classic" (just a suggestion on the name) in future 3.3 versions.

6

Suggest new features / Automatically generate create record form

« on: September 29, 2016, 10:17:25 pm »

Check out http://jtable.org/GettingStarted#CreateAction or http://jtable.org/Demo/PagingAndSorting (Add New Record buttom).

JTable dynamically generates a form (with some validation and modal pop-up) from from their column model for creating a new record.

Whats the difference between this and just entering a new record into a table?  One scenario is there may be fields in the colModel that are not visible by default, but need a required value.  JTable demonstrate this in their demo.  Another, for mobile device this is easier data entry.  And, its easier to tab through fields for fast data entry.

Also, you could improve this model by extending the pqGrid colModel to include an optional "tip" property.  This would allow you to include a help tip for how the field/value is used within this data entry form.  The use/case for that would be more of a CRUD model to support db table maintenance.   You could also display the tip in the grid header row - but I think the tip should not be limited in length to support this use/case..

Just something to consider - thanks

7

Help for ParamQuery Pro / grouped column header don't show when unhide columns

« on: March 10, 2016, 03:57:28 am »

I have a grid with column groups like:
http://paramquery.com/pro/demos/group_columns

I also have a toolbar with widget to hide/unhide columns like:
http://paramquery.com/pro/demos/showhide_columns

It seems that if I unhide a column that is default hidden (default hidden: true in column), the column will show but the column grouping doesn't reflect column model for the grouped column. 
Is there anyway to refresh the columnModel or header.

I tried refereshHeader on the show/hide column change listener.

8

Help for ParamQuery Pro / colModel "tag" property

« on: February 12, 2016, 08:06:49 pm »

This is just a suggestion: it would be nice to have a "tag" property on the colModel (or something like it).  This would be a property that could contain any value and would allow the developer to classify columns in the colModel.

For example, you may want a standard view and extended view(s).  You could tag your View columns for each and hide the extended view by default and also hide them from the drop down column select (in the case of show/hide) demo.  Developer could setup postData to render request full or partial view and colModel could adapt appropriately. 

I know there are ways around this, but it just idea for future enhancement.
Thanks

9

Help for ParamQuery Pro / Re: tooltip property for detailModel

« on: February 10, 2016, 09:41:28 pm »

Very good - thank you!

10

Help for ParamQuery Pro / tooltip property for detailModel

« on: February 10, 2016, 12:01:36 am »

This is just a suggestion for future perhaps.

I followed topic Hide detailModel if it's empty
http://paramquery.com/forum/index.php?topic=917.msg4605#msg4605

This works perfectly for my use case.

It would be great to be able to set a tool tip on the detail column like to setting the icons.
You would only want to show the tip if the detail was collapsed.

For example "Expand to show order details"

11

Help for ParamQuery Pro / colModel of detailModel

« on: February 09, 2016, 11:53:30 pm »

Is is possible to change the column model of detailModel (for new detailModel views). 

My (nested) detailModel's colModel is the same as my main grid colModel (one column model definition used for both).  I would like to show/hide my detailModel colModel based on columns show/hidden in the main grid.

On the toolbar show/hide column change listener, I have:
...
   }, listener: { 'change': function (evt) {
        ...
        //get the detailModel
        var detailModel = $grid.pqGrid( "option", "detailModel" );
        //get the colModel of my detailModel
        var detailModelcolModel = detailModel( "option", "colModel" );

12

Help for ParamQuery Pro / Re: clear other select filters when active change listener fires

« on: January 09, 2016, 04:00:13 am »

Perfect - thank you! 

13

Help for ParamQuery Pro / Re: clear other select filters when active change listener fires

« on: January 08, 2016, 01:24:36 am »

In the API doc (V3), dataIndx should be data > condition

I following you, but struggling with the examples. 

I've tried to replace the filter and then call flex method.  I have array/TEXT data and columns defined like this:

            { title: "Group Type", dataType: "string", dataIndx: 0,
                filter: {
                    type: 'select',
                    condition: 'equal',
                    value: 'Total',
                    valueIndx: 0,
                    labelIndx: 0,
                    on: true,
                    prepend: { '': ' Select' },
                    listeners: ['change']
                }               
            },
            { title: "Group Value", dataType: "string", dataIndx: 1,
                filter: {
                    type: 'select',
                    condition: 'equal',
                    value: 'Total',
                    valueIndx: 1,
                    labelIndx: 1,
                    groupIndx: 0,
                    on: true,
                    prepend: { '': ' Select' },
                    listeners: [{ 'change': function (evt, ui) {
                        $( ".selector" ).pqGrid('filter', {
                            oper: 'replace', data: [{ dataIndx: 0, condition: 'equal', value: null }]
                        });
                        $( ".selector" ).pqGrid( "flex", {
                            dataIndx: [ 0, 1 ]
                        } );
                    }}]
                }
            }

Am I on the right path here? - appreciate the help.

14

Help for ParamQuery Pro / clear other select filters when active change listener fires

« on: January 07, 2016, 10:16:05 pm »

I have a (working) grid with multiple select type column filters. The filtermodel mode is AND.

Is it possible to override the active change listener to clear the filter values on the other (non-active) filters?

Here is a suggestion: have another filterModel mode of 'CLEAR' or 'RESET' (something like this) that would clear out the other filters prior to applying the active filter.