Notifications

173 views

Description

When 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

  1. Create a Database View with the left join as follows:
    1. Name = u_db_view
    2. Add a view table to the database view:
      • table= asmt_metric_result
      • Order= 100
      • Variable Prefix = metricres
      • Where clause = (keep it empty)
      • left join = false
    3. Add another view table to the database view:
      1. table=asmt_metric_definition
      2. Order= 200
      3. Variable Prefix = mdef
      4. Where clause = mdef_sys_id=metricres_metric_definition
      5. left join = true
  2. 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

Workaround

  1. Set 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_joins
    • Type: True|False
    • Value: false
  2. 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

Seen In

SR - IRM - Audit Management - New York 2019 Q3
SR - IRM - GRC Profiles - Madrid 2019 Q2
SR - IRM - GRC Workbench - New York 2019 Q3
SR - IRM - PA Premium Integration - New York 2019 Q3
SR - IRM - Policy and Compliance - Madrid 2019 Q2
SR - IRM - Risk Management - New York 2019 Q3
SR - IRM - SIG Assessment Legacy - Madrid 2019 Q1
SR - IRM - Vendor Risk Management - Madrid 2019 Q1
SR - Security - Integration Framework - Madrid 2019 Q2
SR - Security - Support Common - Madrid 2019 Q2
SR - Security - Support Orchestration - Madrid 2019 Q2
SR - SIR - Security Incident Response - Madrid 2019 Q2
SR - SIR - Security Incident Response PA Content - New York 2019 Q3
SR - SIR - Store SecOps Setup Assistant - Madrid 2019 Q2
SR - SIR - Store Threat Core - Madrid 2019 Q2
SR - SIR - Store Trusted Security Circles Client - New York 2019 Q3
SR - VR - Qualys - New York 2019 Q3
SR - VR - Vulnerability Response - New York 2019 Q3
SR - VR - Vulnerability Response PA Content - Madrid 2019 Q2

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2020-03-10 04:23:36
Published:2019-05-20