Thank you Ward and Rob !

You can do the same with the Intersystems node.js client (take a look to Robert answer). The idea is not to have ti iterate every record, it would be impossible with collections of millions of objects. I took a look to QEWD.js and it looks it has similar functionalities than node.js client. If you find any way to filter objects retrieval without iterating please let me know.

Thank you Robert !!!

I want to implement the ClassMethod without having to iterate the whole base, something using indexes and also get sorting. I was taking a look to ObjectScript but if you could provide a path it would be great.

Thank you Robert,

I know I can iterate but it is impossible to do with a large database.

Regarding to your reference this is NoSQL,  you have this kind of queries in NoSQL databases (we are porting our solution from mongoDB to Iris and with mongo node.js client you  can retrieve with and/or, regular expressions,  make sorts, etc) . Also Iris has the way with Object Script. 

I asked here to confirm we don't have a chance to do from node.js. I agree with you the path might be to develop a classMethod with object script.

May be if Intersystems provides the source code of iris node client module  we could improve the "lo hi" current available option and make something generic to have a node.js client similar to the other NoSQL platforms.

Yes, I agree. It would be great to publish the package in NPM.

Thank you David,

I don't have access to WRC as we are not a customer yet. Any other alternative ? May be it would be interesting to upload all the clients to connect to the Iris sandbox to any place. Right know I need only iris.node for Ubuntu 16.04. Could you upload to any place ?

Thanks,

Fabian