none
Inner join on customDimensions throwing error RRS feed

  • Question

  • Hi,

    I am trying to write a query to perform inner join on a customEvents table.

    The query is as follows(query values changed for privacy):

    customEvents
    | where timestamp > ago(5m)
    | where customDimensions.workflow == 'abc')
    | where customDimensions.messageType=='xyz'
    | where customDimensions.action=='receive' 
    | extend notificationId=tostring(customDimensions.notificationId)
    | extend inTime=customDimensions.inTime
    | project notificationId,helixInTime
    | join kind=inner (
       customEvents
       | where timestamp > ago(5m)
       |where customDimensions.workflow == 'abc')
       | where customDimensions.messageType=='xyz'
       | where customDimensions.action=='notify'
       | extend notificationId=tostring(customDimensions.notificationId)
       | extend outTime=customDimensions.outTime
       | project notificationId,outTime
    ) on tostring(notificationId)

    I get the following error:

    join attributes may be only column entity or equality expressions

    What am I missing here?


    Thursday, October 19, 2017 9:46 AM

All replies