The current query does not include a where clause for the effective location name. This query should be modified to accept multiple location names, and ensure that the result set only includes items that have an effective location name that matches one of the incoming location names.
The current query does not include a where clause for the effective location name. This query should be modified to accept multiple location names, and ensure that the result set only includes items that have an effective location name that matches one of the incoming location names.