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.


Topics - kshipra

Pages: [1] 2 3 4
1
https://paramquery.com/pro/demos/tooltips

Tool tip for Exxon "Mobil"  as text gets truncated. It shows only Exxon. Tool tip for user gets truncated.

2
Suggest new features / Filtering on nested grid
« on: September 11, 2019, 10:01:08 pm »
https://paramquery.com/pro/demos/nesting

I have similar nested grid. I would like to enable filtering for data in nested grids. So if there are same product names in multiple nested grids it should display parent records along with nested data.

How can I do that?

3
Help for ParamQuery Pro / Issue with textarea editor grid 5.6.1
« on: April 29, 2019, 11:28:20 pm »
If  === or == are entered in text editor at start without double quotes, it gives out an error : Unexpected token === and replaces the rest of text


4
I have hierarchical grid, which freezes when 6000 rows are loaded with 15 columns on parent and detail grid.
I reduced data sent to grid and then it started working properly. I have virtualX and virtualY  enabled.
I am using grid 5.6.1

5
Help for ParamQuery Pro / Issue with nested grids
« on: March 13, 2019, 10:02:09 pm »
I have report with hierarchical nested grids.
I have set the nested grid height to 'flex' and scrollModel to autofit.  Sub grid is not expanding to its full length.

Same code was working in v3.3 but with new upgrade now it is not working. I am using pqgrid 5.6.1.

Code: [Select]
<html>

<head>

<link href="https://cdnjs.cloudflare.com/ajax/libs/jqueryui/1.12.1/jquery-ui.min.css" rel="stylesheet"/>   
<link href="pqgrid.min.css" rel="stylesheet"/>
   
<script src="https://ajax.aspnetcdn.com/ajax/jQuery/jquery-3.3.1.min.js"></script>

    <script src="https://cdnjs.cloudflare.com/ajax/libs/jqueryui/1.12.1/jquery-ui.min.js"></script>

    <script src="pqgrid.min.js"></script>
</head>


<script>
    var platforms;
    var $grid;
    $(document)
        .ready(function() {

            $grid = $("#eventcodes_grid");                 
                       


            var nestedData = [{ "Code": "0x08", "Count": 7, "data": [{ "Mask": "0x01", "Count": 6, "data": [{ "Name": "ABC.XYZ", "Place": "XXX" }, { "Name": "ABC.XYZ", "Place": "YYY" }, { "Name": "ABC.XYZ", "Place": "ZZZ" }, { "Name": "ABC.XYZ", "Place": "MMM" }, { "Name": "ABC.XYZ", "Place": "NNN" }, { "Name": "ABC.XYZ", "Place": "DDD" }] }, { "Mask": "0x81", "Count": 1, "data": [{ "Name": "ABC.XYZ", "Place": "RRR" }] }] }];
       


            var subContinentModel = function(data) {
                return {
                    dataModel: { data: data },
                    colModel: [
                        {
                            title: "",
                            minWidth: 27,
                            maxWidth: 27,
                            type: "detail",
                            resizable: false,
                            editable: false,
                            sortable: false
                        },
                        { title: 'Mask', dataIndx: 'Mask' },
                        { title: 'Count', dataIndx: 'Count' }
                    ],
                    height: 'flex',
                    numberCell: { show: true },
                    scrollModel: { autoFit: true },
                    showTop: false,
                    detailModel: {
                        init: function(ui) {
                            var rowData = ui.rowData,
                                rdata = rowData.data,
                                model = (rdata[0] && rdata[0].data) ? subContinentModel(rdata) : countryModel(rdata),
                                $grid = $("<div></div>").pqGrid(model);

                            return $grid;
                        }
                    }

                };
            };

            var countryModel = function(data) {
                return {
                    dataModel: { data: data },
                    colModel: [
                        { title: 'Name', dataIndx: 'Name' },
                        { dataIndx: 'Place', title: 'Place' }
                    ],
                    height: 'flex',
                    maxHeight: 300,
                    numberCell: { show: true },
                    scrollModel: { autoFit: true },
                    showTop: false
                };
            };

            $("#eventcodes_grid")
                .pqGrid({
                    height: 'flex',
                    width: 600,                   
                    dataModel: { data: nestedData },
                    scrollModel: { autoFit: true, flexContent: true },
                    colModel: [
                        {
                            title: "",
                            minWidth: 27,
                            maxWidth: 27,
                            type: "detail",
                            resizable: false,
                            editable: false,
                            sortable: false
                        },
                        { title: 'Code', dataIndx: 'Code' },
                        { title: 'Count', dataIndx: 'Count' }
                    ],
                    numberCell: { show: false },
                    title: "<b>Continent & Countries</b>",
                    resizable: true,
                    detailModel: {
                        init: function(ui) {
                            var rowData = ui.rowData,
                                model = subContinentModel(rowData.data),
                                $grid = $("<div></div>").pqGrid(model);

                            return $grid;
                        }
                    }
                });


           
        });
</script>

<body>
   
    <div class="panel panel-default">
        <div class="panel-heading">

            <div class="row">
               
               
            </div>
        </div>
        <div class="panel-body" style="height: 100%">
            <div id="eventcodes_grid" style="font-family: Intel Clear;"></div>
        </div>
    </div>
