#the newest errors
db.getCollection('KOLEKCJA').find({'level':/.*Error.*/}).sort({date:-1})

#without regex in message

db.getCollection('KOLEKCJA').find({message:{$not:/apiclie|relea|acqu/i}}).sort({date:-1}).limit(100)

db.getCollection('KOLEKCJA').find({}).sort({date:-1}).limit(200)

#by executionId

db.getCollection('KOLEKCJA').find({'executionData.id':'EXECUTIONID'}).sort({date:-1})

#by sessionid- wyszukanie po sessionID

db.getCollection('KOLEKCJA').find({'details.arguments.model.sessionId':'SESSIONID'}).sort({date:-1}).limit(100)

#by timestamp

db.getCollection('KOLEKCJA').find({date:{$gte:new ISODate('2018-07-03 13:55:36.610+02:00'),$lte:new ISODate('2018-07-03 12:00:00.9126847')},message:{$not:/api\/country/i}}).sort({date:-1})

#by PHRASE in message

db.getCollection('KOLEKCJA').find({'message':/PHRASE/i}).sort({date:-1}).limit(100)

#aktywnośći PushService odpowiedzialnego za wysyłanie danych do CBT

db.getCollection('KOLEKCJA').find({'logger':/Santander.PushService/i}).sort({date:-1}).limit(100)

#liteSCA (Belfius)

db.getCollection('KOLEKCJA').find({"message":/transactions:respo/i, level:/warn/i}).sort({date:-1}).limit(100)--przekierowanie light sca
db.getCollection('KOLEKCJA').find({'details.content':/please/i}).sort({date:-1}).limit(100)

#delete collection by name (in example the collection name contains 'staging')

db.getCollectionNames().forEach(function(c) {
if(c.match("Staging")) {
db.getCollection(c).drop();
}
});

####new function#######################################
nowa funkcja
function findAllUserSessions(collection,UserId,BankId){
var conditions = {};
conditions['details.arguments.model.userId']=UserId;
conditions['message']='/api/bank/'+BankId+'/authorize';
conditions['type']='Web Request';
var results = [];
var cond2 = {};
db.getCollection(collection).find(conditions,{'executionData.id':1}).sort({'date':-1}).forEach(function(u){
cond2['executionData.id']= u.executionData.id;
db.getCollection(collection).find(cond2).sort({'date':-1}).forEach(function(t){
results.push(t);
});
});
for(i=0;i<results.length;i++){
print(results[i]);
}
}
db.system.js.save({_id:'findAllUserSessions',value:findAllUserSessions})