Spectrum Spatial (SSA/LIM)

 View Only
  • 1.  Creating Queries in Latest SSA/Spectrum

    Posted 09-14-2020 21:12
    Hi..

    Need some help, or a quick pointer in the right direction.

    Queries used to be easy to build previously in the admin console, I know it has now been moved into Spectrum.

    Documentation is a bit vague around the process...

    Create a View Table?

    Create the SQL to query data from that table?

    Then how do we get this into the query window in the business maps under the project settings?

    Quick how to would be great..

    Cheers
    CM

    ------------------------------
    Craig Marshall
    Senior Infrastructure Planning Engineer
    Adelaide Hills Council
    Stirling SA
    ------------------------------


  • 2.  RE: Creating Queries in Latest SSA/Spectrum

    Posted 09-15-2020 08:16
    Hi!

    If I understand correctly, you have the same problem that is discussed in here.
    Hopefully you can find your answer from there.

    Regards,

    ------------------------------
    Ott Koik
    Ruumab OÛ
    Tartu
    ------------------------------



  • 3.  RE: Creating Queries in Latest SSA/Spectrum

    Posted 09-15-2020 18:24

    Hey Ott,

    Thanks for the reply.. Excellent wrap up of the situation. Appreciate you help :)

    Cheers
    CM



    ------------------------------
    Craig Marshall
    Senior Infrastructure Planning Engineer
    Adelaide Hills Council
    Stirling SA
    ------------------------------