Recent Posts

11

ParamQuery Pro Evaluation Support / Re: format zero as empty string

« Last post by paramvir on December 11, 2024, 03:48:45 pm »

In new version 10.x, you may use use the excel format #;#; to display 0 as empty string where first part # is for +ve numbers, 2nd part # is for -ve numbers, 3rd part is for 0.

You may try it out in this example: https://paramquery.com/pro/demos/format_number, you can enter the format from the toolbar button.

In colModel, it would be

Code: [Select]

format: "#;#;"


12

ParamQuery Pro Evaluation Support / format zero as empty string

« Last post by scoular on December 11, 2024, 03:36:14 pm »

I have a colModel with datatype integer.  I just want to display zero as empty string instead of zero.  format: "#"  doesn't work and I have tried other things including using a function for format. 

13

Help for ParamQuery Grid (free version) / Re: Steps needed for integrating pqGrid with Angular 14

« Last post by mraj on December 10, 2024, 09:25:17 am »

Is it possible / a way present to integrate the Material Design Kit (1/2/3) of the angular project to the pqgrid ?

14

Help for ParamQuery Grid (free version) / Steps needed for integrating pqGrid with Angular 14

« Last post by mraj on December 09, 2024, 07:05:22 pm »

Hi,

The existing sample in the website, is for angular 7 and pqgrid 3.5, when tried it to convert for the angular v14, getting error as

pq cannot find the namespace.
 
in  pqgrid.component.ts

import  { pq }    from 'pqgridf';

export class PqgridComponent implements OnInit {
  @Input() options!: object;
  grid: pq.gridT.instance ;


error TS2503: Cannot find namespace 'pq'.

18   grid: pq.gridT.instance;
           ~~

even i added the pqgridf.d.ts file

declare module 'pqgridf' {
  export const pq: any;
   
  }
added
in compiler options of tsconfig.json
 "typeRoots": [
      "node_modules/@types",
      "src/app"  // or wherever your pqgridf.d.ts is located
    ]


still i am unable to resolve the namespace,

please suggest, a way

thanks

15

ParamQuery Pro Evaluation Support / Re: Setting Default Values for Columns in Batch Editing with grid.addRow

« Last post by paramvir on December 05, 2024, 11:21:59 pm »

It's already answered here:

https://paramquery.com/forum/index.php?topic=4347.0

16

Help for ParamQuery Pro / Re: editorKeyPress - get current textfield value

« Last post by paramvir on December 05, 2024, 10:51:24 pm »

editor element is evt.originalEvent.target in the event, so it can be wrapped in $() to get $editor.

Code: [Select]

var $editor = $( evt.originalEvent.target )


17

Help for ParamQuery Pro / Re: Customizing Column Menu Items in ParamQuery Grid

« Last post by paramvir on December 05, 2024, 10:25:15 pm »

It's already answered here: https://paramquery.com/forum/index.php?topic=4892.msg17489#msg17489

End result:

https://jsfiddle.net/2buc4z6y/

18

ParamQuery Pro Evaluation Support / Setting Default Values for Columns in Batch Editing with grid.addRow

« Last post by omerix on December 05, 2024, 09:48:17 pm »

Hello,

I?m currently using the "Batch Editing" feature in ParamQuery, and I need to assign default values for certain columns.

For example, when I click the "New Product" button, it triggers grid.addRow. I?d like to know if there?s a way to define default values directly in the colModel, something like a dataValue property, so that addRow can automatically use those values.

Example:

Code: [Select]

{title: "Product Name", dataValue: "Test Product ABC"}, 
{title: "Quantity", dataValue: "1"}


Currently, I?m using an AJAX call to set a cookie when grid.addRow is triggered and then fetching the default values from the cookie after saving. However, this seems like an unnecessary step for what should be a straightforward task.

While I can pass default data to addRow like this:

Code: [Select]

grid.addRow({newRow: defaultValue});

But, there are cases where I?m adding data via copy-paste, and addRow doesn?t seem to handle those scenarios automatically.

Is there a built-in way to define default values for columns in colModel and have them applied both when grid.addRow is called and when data is added via copy-paste?

In summary, is there any plan to introduce a defaultValue option in the colModel that would also work in Copy+Paste scenarios?

Thanks

19

Help for ParamQuery Pro / Re: Customizing Column Menu Items in ParamQuery Grid

« Last post by mikep on December 05, 2024, 07:16:00 pm »

Here's a simple example: https://jsfiddle.net/uftvsqc6/

Can you update the columns selector to just show "Rank".

20

Help for ParamQuery Pro / Re: editorKeyPress - get current textfield value

« Last post by mikep on December 05, 2024, 06:09:00 pm »

thank you. Yes that is what I need to do. How would I reference the $editor in the function?

function MgrSearch(mgrSearch) {

            var data = { 'searchVal': mgrSearch }

            $.ajax({
                type: "POST",
                data: JSON.stringify(data),
                contentType: "application/json; charset=utf-8",
                url: "Services.aspx/SearchManager",
                success: function (data) {
                         Manager = data.d.split(",")

                         $editor.autocomplete('source', Manager);
          }
}