</body>
</html>

6
I wanted to update dependent column cell based on cell in 1st column. If I remove data using delete key on the cell , the cellSave event does not get fired.


7
Help for ParamQuery Pro / Enable row selection with checkbox Id selection
« on: January 10, 2019, 08:12:45 am »
{
                 title: "Id",
                 width: 220,
                 dataIndx: "Id",
                 type: 'checkbox',
                 cbId: 'state',
                 useLabel: true
             },
              {
                  dataIndx: 'state',
                  dataType: 'bool',
                  cb: { header: true },
                  hidden: true,
                  editable: function (ui) {
                      //to make checkboxes editable selectively.
                      return true;
                  }
              },

checkbox column has disabled checkboxes. They are not getting enabled. Need help

The grid is readonly grid. I want to enable row selection and cell selection for copying so for row selection trying to implement checkbox column.

In version 3.4 row was selected when selected on number cell. It is not getting selected anymore. Can you support this functionality in grid V5.6
https://paramquery.com/pro/demos33/selection_cell

8
Help for ParamQuery Pro / grid.Columns().hide() question
« on: December 12, 2018, 12:39:28 am »

I came across this documentation, where cols can be manipulated.  If export is clicked I would like certain cols to be always exported even though they are not visible.

I would like to always have columns 'Id' and 'Updated' exported, so I am trying to make it visible so they will get exported.
I am not sure how I need to pass parameters to this:

I am trying to do something like this. --- Need help here.
 this.Columns().hide("diShow", ["Id", "Updated"]);


It is giving me error.

9
Bug Report / Wrap text not working v5.6
« on: December 11, 2018, 05:31:37 pm »
Wrap text functionality was working in 3.4. But this code is not working in latest upgrade.

{
                           type: 'checkbox',
                           style: 'margin-left:5px;',
                           //attr: 'checked="false"',
                           label: 'Wrap Text',
                           listener: function (evt) {
                               if ($(evt.target).prop("checked")) {
                                   this.option({ wrap: true, hwrap: true });
                               } else {
                                   this.option({ wrap: false, hwrap: false });
                               }
                               this.refresh();
                           }
                       },

10
Bug Report / Export to excel - local export not working with hex 0x00 value
« on: December 07, 2018, 01:22:23 pm »
Hi,

Export to excel does not work properly if column in grid has hex value of 0x00 or 0x0 for pgrid version 5.6.
https://paramquery.com/pro/demos/export_local


In earlier version of pqgrid 3.4 it worked properly. 
https://paramquery.com/pro/demos33 - local export


I am upgrading grid but existing functionality is breaking :(


11
Hi,

The default filter conditions dropdown length big. On Small screens the drop down looks too big and goes out of visibility. I would like to have all conditions for the filter. I would like to reduce the length of the conditions dropdown such that it is contained inside the grid with scroll similar to options dropdown when Range condition is selected.


12
Help for ParamQuery Pro / Import xslx spreadsheet
« on: November 27, 2018, 06:02:23 pm »
I have requirement to upload data from excel sheet with varying columns into database.

I can think of 2 options:

1. Upload csv files and parse it.

2. I am thinking of using import xslx option. I can import any excel file in web UI. I was wondering
    * how can I validate the excel sheet on client side to make sure there are certain required columns ?
    * how can i send this data to server? 
      would grid.getData(); work?  Is there any better option?



13
Hi,

I recently upgraded grid to 5.5. I like new filters.

1. One thing I noticed was reset filter code is not working when condition is selected to "Empty/NotEmpty"
https://paramquery.com/pro/demos/filter_header_local


2. https://paramquery.com/pro/demos/readonly_cells

On country column in this example the rows grid lines - outer border is not showing. I would like the cell lines to show properly. It was working properly in older 3.4 version.

3. sorting not working properly
In 3.4 you can click anywhere in column header for sorting
https://paramquery.com/pro/demos33/sorting

In 5.5 - column is sorted only when clicked on the name hyperlink , does not work as in previous 3.4 version

14
Help for ParamQuery Pro / filtering and searching row issue
« on: June 13, 2018, 12:11:27 pm »
I need to update non-editable cells in grid with response from updateList.

Code: [Select]
for (var i = 0; i < jsonRsp.updateList.length; i++)
{
       //searching for row with matching Id
      var rowList = $grid.pqGrid("search", { row: { Id: jsonRsp.updateList[i].Id } });

      var rowIndx = rowList[0].rowIndx;
      var updatedAt = jsonRsp.updateList[i].Updated;

      //updating the updatedat date
      $grid.pqGrid("updateRow", { rowIndx: rowIndx, row: { 'Updated': updatedAt} });
}

if rows are filtered the grid searches only on current filtered rows.  updateList can have data from previous filters  edits in bulk update.
So with current code,  rows with previous filter are not found by search method.  I need to search all rows in grid irrespective of filter to get row by Id which is primary key.

15
I have description text box. User wants to add empty spaces at end of sentence or beginning of sentence. The cell is not accepting it

Pages: [1] 2 3 4