Hi!
Explorer says "unexpected token" on KEY(..:
SELECT FROM individual.IndividualContact $1 LEFT OUTER JOIN $1.profile.title.name m WHERE (KEY(m) = 'deu' AND VALUE(m) LIKE '%Dr%')
profile = embedded entity
title = referenced entity
name = Map<String, String>
thanks,
Alex