4 Replies Latest reply: May 18, 2017 9:23 AM by SUPRIYA DORNALA RSS

    Join and Resident Load

    SUPRIYA DORNALA

      Hello Everyone,

       

      I have a requirement where i need to get the count of order lines for one order.

      For this i have wrote a query like below, when i execute this i am getting the Invalid Expression general script error.

      Order:

      Left Join(OrderTable)

      Load OrderLineField,

               COUNT( DISTINCT OrderLineField) as Orders_Count

               RESIDENT OrderLineTable

              Group By Order_ID;

       

      Can anyone of you please help me to resolve this: