Messages

1

Help for ParamQuery Pro / Is there a way to change the ARIA role="gridcell" to a different role?

« on: October 07, 2020, 01:03:09 am »

Hello,

I am using the latest paramquery version and all gridcells are marked up with the attribute of role="gridcell"  and all rows are marked up with role="row" .

Is there a way to change that to different roles?

Thank you.

2

Help for ParamQuery Pro / Re: 508 Compliant?

« on: April 24, 2020, 12:19:23 pm »

Ok, thank you. 

I will see what I can find on how to test out the grid for 508 compliance and report back.

3

Help for ParamQuery Pro / Re: Export of detail grids

« on: April 24, 2020, 12:16:28 pm »

Thank you for the tip on the detail grids.  I will change it up to do that.

Attached is the excel file that has that error.

Thanks.

4

Help for ParamQuery Pro / 508 Compliant?

« on: April 24, 2020, 12:30:50 am »

Hello,

I saw one old forum post from back in 2016 about 508 compliance.  And it seemed like paramquery grid would be mostly compliant.

Has there been any update on this?

Thank you.

5

Help for ParamQuery Pro / Export of detail grids

« on: April 23, 2020, 10:58:21 pm »

Thank you very much, Paramvir!  That fixed it.

I have another issue with same code example with the excel export.  I have two ASP.NET controllers set up to handle the post and get just like in Demo sample code.  The excel file gets generated but with an error displayed when trying to open it

And then when it is opened it only shows the main rows and not any of the detail rows.  I have attached two pictures to demonstrate what is happening.

Here are the two controller methods:

Code: [Select]

[HttpPost, ValidateInput(false)]
        public String exportData(String pq_ext, String pq_data, bool pq_decode, String pq_filename)
        {
            String[] arr = new String[] { "csv", "htm", "json", "xlsx", "zip" };
            if (arr.Contains(pq_ext))
            {
                String filename = pq_filename + "." + pq_ext;
                Session["pq_data"] = pq_data;
                Session["pq_decode"] = pq_decode;
                Session["pq_filename"] = filename;
                return filename;
            }
            else
            {
                throw new Exception("unsupported format!");
            }
        }

        [HttpGet]
        public FileContentResult exportData(String pq_filename)
        {
            if (Session["pq_filename"].ToString() == pq_filename)
            {
                String contents = Session["pq_data"].ToString();
                byte[] bytes = ((bool)Session["pq_decode"]) ? Convert.FromBase64String(contents) :
                    new System.Text.UTF8Encoding().GetBytes(contents);
                return File(bytes, "application/octet-stream", pq_filename);
            }
            else
            {
                throw new Exception("unknown file.");
            }
        }
Thoughts?

Thank you.

6

Help for ParamQuery Pro / Issue with summaryData - button css does not change

« on: April 23, 2020, 05:20:17 am »

Hello,

I am having an issue with a detail grid and its summaryData.  If summaryData is enabled it does work and shows the sum of the column.  The problem is when I go to edit the data in the row.  The "Edit" button does not switch back to "Edit" after clicking it when it is "Update".  You can see the issue here:

https://stackblitz.com/edit/paramquery-demo-wa52s5?file=index.html

Comment out the summaryData and the buttons and updates work fine but i would really like to have that summary row in there.  Thoughts?

Thank you.

7

Help for ParamQuery Pro / Re: data won't load into grid if called from Ajax

« on: April 20, 2020, 11:30:36 pm »

Thank you for your reply.  That is the fix I was looking for.

8

Help for ParamQuery Pro / Re: data won't load into grid if called from Ajax

« on: April 19, 2020, 02:36:03 am »

Here is the issue recreated.

https://stackblitz.com/edit/paramquery-demo-ldujly?file=index.js

If you un-comment the "url:" line and comment out the "getUrl" line then it works fine.

How can I get the grid to load data from an ajax call?  I need this for my real app that calls a custom ajax method that adds auth headers.

Please advise.  Thank you!

9

Help for ParamQuery Pro / data won't load into grid if called from Ajax

« on: April 18, 2020, 10:59:51 am »

Hello,

I need to load data from ajax call where the headers are modified for security.   Here is ajax call that is not modified for security but it does hit the controller and return data:

Code: [Select]

function getJsonData() {
                $.ajax({
                url: "http://localhost:53849/Home/PayrollAnnual/get",
                type: 'GET',
                contentType: 'application/json',
                async: true,
                success: function (dataJSON) {                 
                    return dataJSON;
                }
            });
        }
And here is how I am calling for it.

Code: [Select]

var dataModel = {
            location: "remote",
            sorting: "local",
            dataType: "JSON",
            method: "GET",
            recIndx: "Id",           
            getUrl: function () {
                return {
                    url: getJsonData()
                }
            },
            getData: function (dataJson) {
                var data =  dataJson ;             
                //expand the first row.
                if (data && data.length) {
                    data[0]['pq_detail'] = { 'show': true };
                }
                return { curPage: dataJSON.curPage, totalRecords: dataJSON.totalRecords, data: data };
            }
        }
The getJsonData method does get called and I can see data when I debug.  The problem is that it never gets applied to grid.  And the getData part is never hit either.  Timing issue?  Thoughts?

Thank you.