seems to work fine I have a parameter in a stored procedure called @name. If the length of this parameter is 1, a single column (LastName) needs to be searched, else two columns (FirstName & LastName) need to be searched. , You can do
WHERE p.Year = @year
/*Always look at this*/
p.LastName LIKE @name + '%'
/*Only need to take account of FirstName if len(@name) <> 1 */
OR ( len(@name) <> 1 AND p.FirstName LIKE @name + '%' )
around this issue I have the following table: , Try this:
WHERE (JobRole = 'Supervisor') -- is supervisor
OR (JobRole = 'Subordinate Type 1' -- or is Subordinate Type 1 and...
and Event not in (select distinct event -- not is event with superv.
where JobRole = 'Supervisor')
Does the Azure Search individual query clause limit apply to a `search.in` filter clause?
hope this fix your issue The 32 KB limit is for terms in full Lucene queries, and does not apply to filters (except when mixing Lucene queries with filters via search.ismatch or search.ismatchscoring). We specifically designed search.in to handle scenarios like yours. Please see Security Trimming in Azure Search for more information.