Error when using formula field as table column in select que

Posted by Rollbase User on 05-Oct-2011 01:23

Good Day, I've got an error in my select query when I use a formula field in the query. I've already read it in the documentation that using formula field as table column in select statements is not allowed. For meanwhile i'm using a work around by using triggers to set the value in a static field so that i can use it in a select query. I hope there will be a way to use formula field in select query as it will save more time in development. I've also included some screen shots of the actual error in select query. screen shot 1:  screen shot 2:  screen shot 3:

All Replies

Posted by Admin on 05-Oct-2011 12:02

I think error message is clear enough: column you're trying to use does not exist. Please do not type column names on your own but copy available column names fro helper UI box.



Some fields (including formula) do not have corresponding columns and cannot be used in queries.

This thread is closed