I can successfully call a sql function in where clause in advance query using select * from {table} where param in (select param from function()) but when I am trying to call a function directly using select * from function(); I am getting invalid object name error.
Does any one how I can directly call function in side advance sql query?
You need at least create one Entity that use your postgresql database connection.And then write query as following so that Platform can know which database connection to use. /* %LogicalDatabase%=GetLogicalDatabase({AnyEntityThatUsePostgreq}) */SELECT param from function()
There are good few entity already created and used for postgresql database connection still not able to call directly function. Please note I can use function in where clause.
Thank you