When doing "select records by criteria" how will one say DOES NOT CONTAIN exist instead of contains. I have tried many js operators without success. I am trying to locate from database that does not contain specific text.
@hellomembersha said in does not contain in database?:
When doing "select records by criteria" how will one say DOES NOT CONTAIN exist instead of contains. I have tried many js operators without success. I am trying to locate from database that does not contain specific text.
In the standard "Database" module, it is not possible to use the "does not contain" filter for strings. Use the "SQL" module
Or you can use the method presented by @UserTrue to connect to the BAS database via node js
@Fox The sql module will not work if all my records are already in mongo database. But thank you for response.
@hellomembersha said in does not contain in database?:
@Fox The sql module will not work if all my records are already in mongo database. But thank you for response.
I also gave a link to the topic, which shows an example of connecting to mongodb via node js in BAS
Using Node.js v12.18.3
mongodb3.6 installed
apps\25.8.0\e\366f.QkC0\distr\lib\custom\ivcxlkisls.js
I just think his example is too old dated
