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
- Management
- Falcon Space Foundation
- Basic components
- Falcon Space Features
- Коммуникация с пользователем
- Дизайн, стилизация
- Integrations
- Каталоги
- Навигация
- Документы
- Additional component
- Продвижение, SEO
- Системные моменты
- HOWTO
- HOWTO Tables Tables. How to do sorting in AS CRUD Tables. How to make Editable for a tick (Yes/No) in AS CRUD Tables. How to edit a date column Tables. How to link 2 tables Tables. How to make a table in a modal window (opens in a dialog window) Tables. How can I remove the display of the number of result rows in the table header? Tables. How to link a table and edit an entity (dependent page) Tables. How to use comments in tables Tables. How to add a value Not selected with the value in the filter Tables. How to set the column width in a table Tables. How to add a range of dates or numbers to the filter Tables. How to execute operations only for certain lines Tables. How to make a different set of columns in the same table for different roles Tables. How to implement a sub-table (nested table), a subform in a table Tables. How to hide row operations in a table for specific lines Tables. How to make manage files (images or documents) in the table column) Tables. How to add a callback after loading a table Tables. How to make a table on your smartphone in the form of cards Tables. How to work with checkboxes in a table Tables. Common errors when configuring the table (why the table doesn't work) Tables. How to update a sub-table after performing an operation Tables. How to process group operations via the modal form Tables. How to create preset filters for a table Tables. How to output data from a remote source (via the API) in the Table component How to make collapse a table Tables. Loading the table by link How to remove old dict procedures in forms and tables Table. How to make a filter with a checkmark tree Tables. How to disable saving table state (filters) Tables. How to make a link to the entire table line Tables. How to pass the filter value via URL Tables. How to crop table cells Sorting lines in a table Table. Creating an entity based on filter values SQL query Optimization-extracting data for a table Custom markup in the table Tables. How to set up additional header and footer for a table Table. Custom output mode via JS Table. How to make dependent filters in a table Импорт данных в формате файлов txt, csv через таблицу Как гибко управлять видимостью столбцов таблицы Таблица. Как сделать раскрытие подстроки через любую ссылку Таблица. Режим быстрой фильтрации строк без обращения на сервер
- HOWTO Forms
- Working with SQL
- HOWTO JS
- HOWTO Layout
- Solve problems
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
Note
- Falcon Space Video
- Platform features demo will allow you to understand how this or that component looks and works
- Have a question? Write to the chat at the bottom right