Messages

1

Help for ParamQuery Grid (free version) / Re: How to update an entire column of pq grid data

« on: December 09, 2020, 10:23:05 am »

Please reply. It's urgent.

2

Help for ParamQuery Grid (free version) / How to update an entire column of pq grid data

« on: December 08, 2020, 07:58:23 pm »

We are having 3 columns in PQ grid as below -

• ID
• Timestamp
• Log

The timestamp column contains timestamp in UTC format. Our requirement is to change the timestamp based on the timezone selected by the user from UI. Is there a way to change the column data easily and refresh the view? What would you suggest?

Briefly speaking, If change the timezone to America/New York, I want to run a function which would fetch the data from PQGrid and change the column timestamp value based on the Timezone and update the data in the PQ Grid.

Note - Having the backend to send the updated data is not feasible so we're just currently targeting having the logic on the client side only.

3

Help for ParamQuery Grid (free version) / Re: Scroll row should work for row data as well

« on: March 11, 2020, 03:41:44 pm »

All I want,

That scroll to work according to the column (numeric value), so if I do scrollToRow: 180 then it must scroll to row having the column value as 180.

4

Help for ParamQuery Grid (free version) / Not able to select text from a row line

« on: March 11, 2020, 03:32:41 pm »

Hi,

I am not able to select a text from a row.

My requirement is -
1. If user clicks on a row -> Entire row must get selected and if the user presses CTRL+C then it must copy the entire row into clipboard
2. If user now selects a particular text from inside row -> Only the selected text should get highlighted (Browser's default) and if the user presses CTRL+C then it must copy the selected(highlighted) text into clipboard.

fiddle link for issue - https://jsfiddle.net/rushabh_flextrade/mw720bdn/24/
Before you ask, why I have used commit and refreshDataAndView after creating the grid, then it was trial error which worked in our case (huge tailing logs 5M or more and then filtering over it). So I need that inside my code. Please provide a solution from the config which is provided or may be workaround.

Also,
I have found this interesting thing about selection, I was able to achieve requirement #2 (the text was being highlighted) but when I pressed CTRL, it just loses the control and the selection would vanish. So was not able to ctrl+c it. If you can provide a workaround for this too, then above 2 requirements can be neglected based on your priority.

Thanks,
Any help asap would be appreciated.

5

Help for ParamQuery Grid (free version) / Scroll row should work for row data as well

« on: February 17, 2020, 07:52:09 pm »

Hi,

I am having dataset (let's say 1M lines) and I am using some strings to filter that grid. Filtering returned me say 100 rows.
I have a line number column coming from database so can't really use the PQ Grid row column.
Now, My First row is showing the below data
==============================
100 |             ERROR OCCURRED
189 |             ERROR OCCURRED
211 |             RESTART
==============================

Now when i scroll row to 189, it must scroll to the 2nd row and not 189th row.
Also, this line number column coming from database is also crucial for me. So can't really change that..
Is there a way I can achieve this using PQ Grid?

6

Help for ParamQuery Grid (free version) / Re: Scroll with tailing the grid

« on: February 04, 2020, 12:19:15 pm »

No. You got me wrong.

You provided with infinite scrolling which is perfect. However, I want the scroll bar to go the bottom automatically as and when a new row gets added (Only when the user is at the bottom).

Use Case (1M rows):
1. When user is at the top and a new row gets added - It must remain at that position.
2. When user is at the bottom i.e at the last row for current data and a new row gets added(or new rows get added) - It must scroll down automatically to the new row just like tailing the rows.

My Question is - Do we have an API which can fetch at what position or at which rowIndx the scrollbar is / pointing at?

7

Help for ParamQuery Grid (free version) / Scroll with tailing the grid

« on: February 03, 2020, 12:02:45 pm »

I want to implement a tailing feature in PQ Grid (Virtual X and Y set to true).

So, If the user is at the top then the scroll should not move but if the user is at the bottom (i.e. at the last row) then scroll should be updated to the latest row added as and when. What can be the best way to implement this?

I tried using the getRowsByClass which will return the array and then I would get the last row out of it and respectively scroll to that row. However, the below code is not returning anything. Please help with this too -

Code: [Select]

$("#logOutputGrid").pqGrid("getRowsByClass", { cls: 'pq-grid-row'})