Sort feature not working properly with team-managed filters in gadgets

Issue Summary

When you have multiple team-managed projects using a field in common to order by, it sorts the issues inconsistently.

Steps to Reproduce

1. Create 2 date custom fields with the same name in 2 different team managed projects
2. Add some values and create a filter, then create a filter results gadget
3. Try sorting the issues using the created custom field
4. Video example

Expected Results

The sort should follow the DESC or ASC criteria

Actual Results

issues are not displayed in the correct order

Workaround

Currently, there is no known workaround for this behavior. A workaround will be added here when available