Forum Discussion

AngelaIp's avatar
AngelaIp
Ideator I
6 years ago
Solved

How to color grid cells according to properties that are hidden in grid?

Hi Community, I hope somebody can give me some hints to solve the following use case. I use an onAfterGet Server Method in ItemType Part that colors certain columns like ‘state’. Now I want to ad...
Grids
Methods
Server Methods
  • christopher_gillis's avatar
    christopher_gillis
    6 years ago

    Hi Angela,

    I'm not sure there's a built-in way to configure adding two properties to the select statement without exposing them on the main grid. As a programmatic approach, you could use an onBeforeGet server method to check the select attribute for the two properties you need and add them to the select attribute if they're not found. This should ensure that the properties are available in your onAfterGet.

    Chris

AngelaIp's avatar
AngelaIp
Ideator I
6 years ago

Ok, quick update. The Method only works works well in the grid, but leads to an error message as soon as you open a Part with a BOM.

--> Value cannot be null. Parameter name: key

I remember that I have another Method to hide some EOL Parts in the grid where I use some extra code so the Method is not run in relationships. But for this use case I would be helpful to have the ERP status in Part BOM grid too. Do I have to use a similiar onBeforeGet query in ItemType Part BOM or is there a better solution available?