Notifications

34 views

Description

Sorting a list by Input Variables causes the error:
"Syntax Error or Access Rule Violation detected by database (Unknown column 'inputs.column_label' in 'field list')".

- When viewing the table sys_atf_step, sorting by the "Input Variables" field, which is a Glide Var field, will cause the error "Syntax Error or Access Rule Violation detected by database (Unknown column 'inputs.column_label' in 'field list')". No records will be displayed.

- The wf_activity table has 'variables' column which is of 'Glide Var' type with the attributes slushbucket_ref_no_expand and list_layout_ignore which are not being honoured because conflicting with user personalization of the list layout.

Steps to Reproduce

 

1. List view the [sys_atf_step] table.
2. Try to sort by "Input Variables". Observe no records are displayed.

Workaround

This is expected behaviour for all the columns with the "list_layout_ignore" attribute. The list output can only be sorted by other fields besides "Input Variables". 

 

 


Related Problem: PRB591182

Seen In

There is no data to report.

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2019-05-21 11:40:52
Published:2019-02-02