Table. Creating an entity based on filter values
Sometimes you need to pass the value of table filters to the fastcreate entity creation procedure.
To do this, you need to add the filters parameter to it in the same way:
CREATE PROCEDURE [dbo].[crud_relmap_fastCreate]
@filters CRUDFilterParameter READONLY,
@text nvarchar(256),
@username nvarchar(32)
AS
BEGIN
-- extracting filter parameters
declare @filterCatID int
declare @filterCollectionID int
select @filterCatID = try_cast(Value as int) from @filters where [Key] = 'catID'
select @filterCollectionID = try_cast(Value as int) from @filters where [Key] = 'collectionID'
-- adding an item to a table
insert into kw_pages(title, catID, collectionID)
select value, nullif(@filterCatID, 0), nullif(@filterCollectionID, 0) from split(@text,char(10))
where len(value)>1
select 'Item is created' Msg, 1 Result
END
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