Skip to main content
Version: 10.9.x

Single View Creator Low Code configuration

Low Code Single View Creator is available since version 3.3.0

Throughout this section, we will make examples based on the food-delivery use case and the sv_customer Single View. A complete ER schema can be found in the dedicated section.

Here you can see a visual representation of the ER schema.

visual representation of the ER schema

Single View Key

The configuration contains the singleViewKey.json file. This file creates a mapping between the Single View primary field, which is its unique id, and the identifier field of the Projection.

An example:

{
"version": "1.0.0",
"config": {"sv_id": "ID_USER"}
}

where:

  • sv_id is the name of the Single View primary key
  • ID_USER is the identifier field name of the Projection

ER Schema

For the general rules and guidelines of the ER Schema, check the dedicated page. Let's take an example from the food-delivery use case.

{
....,
"pr_reviews": {
"outgoing": {
"pr_registry": {
"conditions": {
"rev_to_reg": {
"condition": {
"ID_USER": "ID_USER"
}
}
}
},
"pr_dishes": {
"conditions": {
"rev_to_dish": {
"condition": {
"id_dish": "ID_DISH"
}
}
}
}
}
}

This means the pr_reviews Projection is connected to:

  • pr_registry through the rev_to_reg condition, which means the documents are linked if the registry ID_USER field is the same as the reviews ID_USER field;
  • pr_dishes through the rev_to_dish condition, which means the documents are linked if the dish id_dish field is the same as the reviews ID_DISH field;

Selecting an ER Schema (version 10.6.0 and above)

From version 10.6.0 of the Console, your project might have enabled the possibility to configure ER Schemas with a No Code feature. In that case, the configuration section (where you usually would write the ER Schema) will show a drop down menu where you can select one of the ER Schemas already configured in the ER Schemas page.

ER Schema selection with No Code

After selecting an ER Schema, the next configuration save will generate the Config Map of the ER Schema JSON taken from the one configured in the canvas. From now on, whenever the ER Schema is updated, the Config Map in the Single View Creator will be updated as well.

Aggregation

This configuration indicates what are the dependencies of the Single View and how to map them to its fields.

An example of a minimal configuration is as follows:

{
"version": "1.0.0",
"config": {
"SV_CONFIG": {
"dependencies": {
"DOCUMENT_NAME": {
"type": "projection",
"on": "_identifier"
}
},
"mapping": {
"newField": "DOCUMENT_NAME.field"
}
}
}
}

The SV_CONFIG field is mandatory, as it is the starting point of the configuration of the Single View.

The Aggregation Configuration can be automatically generated started from an already existing ER Schema, clicking on the dedicated button as you can see in the picture below. It is necessary to specify the base Projection from which the aggregation shall be generated. The base Projection is the Projection that contains the identifier that is used as identifier for the Single View.

automatic generation of Aggregation

danger

The generated file will have a basic structure but it may not contain all the relationships needed or the desired structure, so please modify it to match the desired needs before using it.

Dependencies

Dependencies have two properties:

  • type: either projection or config
  • on: either _identifier or some condition defined in the ER Schema.

If the dependency is of type projection and the on field is set to _identifier, then the data will be retrieved from the document with the matching identifier. If the on property of a projection dependency is set to another string, then it is checked against the condition in the ER Schema that has the same name.

If the dependency is of type config it will not have an on field, and instead the whole configuration will be defined in the JSON file, using the same structure as the one in SV_CONFIG.

Mapping

Each entry in the mapping has the following syntax:

"singleViewFieldName": "value"

Where value can be one of:

  • projection field: when it is a field taken from a Projection listed in the dependency, expressed with dot notation "newField": "DOCUMENT_NAME.field"
  • configuration: when a field is an object corresponding to a resolved config dependency, expressed with the dependency name "newField": "CONFIG_NAME"
  • constant: when using the constant syntax already seen in the ER diagram, e.g. __string__[hello], __integer__[42], __boolean__[true]
  • function result: when using a custom function to compute the value of the Single View field, expressed with this syntax: "fromFileField": "__fromFile__[fileName]"

For functions, the specified file must be added in a config map with the correct name, and must contain a default exported function, which will be used to compute the value of the field.

The following parameters will be passed to each function:

  • logger: the logger instance used by the service,
  • clientMongo: the instance of MongoDB used by the service,
  • dependenciesMap: a map containing all the dependencies already loaded in the service memory.

Let's see an example of custom function.


async function myOwnCustomLogic (value) {
// some custom logic
}

module.exports = async function(logger, clientMongo, dependenciesMap) {

// access the order already got from the dependenciesMap
const order = dependenciesMap.get("pr_orders")

const fiscalCode = await clientMongo.collection('users').findOne({userId: order.id}).fiscalCode
const result = await myOwnCustomLogic(fiscalCode)
return {
surname: result.surname,
code: result.code
}
}

The dependenciesMap offers a get method to access the dependencies already solved using the name of the dependency itself.

If the dependency you require is a Projection, the value returned will be the document of the Projection, otherwise if it's a config it will be the array of document resulting from the configuration.

If the dependencies has not been resolved, for example due to a reference which failed because of a missing document, the value will be falsy in case of Projections and an empty array in case of config.

danger

You are supposed to access the dependenciesMap only in read-only mode. Write access to the dependenciesMap are not officially supported and could be removed at any time.

Join Dependency

When you want to map a Single View field to an array of values, as it usually happens in 1:N relations, you can use a config dependency with a joinDependency field. This means that when the config will be calculated, the joinDependency will be computed first, retrieving a list of all matching documents, then for each of those elements the configuration mapping will be applied, resulting in an array of elements, each having the same layout as the one specified in the config mapping.

Advanced options

Using the same Projection as a Dependency multiple times under different conditions

When listing dependencies, it is mandatory that each dependency has a different name, as its name is used to identify it. When it comes to config, this is not a problem, as you can name a config dependency as you wish, but it is different when we need to deal with Projections.

For example, how would we describe a Single View of users that need to have their partner as a field? For this case we must have two references:

  • a reference to the users that is based on their identifier to get the core of the Single View
  • a reference to a user, that is based on some condition linked to the marriage

For this example, we will consider the following ER Schema

{
"version":"1.0.0",
"config":{
"PEOPLE":{
"outgoing":{
"MARRIAGE":{
"conditions":{
"PEOPLE_TO_MARRIAGE":{
"condition":{
"a":"id"
}
}
}
}
}
},
"MARRIAGE":{
"outgoing":{
"PEOPLE":{
"conditions":{
"MARRIAGE_a_TO_PEOPLE":{
"condition":{
"id":"a"
}
},
"MARRIAGE_b_TO_PEOPLE":{
"condition":{
"id":"b"
}
}
}
}
}
}
}
}

If we tried to solve the problem without advanced options, we would write a wrong configuration like the following:

danger

The configuration below is incorrect, and presented only to clearly show the need and flexibility of aliases. Do not use this kind of configuration.

{
"version":"1.1.0",
"config":{
"SV_CONFIG":{
"dependencies":{
"PEOPLE":{
"type":"projection",
"on":"_identifier"
},
"MARRIAGE":{
"type":"projection",
"on":"PEOPLE_TO_MARRIAGE"
},
"PEOPLE":{
"type":"projection",
"on":"MARRIAGE_b_TO_PEOPLE"
}
},
"mapping":{
"name":"PEOPLE.name",
"marriedWith":"PEOPLE.name"
}
}
}
}

This is incorrect, because there is ambiguity about which PEOPLE dependency to use in the mapping.

You can solve this problem using the aliasOf option, which allows to use a different name for a dependency of type projection. When using aliasOf: 'PROJECTION_NAME', the named dependency is linked to that Projection.

info

The aliasOf field is supported from the version 1.1.0 of the aggregation.json which is supported from the version 3.6.0 of the Single View Creator service

Now that the aliasOf option is clear, we can have a look at the following configuration, which solves the problem in the example:

{
"version":"1.1.0",
"config":{
"SV_CONFIG":{
"dependencies":{
"PEOPLE":{
"type":"projection",
"on":"_identifier"
},
"MARRIAGE":{
"type":"projection",
"on":"PEOPLE_TO_MARRIAGE"
},
"PARTNER":{
"type":"projection",
"aliasOf":"PEOPLE",
"on":"MARRIAGE_b_TO_PEOPLE"
}
},
"mapping":{
"name":"PEOPLE.name",
"marriedWith":"PARTNER.name"
}
}
}
}

As you can see, we used the same Projection twice, under different conditions: the first time we matched the record based on its identifier (PEOPLE dependency, without alias), the second time we matched the record based on the MARRIAGE_b_TO_PEOPLE condition (PARTNER dependency, with alias).

You can reference a dependency under alias also in another dependency, with the useAlias option. Since CHILD_TO_MOTHER refers to the ER-Schema, which uses only the Projections name and not the dependencies name, you need to use useAlias to specify which is the specific dependency that refers to the Projection of the relation you want to use.

info

The useAlias field is supported from version 1.1.0 of the aggregation.json, which is supported from the version 3.6.0 of the Single View Creator service

If we needed to use the PARTNER dependency as a base for another dependency (for example, if we are looking for the mother in law), a valid configuration would be:

...
"PARTNER":{
"type":"projection",
"aliasOf":"PEOPLE",
"on":"MARRIAGE_b_TO_PEOPLE"
},
"MOTHER_IN_LAW":{
"type":"projection",
"useAlias":"PARTNER",
"on":"CHILD_TO_MOTHER",
"aliasOf":"PEOPLE"
}
...

Note that we used aliasOf inside the MOTHER_IN_LAW dependency as well because we wanted to keep on using the same base Projection, but it is not mandatory, as long as you are using another Projection that is not declared elsewhere in the dependencies.

Changing the query that finds the Projection based on their identifier

Sometimes, when writing a dependency of a Projection that is matched on its _identifier, we find that the identifier has more fields than we want, or has fields with different names, which makes the automatic query mapping result in no documents found. In this scenario, you can employ the identifierQueryMapping option, which provides a new query mapping for the identifier of a Projection, allowing you to have a custom way of matching documents based on their identifier.

info

The identifierQueryMapping field is supported from the version 1.1.0 of the aggregation.json which is supported from the version 3.6.0 of the Single View Creator service

In particular, there are two main cases when this could come in handy:

  1. renaming fields for querying
  2. reducing the number of fields to query on

Renaming fields can be required when you want to achieve a high level of decoupling, so you avoid using the document identifier key, but instead you use a more explicit name, for example instead of "id" you might want to use "my_single_view_id", because this clearly shows what this "id" refers to. An identifier with that logic would be:

{
"my_single_view_id": "12345"
}

This would not match a document without a field named my_single_view_id. In that case, you could map that in the aggregation config in the following way:

...
"PROJECTION_NAME": {
"on": "_identifier",
"identifierQueryMapping": {
"id": "_identifier.my_single_view_id"
}
}
...

Reducing the number of fields to query on will help you if you have a custom function for the generation of Projections changes, which includes additional fields. For example, if you need to generate a Single View in a different way based on a flag in the identifier. An identifier could have a value like the following:

{
"the_id": "12345",
"special": "true"
}

The "special" field is not part of the single document we want to find, but it is used elsewhere in the Single View creation. To avoid having queries that do not find any element, we can map the identifier like that:

...
"PROJECTION_NAME": {
"on": "_identifier",
"identifierQueryMapping": {
"the_id": "_identifier.the_id"
}
}
...
caution

Remember that for identifierQueryMapping to be used, you still need to explicitly set the on field of the dependency to _identifier, otherwise it will not be considered valid.

Using conditional expressions on dependencies definitions and mappings

Dependencies are a way to gather data that will be used in the mapping section, creating the Single View, and as Single Views grow in complexity, you might need to use conditional expressions to use different dependencies configurations and/or change the mapped output of a Single View.

If you have not had this necessity yet, this might be somewhat abstract, so we will directly dive into an example.

We have a System of Records that consists of multiple Projections about jobs, one for each different job. For example, we have DOCTOR and FIREFIGHTER. If you want to create a USER Single View which has the information coming from its job Projection, you need a way to get a dependency which is either a DOCTOR or a FIREFIGHTER. A naive solution could be just putting both Projections as dependencies and using both of them in the mapping. This would cause the Single View to have two different firefighter and doctor fields, one of them undefined, which is clearly not ideal.

Thanks to the _select option, we can create a JOB dependency, which will use the DOCTOR or FIREFIGHTER Projection based on the value of another field, as shown below:

{
"version":"1.1.0",
"config":{
"SV_CONFIG":{
"dependencies":{
"USER":{
"type":"projection",
"on":"_identifier"
},
"JOB_DESCRIPTION":{
"type":"projection",
"_select":{
"options":[
{
"when":{
"==":[
"USER.job",
"__string__[doctor]"
]
},
"value":{
"aliasOf":"DOCTOR",
"on":"USER_to_DOCTOR"
}
},
{
"when":{
"==":[
"USER.job",
"__string__[firefighter]"
]
},
"value":{
"aliasOf":"FIREFIGHTER",
"on":"User_to_FIREFIGHTER"
}
}
],
"default":{
"aliasOf":"DOCTOR",
"on":"USER_to_DOCTOR"
}
}
}
},
"mapping":{
"name":"USER.name",
"job":{
"type":"JOB_DESCRIPTION.type",
"role":"JOB_DESCRIPTION.role"
}
}
}
}
}
info

The _select_ field is supported from the version 1.1.0 of aggregation.json which is supported from version 3.6.0 of the Single View Creator service

As you can see, the _select option has a long set of rules, which we are going to break down here.

The _select is a way of providing one of many different configurations for a specific dependency, based on some conditions. Each possible configuration is an object in the options array. If none of the options has a matching condition, the value in the default field is used. Each option has two fields:

  1. when: the condition that must be matched in order to use the value;
  2. value: the configuration that will be used for this dependency if the when condition is met.

The when field is an object with an operator (available operators: ==, !=, >, <, >=, <=) as a field key, and its relative field value is an array of operands. For example, using the equality operator, we can write this condition:

"when":{
"==":[
"USER.job",
"__string__[firefighter]"
]
}

Here, the first operand is a variable which takes its value from USER.job, while the second operand is a constant string: "doctor". This simply means that this condition will match when the job field of the USER dependency is equal to "doctor". This pattern is repeated for all other operators, as they are binary as well.

As operand, it is possible to use constant values, in the exact same way as seen in the ER schema.

info

Functions can also be used as value from version 1.3.0 of the aggregation.json which is supported from version 5.1.0 of the Single View Creator service

The function works in the same way as explained in the Mapping section, with the only difference that it will accept only two parameters:

  • logger: the logger instance used by the service,
  • clientMongo: the instance of mongoDB used by the service,
myFunc.js
module.exports = async function(logger, clientMongo) {
// Your code goes here
}
{
"version": "1.3.0",
"config": {
...
"when":{
"==":[
"USER.job",
"__fromFile__[myFunc]"
]
}
}
}

The value field is an object with exactly the same structure as a regular dependency, as it will be used as a dependency after the condition is met.

For mappings, the process of taking advantage of _select is very similar: each field in the mapping can be expressed as an object with a _select field that follows the same rules. Just keep in mind that the value here is not a dependency (with fields such as type and on), but a field of a dependency (e.g. MY_DEPENDENCY.field_name).

Null value inside conditional expression

From version 3.10.0 of the Single View Creator, logic expressions now accept null as a value:

...
"withNull": {
"_select": {
"options": [
{
"when": {
"==": [
"JOB.age",
null
]
},
"value": "__string__[unknown]"
}
],
"default": "__string__[foobar]"
}
}
...

Set resolution order of dependencies

From version 4.1.0 of the Single-View-Creator, the resolution order of dependencies can be set with the field dependencyOrder inside the aggregation file:

{
"version": "1.1.0",
"config": {
"SV_CONFIG": {
"dependencies": {
"PEOPLE": {
"type": "projection",
"on": "_identifier"
},
"PARTNER": {
"type": "projection",
"aliasOf": "PEOPLE",
"on": "MARRIAGE_TO_PEOPLE"
},
"MARRIAGE": {
"type": "projection",
"on": "PEOPLE_TO_MARRIAGE"
},
"CHILDREN_CONF": {
"type": "config"
}
},
"dependencyOrder": ["PEOPLE", "MARRIAGE", "PARTNER", "CHILDREN_CONF"],
"mapping": {
"name": "PEOPLE.name",
"marriedWith": "PARTNER.name",
"children": "CHILDREN_CONF"
}
}
},
"CHILDREN_CONF": {
...
}
}

The aggregation above will be performed in the following order:

  1. Find the Projection in the PEOPLE collection on MongoDB using identifier got from the Projection Change as query.
  2. Find the Projection in the MARRIAGE collection on MongoDB using the condition defined in the ER Schema as PEOPLE_TO_MARRIAGE
  3. Find the Projection in the PEOPLE (which is the collection to be used in the dependency PARTNER) using the condition defined in the ER Schema as MARRIAGE_TO_PEOPLE
  4. Calculate the aggregation defined in the CHILDREN_CONF config

Why should I care about the order resolution of the dependencies?

The order resolution is important for the correctness of the aggregation since each step of the aggregation may use documents of the previous steps. Hence, if the order of the dependencies resolution is not correct, the Single View resulting from the aggregation will probably be wrong.

note

Since version v5.0.0 of Single View Creator service returning a Single View with the field __STATE__ from the aggregation will update the Single View to that state (among the other changes).
This means, for instance, that if you set the __STATE__ to DRAFT in the aggregation.json the Single View updated will have the __STATE__ equals to DRAFT. Previously, the __STATE__ you returned was ignored, and the Single View would always have the __STATE__ equals to PUBLIC.

Aggregate documents with different __STATE__ other than PUBLIC

With version 5.1.0 of the Single View Creator the __STATE__ field in the Projection is taken into consideration when aggregating, meaning that if a dependency has its __STATE__ set to anything else but PUBLIC it won't be added to the Single View.

In case you would like to include other states too in the aggregation process you can do it with the onStates field which allows you to define exactly which states you want to include to the Single View. The value is an array with any of the following states: PUBLIC, DRAFT, TRASH, DELETED.

info

The onStates field can be used from the version 1.2.0 of the aggregation.json

Here's a working example:

{
"version": "1.2.0",
"config": {
"SV_CONFIG": {
"dependencies": {
"USER": {
"type": "projection",
"on": "_identifier",
"onStates": ["PUBLIC", "DRAFT"]
},
"WORK": {
"type": "projection",
"aliasOf": "JOB",
"on": "USER_TO_JOB",
"onStates": ["PUBLIC", "DRAFT"]
}
},
"mapping": {
"myId": "USER.id",
"job": "WORK.label"
}
}
}
}

Example

Let's take a look at a simplified version of the sv_customer configuration in the food-delivery use case:

{
"version": "1.0.0",
"config": {
"SV_CONFIG": {
"dependencies": {
"pr_registry": {
"type": "projection",
"on": "_identifier"
},
"ALLERGENS": {
"type": "config"
},
...
},
"mapping": {
"idCustomer": "pr_registry.ID_USER",
"taxCode": "pr_registry.TAX_CODE",
"name": "pr_registry.NAME",
"surname": "pr_registry.SURNAME",
"email": "pr_registry.EMAIL",
"allergens": "ALLERGENS",
...
}
},
"ALLERGENS": {
"joinDependency": "pr_allergens_registry",
"dependencies": {
"pr_allergens_registry": {
"type": "projection",
"on": "reg_to_aller_reg"
},
"pr_allergens": {
"type": "projection",
"on": "aller_reg_to_aller"
}
},
"mapping": {
"id": "pr_allergens_registry.ID_ALLERGEN",
"comments": "pr_allergens_registry.COMMENTS",
"description": "pr_allergens.description"
}
},
...
}
}

In this configuration, the user is matched with its allergies. To do so, two dependencies are used:

  • pr_registry of type projection
  • ALLERGENS of type CONFIG

The pr_registry dependency is used in the mapping to retrieve the relevant user information for the user with the matching identifier.

The ALLERGENS dependency is mapped to an allergens field, and its value is defined in the ALLERGENS configuration, right below the SV_CONFIG object. Inside this configuration, we find some projection dependencies based on configurations described in the ER schema. To understand how the mapping happens, it is important to take a look at the joinDependency property of the configuration, which tells us that the pr_allergens_registry table is the one used as base for finding the other documents.

In this particular case, it means that the Single View Creator will first find all the documents in pr_allergens_registry (the joinDependency) which match the reg_to_aller_reg condition. Here, it means that we are finding the allergen registry entries which are related to a specific user, and we expect to possibly find more than one of these. Afterwards, for each of the retrieved entries, the mapping will be performed. This means that the mappings that have a config as right-side value will be mapped to an array of the resolved dependencies, if the dependency joinDependency field is set.

To make things more practical, let's say we have this data:

pr_registry

{
"ID_USER": "1",
"TAX_CODE": "123",
"NAME": "John",
"SURNAME": "Doe",
"EMAIL": "john.doe@mail.com",
},
{
"ID_USER": "2",
"TAX_CODE": "123",
"NAME": "Jane",
"SURNAME": "Doe",
"EMAIL": "jane.doe@mail.com",
},
...

pr_allergens_registry

{
"ID_ALLERGEN": "eggs",
"ID_USER": "1",
"COMMENTS": "only allergic to raw eggs"
},
{
"ID_ALLERGEN": "fish",
"ID_USER": "1",
"COMMENTS": "allergic to all fish"
},
...

pr_allergens

{
"id_allergen": "eggs",
"description": "insert description"
},
{
"id_allergen": "fish",
"description": "insert description"
},
...

Update logic

Now, if the eggs description changes, we want the Single View to update. When the Single View Creator is notified of the change, it will be provided the USER_ID of the user that needs changes, in this case 1. With that data, it will resolve the pr_registry dependency and map all the relative fields. After that, it will need to resolve the ALLERGENS dependency. To do that, it will read the joinDependency, and it being pr_allergens_registry it will look at the on property of the dependency named pr_allergens_registry, which is reg_to_aller_reg. It will then get all the allergens_registry entries matching the condition (which is the one with ID_USER equal to 1, the id of the Single View to update). At this point, we have two documents: eggs, and fish. For each of those documents, the mapping will be applied, and the resulting Single View will have its allergens field mapped to an array containing those two values.

Read from multiple database server

In order to read data from multiple databases you need to leverage on custom function from the mapping configuration.
First of all you need to create a config map and we suggest to create at least two files: one for the database connection and the others for custom functions.

The connection file could be like the following:

// secondDB.js
const { MongoClient } = require('mongodb');

const url = '{{MONGODB_URL_2}}';
const client = new MongoClient(url);

let connected = false

module.exports = async function (){
if (!connected) {
await client.connect();
connected = true
}
return client
}

The above code uses the database driver and exports a function to retrieve the connected client.
This module works like a singleton, indeed the client is created once and the state, e.g. the connected variable, lives for the entire duration of the Node.js process (remember that require a module is always evaluated once by Node.js).
Because this is a config map, the {{MONGODB_URL_2}} will be interpolated at deploy time. Remember to set it up in the environment variables section.

Then in a custom function file you can retrieve the connected client and use it for reading data:

// fieldFromSecondDB.js
const getClient = require('./secondDB.js')

module.exports = async function (logger, db, dependenciesMap){
const client = await getClient()
return client.db().collection('collection').findOne();
}

Finally you can use the custom function in the mapping configuration:

{
"version":"1.1.0",
"config":{
"SV_CONFIG":{
"dependencies":{
"PEOPLE":{
"type":"projection",
"on":"_identifier"
},
"MARRIAGE":{
"type":"projection",
"on":"PEOPLE_TO_MARRIAGE"
},
"PEOPLE":{
"type":"projection",
"on":"MARRIAGE_b_TO_PEOPLE"
}
},
"mapping":{
"name":"PEOPLE.name",
"marriedWith":"PEOPLE.name",
"fieldFromSecondDB":"__fromFile__[fieldFromSecondDB]"
}
}
}
}