Skip to main content
B
balajikishu5-Regular Member
5-Regular Member
May 15, 2023
Solved

Advanced Grid : Row selection and Edit doesn't work simultaneously.

  • May 15, 2023
  • 3 replies
  • 1354 views

Hi @TanmeyTWX ,

I'm pretty new to thingworx, I came across this post while searching for the ptc-grid edit, previously by using the legacy grid widget it was pretty easy to use the grid, after upgrading to the new widget finding very much difficult to get the edit cell values(text, number, boolean or any type) I'm able to get only single row from the EditedData property of the ptc-grid.

If possible can you put your listings to know how you have achieved the edit options.

 

Thank You,

Balu

Best answer by AdamK_93

I came accross similar difficulty to have every single row, that I edited, to list to another Grid (just to check what was edited), but this is for the new Grid  widget (in 9.3) which is themable, 

  • The issue I faced was that If I edited a cell in the main table, the row with the edited cell data was displayed in the other grid correctly (I bound the EditedData property to the other grid table data)

  • However if I edited another cell data or row data, the "EditedData" in the other table was lost and only the new edits appears. (I wanted to have all of the data which was edited in my main table).

  • After some testing, I can say the the solution is in the Main Table property, called "EditLevel". 
    • It has 3 values, "Entire Grid, Single Row, Single Cell".  In the begining I thought that the "Single Cell" is what I'm looking for, because I wanted to edit only a single cell. However this caused the confusion. 

    • If you select either "Single Row" or "Single Cell" , only that specific row, or cell value will be the output of the "EditedData", and it will onl keep the on row or cell data  and not keeping previously edited cells/rows.

    • You should use "Entire Grid" to have all the modifications, on all rows or cells. This way the edited data will keep all of them, and you can save the edited data at once

 

AK_10750276_2-1702032922790.png

 

AK_10750276_1-1702032694615.png

AK_10750276_3-1702033228067.png

 

Hope it helps a bit.

 

 

3 replies

S
17-Peridot
Sathishkumar_C17-Peridot
17-Peridot
May 19, 2023

Enable the following in grid properties,

  • isEditable --> true
  • Change the EditLevel based on the you requirement (Entire Grid, Single Row, Single Cell)
  • Go to Grid configuration (settings icon) --> select required column to edit --> Make Editable to true
  • RowSelection --> Multiple

You able to see the check boxes in the grid and edit button also. For more.

 

Sathishkumar_C_0-1684471912526.png

 

T
TanmeyTWX17-Peridot
17-Peridot
May 19, 2023

 

Hi Balaji, 

 

You can try this way.

 

TanmeyTWX_0-1684488432002.png

 

A
AdamK_9313-AquamarineAnswer
13-Aquamarine
December 8, 2023

I came accross similar difficulty to have every single row, that I edited, to list to another Grid (just to check what was edited), but this is for the new Grid  widget (in 9.3) which is themable, 

  • The issue I faced was that If I edited a cell in the main table, the row with the edited cell data was displayed in the other grid correctly (I bound the EditedData property to the other grid table data)

  • However if I edited another cell data or row data, the "EditedData" in the other table was lost and only the new edits appears. (I wanted to have all of the data which was edited in my main table).

  • After some testing, I can say the the solution is in the Main Table property, called "EditLevel". 
    • It has 3 values, "Entire Grid, Single Row, Single Cell".  In the begining I thought that the "Single Cell" is what I'm looking for, because I wanted to edit only a single cell. However this caused the confusion. 

    • If you select either "Single Row" or "Single Cell" , only that specific row, or cell value will be the output of the "EditedData", and it will onl keep the on row or cell data  and not keeping previously edited cells/rows.

    • You should use "Entire Grid" to have all the modifications, on all rows or cells. This way the edited data will keep all of them, and you can save the edited data at once

 

AK_10750276_2-1702032922790.png

 

AK_10750276_1-1702032694615.png

AK_10750276_3-1702033228067.png

 

Hope it helps a bit.

 

 

Terms & ConditionsAccessibility statement