Slow query from "Tasks by Same Company" relationship causes slow /new_call.do form loads - Known Error

Slow query from "Tasks by Same Company" relationship causes slow /new_call.do form loads Description Build information: glide-newyork-06-26-2019__patch3-hotfix3-12-15-2019 glide-newyork-06-26-2019__patch7a-04-06-2020

Issue Description: When loading a new_call.do form, the form can take a long time to load due to the "Tasks by Same Company" relationship.

Steps to Reproduce

Have a lot of data in the TASK table.

1. Navigate to the new_call list 2. Open a record.

Expected behavior: It should not take along time to load the related lists for the new_call record.

Actual behavior: It can take a long time to load the related lists for the new_call record.

Workaround Kindly modify the relationship code to be like this:

Record: https:// .service-now.com/sys_relationship.do?sys_id=6640d41eeb000100eac006a2f206feba

Query with:

Alternatively, you could just as easily replace the one relationship with 4 related lists.

NOTE: The PRB is fixed in Quebec , once this version is available then kindly upgrade the instance to the fixed version.