Function Field on database view

Jose MMR
Tera Guru

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.

1 REPLY 1

spike
Mega Sage

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.