Unable to use function field with a database view

Steve863 · ‎09-15-2022

I need/want to use the coalesce function to consolidate data fields from the Demand, Project, and Program fields in order to report on allocated and actual time. The three tables are used in a database view along with resource aggregate monthly, and sys_user.

Any ideas on how to solve this?
Thanks for any insights,

Steve

Zach Koch · ‎09-15-2022

Function fields, according to the docs, are not supported in database views

Docs page

I posted a screenshot of the docs page mentioning it for quicker reference

If this solved your issue, please mark this response correct and helpful, thank you!

If this information helped resolve your issue, please remember to mark response correct and thumbs up to help future community members on this information, thanks!

View solution in original post

Zach Koch · ‎09-15-2022

Function fields, according to the docs, are not supported in database views

Docs page

I posted a screenshot of the docs page mentioning it for quicker reference

If this solved your issue, please mark this response correct and helpful, thank you!

If this information helped resolve your issue, please remember to mark response correct and thumbs up to help future community members on this information, thanks!