Commergent.Dw.DataLists
1.0.9
dotnet add package Commergent.Dw.DataLists --version 1.0.9
NuGet\Install-Package Commergent.Dw.DataLists -Version 1.0.9
<PackageReference Include="Commergent.Dw.DataLists" Version="1.0.9" />
<PackageVersion Include="Commergent.Dw.DataLists" Version="1.0.9" />
<PackageReference Include="Commergent.Dw.DataLists" />
paket add Commergent.Dw.DataLists --version 1.0.9
#r "nuget: Commergent.Dw.DataLists, 1.0.9"
#:package Commergent.Dw.DataLists@1.0.9
#addin nuget:?package=Commergent.Dw.DataLists&version=1.0.9
#tool nuget:?package=Commergent.Dw.DataLists&version=1.0.9
The DataLists app is supposed to offer a replacement for the legacy DataLists App. It allows creation of lists based on SQL statements. The lists are available in the back-end for Admins and the data can be exposed in the front-end using a content App and templates.
Backend Features
Create/Edit/Delete Data list. Allows to add a name, a SQL statement, set if can be visible in frontend.
Import from Data List - allows to select which data list will be transformed in the custom version for data lists.
Configure permissions for data lists.
Show data list content (resulted by executing saved sql statement) and allow filtering.
Add parameters for sql statements (variables from Request or Session); variables are added in the definition of query and after Save/SaveAndClose can de edited test values from backend.
The Request option is used to get values passed to the web page.
The Session option is used to get information about the user for the current period.
Download result of query in an csv or xlsx file.
Datalist can be visible or not in frontent, based on configuration.
FrontEnd Features
Default Template with the result of datalist. Can export result in an csv or xlsx file.
Dependencies
.NET Core 10
+ DW 10.27.6
Swift V2
Setup
Default template location: /Templates/Cmgt/CmgtDataListApp/List
Limitations
No detail view page
No wizard for SQL statement. We use the same logic as SQL Firehose
| Product | Versions Compatible and additional computed target framework versions. |
|---|---|
| .NET | net10.0 is compatible. net10.0-android was computed. net10.0-browser was computed. net10.0-ios was computed. net10.0-maccatalyst was computed. net10.0-macos was computed. net10.0-tvos was computed. net10.0-windows was computed. |
-
net10.0
- Dynamicweb.Application.UI (>= 10.27.6)
- Dynamicweb.Apps.UI (>= 10.27.6)
- Dynamicweb.CoreUI (>= 10.27.6)
- Dynamicweb.CoreUI.Rendering (>= 10.27.6)
- Dynamicweb.DataIntegration.Providers.ExcelProvider (>= 10.27.6)
- Dynamicweb.Ecommerce (>= 10.27.6)
- Dynamicweb.Ecommerce.UI (>= 10.27.6)
- Dynamicweb.Files.UI (>= 10.27.6)
- Dynamicweb.Indexing.Lucene4 (>= 10.27.6)
- Dynamicweb.Users.UI (>= 10.27.6)
- Microsoft.Extensions.FileProviders.Embedded (>= 10.0.5)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.