Database Views with "left joins" fail to retrieve correct dataDescriptionWhen the left join coercion is active on the instance (System Property 'glide.db.coerce_left_joins' is either not existing on the instance or existing and set to 'true'), the query fails to retrieve correct data on database views with left join.Steps to Reproduce Create a Database View with the left join as follows: Name = u_db_viewAdd a view table to the database view: table= asmt_metric_resultOrder= 100Variable Prefix = metricresWhere clause = (keep it empty)left join = false Add another view table to the database view: table=asmt_metric_definitionOrder= 200Variable Prefix = mdefWhere clause = mdef_sys_id=metricres_metric_definitionleft join = true Go to the following URL and no records are fetched:https://<instance-name>.service-now.com/u_db_view_list.do?sysparm_query=metricres_metric.nameSTARTSWITHworking WorkaroundSet the System Property 'glide.db.coerce_left_joins' to 'false'. If it doesn't exists in the instance, you can create it to apply the workaround: Name: glide.db.coerce_left_joinsType: True|FalseValue: false Open the link and note that now records are returned:https://<instance-name>.service-now.com/u_db_view_list.do?sysparm_query=metricres_metric.nameSTARTSWITHworking Related Problem: PRB1326267