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

    Join and Resident Load


      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.


      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: