Messages

1

Help for ParamQuery Pro / Re: Date of export

« on: August 08, 2023, 10:48:58 pm »

Well that is close. My objective was during the export the date is injected into a row or somewhere on the workbook dynamically once you hit export button.

2

Help for ParamQuery Pro / Date of export

« on: August 08, 2023, 06:15:03 pm »

I want to be able to add the date the export was done.
Example: When a user clicks export button, I want to capture today's date and include it in the report and place in a row or title so it is visible.

3

Help for ParamQuery Pro / Re: How to you enable resizing of columns?

« on: January 24, 2023, 11:34:10 pm »

thank you

4

Help for ParamQuery Pro / How to you enable resizing of columns?

« on: January 24, 2023, 02:24:20 am »

I have the latest 8.6.0 grid files but for some reason I cannot get the columns to resize when manually.
I can reorder but resizing does nothing.

Code: [Select]

    var obj = {
        width: gridWidth,
        height: "700",
        editable: false,
        fillHandle: '',
        resizable: true,
        hoverMode: 'row',
        selectionModel: { type: 'row', column: false },
        sortModel: {
            sorter: thisSort,
            space: true,
            multiKey: null
        },
        scrollModel: { autoFit: true },
        pageModel: {
            type: "local", rPP: 100, strRpp: "{0}", rPPOptions: [50, 100, 500, 1000],
            strDisplay: "Displaying {0} to {1} of {2} Records", strPage: "{0} / {1}",
            layout: ["first", "prev", "|", "strPage", "|", "next", "last", "|", "strRpp", "|", "refresh", "|", "strDisplay"]
        },
        filterModel: { on: true, mode: "AND", header: true, type: "local" },


5

Help for ParamQuery Pro / Initial filter for date

« on: January 13, 2023, 12:16:16 am »

I have been trying to get the initial filter defined for dates that are today and less than or = 30
RAD is the Reported Auth Date new date. Did not find examples for dates with the initial filters defined for the between conditions. Example would be 12/13/2022 - 1/12/2023 
    filters: { RAD: { crules: [{ condition: 'between' }]}},

Code: [Select]

        "RAD": function(ui) {
            if (ui.cellData) {
                let todayMinus30 = new Date(ui.cellData);
                todayMinus30.setDate(todayMinus30.getDate() - 30)
                return todayMinus30;
            };

}

6

Help for ParamQuery Pro / Is there an option to have unique values with inline editing

« on: October 12, 2022, 12:22:20 am »

Is there an option to force unique values for inline editing?
I have a field named "Priority" and it contains a number EX..... 1-100.
I want this field not to be able to use the same number twice for this field. Is this an option?

7

Help for ParamQuery Pro / Re: Pre-Defined filter 7 days old from today

« on: February 22, 2021, 07:16:06 pm »

This does give the date of 7 days older but did not pre-define the filter for the Created column.
I changed the date to be the 7 day of date of 2/15/2021
Am I missing something?

Code: [Select]


{ title: "Created", width: "8%", dataIndx: "Created",
render: function (ui) {
    if (ui.rowData.Created) {
        var usaDate = new Date(Date.now() -7 * 24 * 60 * 60 * 1000);
        return usaDate.getMonth() + 1 + "/" + usaDate.getDate() + "/" + usaDate.getFullYear();
    }
}
},


8

Help for ParamQuery Pro / Pre-Defined filter 7 days old from today

« on: February 20, 2021, 01:47:41 am »

Is there a away to pre-define a filter by todays date and other date values older than 7 days from today?

9

Help for ParamQuery Pro / Inline edit with dropwdown values

« on: July 09, 2020, 12:29:52 am »

I have a column that is has a drop down for Yes/No and I want a dropdown to for the inline edit mode. I do not want user to have to type Yes/No just make a selection.
My Yes/No values are choice columns within SharePoint list and not the Yes/No filed itself.

Code: [Select]

{ title: "CSSP Accepted", editable:true, width: "8%", align: "center", dataIndx: "CSSPaccepted", dataType: "string", filter: { crules: ruleR } },


10

Help for ParamQuery Pro / Set columns to be vertical instead of horizontal

« on: June 11, 2020, 01:05:23 am »

Is there a position setting to make the data display vertically for a grid

11

Suggest new features / Export to excel data within the row details

« on: December 06, 2019, 08:00:13 pm »

Is there an ability to export data from the row details along with main data when exporting to csv?

12

Help for ParamQuery Pro / Date calculation

« on: October 24, 2019, 08:27:29 pm »

I have a date field "Scheduled Completion Date" and I need to add a new column in the grid to display the number of days until "Scheduled Completion Date" from todays date

Here is code for "Scheduled Completion Date". What would I place under this as new column "Days Until Due"?

Code: [Select]

{ title: "Scheduled Completion Date", align:"center", dataIndx: "Step2aComplete",
     render: function(ui) {
      if(ui.rowData.Step2aComplete){
var usaDate = new Date(ui.rowData.Step2aComplete);
return usaDate.getMonth()+1 + "/" + usaDate.getDate() + "/" + usaDate.getFullYear();     
      }
}
}



13

Help for ParamQuery Pro / Re: Carriage Return for multiple values in a cell

« on: September 12, 2019, 06:34:12 pm »

Thank you for the reply

I get this error "Unable to get property 'replace' of undefined or null reference"

Code: [Select]

{ title: "Deployed Location", width: 200, dataIndx: "DeployedLocations", hidden: hideLoc, /*hideLoc uses the varible from the dropdown list deployedLoc and the condtion is around Line#312*/
filter: { type: "textbox",
        condition: 'contain',
        listeners: ['keyup']
     },
render: function(ui){
  return ui.cellData.replace(/\|/g,"<br/>");
}      
},


14

Help for ParamQuery Pro / Carriage Return for multiple values in a cell

« on: September 11, 2019, 11:49:00 pm »

I have a field that has multiple values and when it returns the values it words wraps
I want carriage return for each value that is separated by "|".
Ultimately just carriage return each value minus the "|".

15

Help for ParamQuery Pro / Re: Conditional Formating of past due record

« on: August 02, 2019, 07:19:36 pm »

Here is how I placed render code in the demo link and nothing changes color.
I tried fiddler but the entire preview pane is white so not sure why nothing ran on there.

Code: [Select]

    { title: "Order Date", minWidth: "190", dataIndx: "OrderDate", dataType: "date",
        filter: { crules: [{ condition: "between" }],
render: function(ui){
var dt = new Date();

//new Date(ui.cellData) is date value of cell
// new Date(dt.getFullYear(), dt.getMonth(), dt.getDate()) is date value for today ( excluding time ).

if( new Date(ui.cellData) < new Date(dt.getFullYear(), dt.getMonth(), dt.getDate()) ){
return {style:"color:red;"} //add style to the cell.
}
},

}
    },