Issue with Global Values Not Appearing in Tag-Based Lookup in Assignment Section

Summary:

Hi experts,

We're currently implementing a tag-based lookup in the Assignment Section, where values are segregated by country through the Tag functionality. However, we have some global values that don't have tags, so the tag column for these entries is left blank.Currently, we are experiencing an issue where these global values are not appearing in the lookup field. We suspect this might be related to our WHERE condition not accounting for blank tag values. Here's the condition we've implemented so far:

We would appreciate your input on whether this approach is correct or if we're missing something. Should we modify the WHERE condition to include global values even though their tag is blank?