Just for learning Event Streaming, I could not see it working. I have used setting for the same user as Administrator at both sites and could configure well and approve the docs
Event Not Streaming-Even after proper setting at Event Producer site and Event Consumer site. On observing the Event Update Log, getting a message like observing Use of sub-query or function is restricted.
No record found in Event Sync Log at consumer site though at producer site records are available at Event update Log.
Even the same message comes like Use of sub-query or function is restricted, on observing log.
Any pointer to find out the issue.