# \[Perspective Table\] Column Field is a Dictionary Element

**URL:** <https://forum.inductiveautomation.com/t/perspective-table-column-field-is-a-dictionary-element/56666>\
**Category:** Ignition\
**Tags:** ignition81, perspective\
**Created:** [March 1, 2022, 2:04pm UTC](https://forum.inductiveautomation.com/t/perspective-table-column-field-is-a-dictionary-element/56666 "2022-03-01T14:04:18Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Davide3i](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/davide3i/32/27811_2.png) [@Davide3i](https://forum.inductiveautomation.com/u/Davide3i)\
**Post date:** [March 1, 2022, 2:04pm UTC](https://forum.inductiveautomation.com/t/perspective-table-column-field-is-a-dictionary-element/56666/1 "2022-03-01T14:04:18Z")

</div>

If an element of _data_ is like this

```auto
{
  "ID": 2180,
  "RecipeName": "Test",
  "Configuration": {
    "ID": 3575,
    "Name": "TestConfiguration"
  },
}

```

and I’d like to show _Configuration[“Name”]_ inside a column of the table, what should I write in the column _field_ property?  
Thank you!

---

<div class="post-metadata">

**Author:** ![lrose](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lrose/32/62724_2.png) [@lrose](https://forum.inductiveautomation.com/u/lrose)\
**Post date:** [March 1, 2022, 2:28pm UTC](https://forum.inductiveautomation.com/t/perspective-table-column-field-is-a-dictionary-element/56666/2 "2022-03-01T14:28:52Z")

</div>

You should do a transform on the binding that is producing data and replace the name key with value. Then it will work as expected.

```python
value["Configuration"]["value"] = value["Configuration"].pop("Name")
return value

```

---

<div class="post-metadata">

**Author:** ![victordcq](https://avatars.discourse-cdn.com/v4/letter/v/f6c823/32.png) [@victordcq](https://forum.inductiveautomation.com/u/victordcq)\
**Post date:** [March 1, 2022, 2:32pm UTC](https://forum.inductiveautomation.com/t/perspective-table-column-field-is-a-dictionary-element/56666/3 "2022-03-01T14:32:16Z")

</div>

> [@lrose](#):
>
> replace

or just add one, eitherway value will get picked. there is no other way to specify what is shown (that i know off)  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/2/6284f55488b4960b27c16d5871f74469116757a1.png)

---

<div class="post-metadata">

**Author:** ![Davide3i](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/davide3i/32/27811_2.png) [@Davide3i](https://forum.inductiveautomation.com/u/Davide3i)\
**Post date:** [March 1, 2022, 2:46pm UTC](https://forum.inductiveautomation.com/t/perspective-table-column-field-is-a-dictionary-element/56666/4 "2022-03-01T14:46:07Z")

</div>

Thanks to both of you!

---

<div class="post-metadata">

**Author:** ![rbachman](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/rbachman/32/43718_2.png) [@rbachman](https://forum.inductiveautomation.com/u/rbachman)\
**Post date:** [August 29, 2023, 3:31pm UTC](https://forum.inductiveautomation.com/t/perspective-table-column-field-is-a-dictionary-element/56666/5 "2023-08-29T15:31:56Z")

</div>

I have a similar but different issue. I am passing multiple values to a single column on a table, and that column displays a view that needs each of the values.  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/d/1d99a39dcd4ab705aea185187b84e15dfcad1417.png)

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/8/b/8bc92e3d25566938a6574d42309c2bbb23865e57.png)

The view assumes the input will be a dictionary, and it uses custom parameters to get the values from the dictionary.  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/c/3cd3fdd31b75c086abc476607694064eb828afc7.png)  
My problem is that this functionality broke for some reason after an update to Ignition, and I have not found a good fix for it yet. Is there another way to do this?

---

<div class="post-metadata">

**Author:** ![pascal.fragnoud](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pascal.fragnoud/32/24728_2.png) [@pascal.fragnoud](https://forum.inductiveautomation.com/u/pascal.fragnoud)\
**Post date:** [August 29, 2023, 3:45pm UTC](https://forum.inductiveautomation.com/t/perspective-table-column-field-is-a-dictionary-element/56666/6 "2023-08-29T15:45:28Z")

</div>

I'm not used to putting views in tables, but something doesn't look right to me.  
And by "something" I mean "pretty much everything".

1. That structure doesn't look like what a table accepts. I believe it needs a key for each column, not a `value` key that contains the columns
2. your view expects a parameter named `value`. I don't think it's getting that.
3. that `value` parameter in your view... that's not a dict. That's a string.
4. I'm probably missing things.

Did this ever really work ?

Can you send the json of the 2 views, so we can test things in a designer and maybe fix things ?

---

<div class="post-metadata">

**Author:** ![rbachman](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/rbachman/32/43718_2.png) [@rbachman](https://forum.inductiveautomation.com/u/rbachman)\
**Post date:** [August 29, 2023, 4:18pm UTC](https://forum.inductiveautomation.com/t/perspective-table-column-field-is-a-dictionary-element/56666/7 "2023-08-29T16:18:25Z")

</div>

Yes, it worked great until we updated. I believe the update was 8.1.26. We use views in our tables all over the place, so it was really helpful to be able to pass a dictionary to the view so it could have multiple pieces of information.

The "style" option allows us to add formatting to the row, so we can have different color rows. Here is an example of a table with different colored rows based on some sort of status.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/a/2/a2631d693ba72dbcc915e834dafd883a185667ec.png)

And here is an example of a table with multiple views for the columns to give us different ways to interact with the data associated with each row.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/3/23d57cdb7e9a6d24f04f5bd053b5b534fd500e60.png)

The view _ **is** _ getting the **value** parameter, and that parameter is a dictionary object. You are correct that in the **Designer** , I have put to put a string in the **value** parameter, but the code can accommodate either a string or a dictionary. If it is a string, it decodes the string and converts it into an object, and if it is a dictionary, it just retrieves the value.  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/e/d/ed005624cb62da1d9a9ce6135611ca099a6d5203.png)

---

<div class="post-metadata">

**Author:** ![pascal.fragnoud](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pascal.fragnoud/32/24728_2.png) [@pascal.fragnoud](https://forum.inductiveautomation.com/u/pascal.fragnoud)\
**Post date:** [August 29, 2023, 4:23pm UTC](https://forum.inductiveautomation.com/t/perspective-table-column-field-is-a-dictionary-element/56666/8 "2023-08-29T16:23:44Z")

</div>

Hey, you're right, the table actually accepts this structure as well !  
This things is more flexible than I thought it was.

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/b/b/bb587b70061c2a91029bfbd58eb01360198d79f4.png)