I am using jdbc to run queries.
I wanted to use the builtin.period. but am not sure exactly.
I want to do something liker this
select * from revenuePlanPlannedRevenue where BUILTIN.PERIOD('LM', 'END', 'NOT_LAST', '=');
this table has two period columns. However from the documentation, I do not see how to reference it.
I have tried different variations, but ai just get a syntax error from SQL.
I am using Answer ID99191