0 Replies Latest reply on Mar 11, 2014 11:21 PM by Sat P

    Circle in geographical map with union query

    Sat P

      I have created a geopraphical report and circle radius, to meet the requirement i have used Union query.I was able to plot the circle based on Latitude, Longitude and Radius

       

      We have quick filter on Region, Name & Level, which have Null as one of the filter.
      If we exclude "Null" the circle plotting is not done.

      I want to exlcude the "Null" value only from filter and also plot the radius circle

       

      eg.

      Select
      S1.Longitude  as Longitude
      S1.Latitude  as Latitude
      S1.Region as Region
      S1.Name as Name
      S1.Level as Level
      Null as Degree
      From S1
      union
      Select
      S2.Longitude  as Longitude
      S2.Latitude  as Latitude
      S2.Region as Region
      S1.Name as Name
      S2.Level as Level
      Null as Degree
      From S2
      union
      Select
      null  as Longitude
      null as Latitude
      null as Region
      Null as Name
      3 as Level
      Null as Degree
      From degree

      Note : The degree table have 1 to 360 number to plot the circle in 360 degree


      How can we acheive this ?

      Appreciate your time and help,