Page History
...
Code Block |
---|
// Filter products within an array of product codes var success = databaseManager.addTableFilterParam('crm', 'products', 'productcode', 'in', [120, 144, 200]); // Filter orders using a subselect var success = databaseManager.addTableFilterParam('crm', 'orders', 'countrycode', 'in', 'select country code from countries where region = "Europe"') |
Example This example shows filters on null values
Code Block |
---|
// Filter products within product code is null
var success = databaseManager.addTableFilterParam('crm', 'products', 'productcode', '=', null);
// Filter products within product code is not null
var success = databaseManager.addTableFilterParam('crm', 'products', 'productcode', '!=', null);
// Filter products within product code is null or 120
var success = databaseManager.addTableFilterParam('crm', 'products', 'productcode', '^||='', 120); |
Example This example shows how to filter an entire server connection by passing <null> for the table name. This is ideal for multi-tenant architectures as an entire server connection can be filtered by a single expression, i.e. the current company
...
Overview
Content Tools
Activity