MONGO DB:
MongoDB is an open-source NoSQL database management program. NoSQL is used as an alternative to traditional relational databases. NoSQL databases are quite useful for working with large sets of distributed data. MongoDB is a tool that can manage document-oriented information, store or retrieve information.
Normal Run-on Mongo connection:
For Mongo data source in the component options the Name will be
given as collection and the value will be given as <collection name> as shown below
How to apply filter(s) on Mongo DB collection:
If user needs to give the filter on Mongo connection, then in the component options
the Name will be given as aggregation.pipeline and the value will be given as shown below
Filter on string column:
{'$match': {'column name':'data which need to be filtered in specific column '}}
EX: {'$match': {'skill': 'java'}}
Here skill is a column name and
java is a value
so, user can fetch the data based on the given value
Filter on different datatype columns:
{'$match': {'columnname1': 'stringtypedata','columnname2': integerdata,'columnname3': {$gt: {$date:datetype data'}}}}
EX: {'$match': {'cancellation_policy': 'moderate','accommodates':2,'calendar_last_scraped': {$gt: {$date:'2019-03-07T00:00:00.000Z'}}}}
Here cancellation_policy is a column name and moderate is a value and
accommodates is a column name and 2 is a value and also
calendar_last_scraped is a column name and 2019-03-07T00:00:00.000Z is a value