frankframework / frankframework/frankframework

Let MongoDbSender support Projection, Sort and Collation

Open
#4,570 1 comment 0 reactions 0 assignees View on GitHub
Low Effort; High Return Needs Funding
Dominant language
Java
Stars
167
Forks
87
Avg merge
1d 2h
Merged PRs (30d)
206

Description

**❗ please do not add sensitive information in issues, you can provide extra information via email using issue number as reference ❗**

**Describe the issue**
In MongoDB Compass you can do queries on a MongoDB database. In MongoDB Compass, you have text fields Filter, Project, Sort and Collation. In the Frank!Framework you can set the filter, but not the other three fields of a query. It would be nice if MongoDbSender would support all four of these fields.

**Reporter**
Martijn Dirkse

**To Reproduce**
Steps to reproduce the behavior:
1. Go to '...'
2. Click on '....'
3. Scroll down to '....'
4. See error

**Screenshots**
If applicable, add screenshots to help explain your problem.

**Configuration**
```
Please provide the configuration of the Pipe or Receiver with the problem.
```

**Input**
```
Please provide an example of the input message.
Alternatively, provide a Ladybug report.
```

**Environment**
```
FF! 7.9-20230222.152656: Frank2MongoDB
Running on LAPTOP-R1SK28C using Apache Tomcat/9.0.68
Java Version: OpenJDK Runtime Environment (1.8.0_292-b10)
Heap size: 323M, total JVM memory: 995M
Free disk space: 210GB, total disk space: 464GB
Up since: 2023-02-24 11:31:43 (2h)
```

**Additional Environment**
- DBMS: [e.g. Oracle, MSSQL, MariaDB, MySql, PostgreSQL]
- Browser: [e.g. Chrome, Safari, Edge, Firefox]

**Additional Context**
I created this issue because I am documenting MongoDB in the Frank!Manual. No customer is involved.

Contributor guide

Open the contributing guide

Research direction

Locate MongoDbSender and inspect how its existing filter configuration is exposed. Check the Frank!Manual MongoDB documentation referenced in the issue and verify the expected Projection, Sort and Collation behavior against MongoDB Compass. Done means MongoDbSender supports all four query fields and the documentation describes their configuration.

Written by the indexing model from the issue text.

Assessment

Tech stack
java, mongodb
Domain
database
Issue type
Feature
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.