# Report Table Design - Row Versioning w/ Dynamic Data Key

**URL:** <https://forum.inductiveautomation.com/t/report-table-design-row-versioning-w-dynamic-data-key/66807>\
**Category:** Ignition\
**Tags:** ignition81, vision\
**Created:** [November 22, 2022, 3:10pm UTC](https://forum.inductiveautomation.com/t/report-table-design-row-versioning-w-dynamic-data-key/66807 "2022-11-22T15:10:27Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![JustinHiemstra](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/justinhiemstra/32/41138_2.png) [@JustinHiemstra](https://forum.inductiveautomation.com/u/JustinHiemstra)\
**Post date:** [November 22, 2022, 3:10pm UTC](https://forum.inductiveautomation.com/t/report-table-design-row-versioning-w-dynamic-data-key/66807/1 "2022-11-22T15:10:27Z")

</div>

**Environment:** Table with a boolean datatype key column. When the boolean key value is TRUE, the row should be highlighted yellow. If key value is FALSE the rows should follow an Alternate Key version which would be dark grey every other row.

_Table Row Versions_  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/d/6/d6fa047d3dfb3c206810f733af96fee38f608fce.png)

_Standard Version - Fill Enable Dynamic Key_  
\* ![ima*ge](https://us1.discourse-cdn.com/inductiveautomation/original/3X/0/e/0e6a58d48d15cd63f42fd733b060c2ad8e77d010.png)

_Alternate Version - Fill Colour Dynamic Key_  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/f/7fd1996f7f29ce6e745710304ea4ddd77c493b48.png)

**Issue:** The Alternate row verison fill colour equation does not work. The last colour variable in the equation is always be used. Regardless if the equation is `sticky==true?"yellow":"grey"` or `sticky==false?"yellow":"grey"` the alternate row position will always be grey.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/5/65d313c401db7993fcfb1ee288ca231628859ff4.png)

**Question:**

- Is the dynamic key equation syntax correct? I had orignally tried to use the Version Key property to switch between a Standard and Custom version and it did not work. The row would remain Standard in the preview tab. This was using the `sticky==true?"yellow":"grey"` equation.

---

<div class="post-metadata">

**Author:** ![sjohnson](https://avatars.discourse-cdn.com/v4/letter/s/71c47a/32.png) [@sjohnson](https://forum.inductiveautomation.com/u/sjohnson)\
**Post date:** [November 29, 2022, 11:58pm UTC](https://forum.inductiveautomation.com/t/report-table-design-row-versioning-w-dynamic-data-key/66807/2 "2022-11-29T23:58:01Z")

</div>

Hi [JustinHiemstra](https://forum.inductiveautomation.com/u/JustinHiemstra),

It may help to take a look at our user manual, we have an example similar to Keychain Expression you are trying to use. Capitalization may be playing a factor. Can you try capitalizing True and placing quotes around it -\> "True". The full expression should look similar to this: sticky=="True"?"yellow":"grey"

[https://docs.inductiveautomation.com/display/DOC81/Keychain+Expressions#KeychainExpressions-ConditionalKeychainExample](https://docs.inductiveautomation.com/display/DOC81/Keychain+Expressions#KeychainExpressions-ConditionalKeychainExample)

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [November 30, 2022, 12:12am UTC](https://forum.inductiveautomation.com/t/report-table-design-row-versioning-w-dynamic-data-key/66807/3 "2022-11-30T00:12:17Z")

</div>

> [@sjohnson](#):
>
> quotes around it -\> "True".

Probably not, if `sticky` is a real boolean. If a real boolean, the expression should be `sticky?"yellow":"grey"`.