Function Field on database view

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-24-2023 02:21 AM
Hi all,
I have several function fields on project table. This function is very simple, transform km to meters as:
glidefunction:multiply(field_length,'1000')
But when we try to open project table or database view system show us an error messages.
"Syntax Error or Access Rule Violation detected by database ((conn=581641) Unknown column 'cmdb_par10.a_num_12' in 'field list')"
When we disabled this field, the error disappears.
According to servicenow documentation, script for function field is correct. (see image attached)
Could anyone have problem as this one?
Regards.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-12-2024 08:01 AM
Just stumbled across this old post. No idea if you solved your issue but the answer is this:
You need to prefix your column name with your table alias. For instance if your project table is called DISTANCES and it's alias is dis, then your field name has to be referenced as dis_field_length.
Hope this helps.