MongoDB connector: Using "LIKE" filter in nested tables doesn't get applied on the database side
Our driver provider (Simba) has confirmed that the driver currently does not support this feature. The queries performed in Qlik Sense will not be passed down to the MongoDB server, but the filtering will occur in Qlik sense meaning that the query performance will suffer from this limitation.
Qlik has requested the addition of this feature into the driver and Simba is currently working on the feasibility analysis.
Any updates regarding this feature will be provided in this Knowledge base article.
SELECT * FROM testDB
where "test_day" LIKE '2020-03-30%'