Table. How to make dependent filters in a table

To do this, we pass the collection to the dict procedure filters, and extract the desired filter from it. Next, we build the query taking into account the value of this parent filter. 

Example:  The filter has a category and a child collection. 

In the procedure all for collections we prescribe: 

CREATE PROCEDURE [dbo].[crud_relmap_collectionID_dict]
	@tableCode nvarchar(32),
	@col nvarchar(32),
	@username nvarchar(32),
    @parameters ExtendedDictionaryParameter readonly,
    @filters CRUDFilterParameter readonly
as
begin
	declare @catID int
	select @catID = try_cast(Value as int) from @filters where [Key]='catID'
	-- data source for the list of values (Value, Text)
    select '' Value, ' Not selected ' Text
    union
	select col.id Value, cat.name +' / ' + col.name Text
	from kw_collections col inner join kw_cats cat on cat.id = col.categoryID
	where (isnull(@catID, 0)=0 or  cat.id=@catID)
end

Thus, the filter will be updated depending on the values of other filters when the filter is processed (not instantly when the filter is changed). 

Falcon Space is a functional web development platform on a narrow stack MS SQL/Bootstrap. Falcon Space Gettting started
{sp-shortDemostandLinks}

SQL-tool for creating personal accounts on the site

The essence of the approach and the history of the creation of Falcon Space
Web platform for creating personal accounts

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

MS SQL web applications. Affiliate program for developers and web studios

You can develop on your own or collaborate with us on Falcon Space web development using only SQL and HTML.
See examples with SQL code
Platform documentation
Working on MS SQL Server
Note