Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Create function field on database view

sieusaopolo15
Giga Sage

Hi,

I want to create an function field for database view. How can I do it ? I need this because my report is using this database view as a table report. I found the document related but when I created the field there is no option function field to choose like in the instruction.

1 ACCEPTED SOLUTION

AndersBGS
Tera Patron
Tera Patron

Hi @sieusaopolo15 ,

 

Please just follow the guide which you have linked to, as it is stated to create the function field within the dictionary and not through the report designer. 

 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

 

Best regards

Anders

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

View solution in original post

2 REPLIES 2

AndersBGS
Tera Patron
Tera Patron

Hi @sieusaopolo15 ,

 

Please just follow the guide which you have linked to, as it is stated to create the function field within the dictionary and not through the report designer. 

 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

 

Best regards

Anders

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

Hi @AndersBGS , you are correct ! Somehow the checkbox "Function field" is hidden in my dictionary form after taking it out I can create function fields on database view