AHD05800:Bad where clause. invalid constraint. Unable to resolve group_prev.last_name.
The attributes of objects that are included in stored queries are translated and incorporated into SQL statements for processing by the underlying DBMS engine. However, an attribute that is defined with a type of LOCAL does not correspond to a column of a database table. Therefore, LOCAL attributes cannot be used in stored queries.
CA Service Management 17.1 and higher.
Figure 1 below is a sample of the message received when you attempt to save a stored query that includes a LOCAL attribute.
The bop_sinfo command can be used to check whether or not an attribute is defined as LOCAL. Figure 2 below shows that the group_prev attribute of the iss object is defined as a LOCAL LREL.
LOCAL attributes that are included in the out-of-the-box product are used for implementing internal functions, such as triggers on status transitions.