does not contain in database?

[hellomembersha]

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.

[Fox]

@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

https://community.bablosoft.com/topic/3521/лайфхаки-bas/64

[hellomembersha]

@Fox The sql module will not work if all my records are already in mongo database. But thank you for response.

[Fox]

@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

[hellomembersha]

@Fox Yes but with that i get this image

[hellomembersha]

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