Как правильно обрабатывать множественный выбор галочек в фильтре?

Последнее обновление - 07.05.2021voroshilova07.05.2021 1
<p>В таблице есть фильтр-флажки (статусы заказа), когда выбор одного флажка, то&nbsp; фильтрует, а нескольких &mdash; нет</p>

Использовать dbo.split 

select  p.id, 
        regionID,
        p.address,
       (select name from as_geo_regions where id=regionID)desc_address,
       (select dbo.as_num ((select top 1 price from rent_prices where objectID = p.id order by id desc),0)) price,
from as_cat_products p
where (isnull(@filterStatusID,'') = '' or statusID  = try_cast( Value as int) from dbo.split(@filterinstance,','))

Другие темы

SQL-инструмент для создания личных кабинетов на сайте

Суть подхода и история создания Falcon Space

Falcon Space Platform

This is a reduction in the cost of ownership

at the expense of fewer people to support

This is a quick change

while using the program

This is a modern interface

full adaptation for mobile devices

 
Component demo stand
At the stand you can see various components in action - tables, forms, modal windows, diagrams, a map, etc.
Solution demo site
Basic solutions that can be flexibly adapted for yourself - change the appearance, business logic and even the structure of the database.
Discuss the project
Ask the initial questions about the project that concern you right now. We will advise you for free and recommend the best solution.