Hope that really answered your problem. Can also use the "Select Records" command, change the Table to the second one and add any filters you need. This will return all records in a list and using the Foreach will get the job done.
Allister ☯
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.
-
@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.jsI just think his example is too old dated
