I have two collection and need to performs a left outer join on it. With $lookup is works good but the problem is that the collections come from some API where the value of localField is in lower case and foreignField is in upper case.
How to use $lookup to ignore or to lowerCase the value(s)? I try something but I have no chance. I found a solution but is for a older version of mongodb. If you have any experience please help