Method Community

When I get the value of a grid element from the current row using VALUE FROM SCREEN, I am able to get the result of the custom SQL value for that cell. However, when I am looping a grid, it seems this is not possible. Is there a way around this that I am not seeing?

Best,

Furry

Did  you change action to Get  the VALUE from ROW - since you are in a loop? 

I did, and that value was the value of the database entry underneath the custom SQL override (i.e. NOT the override value). 

Is there a way to get the custom SQL override value when looping through a grid?

Hi furrywombat,

This is not possible because SQL overrides are not stored. There is no way to retrieve them because there is nowhere to retrieve them from, they function only as a means to manipulate the way data is represented on screen.

- Justin