<< Click to Display Table of Contents >> Create Mongo Expression |
![]() ![]() ![]() |
Mongo is a nosql database, and Mongo syntax expressions are added to this database. Select New Expression from the More menu in the metadata area. The Mongo expression is selected by default, and the JS expression is unchecked.
For example:
New expression "year", input statement: {$ substr: [col ['datetime'], 0, 4]}
The data after preview is as follows: