Define criteria-based DomainList in Geospatial Admin

Hello everyone,

how is it possible to use the 'Use Criteria' entry in Geospatial Connector Admins Feature property definition? For Explanation look at that:

The Domain List behind is the following:

What I try to achieve is to filter the Domain List entries for the specific Feature through the 3rd column value. I'm using that Domain List for several Features - in each are displayed other values.

Is that possible or what is the 'Use Criteria' entry for? And how would the Syntax look like?

TIA,

Maik

  • Hello Tanya and Maik,

    I have similar problem with domains. Did you solve the problem using one domain and create other domains by filtering first or you just made separate domains which are static?

    Many thanks in advance.

    Mladen

    P.S. I'm using PostGIS and OpenCities SS4

  • Hello Mladen,
     
    The best I found was to work with SQL scripts so that I include a where clause for filtering.
  • Hello Tanya,

    thanks for quick replay.

    Just to be sure, you still use SQL scripts via ODBC connection to database? Or does it works now with direct connection?

    I didn't get idea from your post on November 20th. You have two domains. First is automatically created when you register feature (ATC_RSA_dbo_Asset_Types). I suppose that  first domain contain all Asset_Types from database table.  Second domain is SQL script where you filter it only for CABLES asset. Both domains are on one feature properties (Asset_Typed_ID) and I'm not sure what you use Dummy criteria for?

    If you have time, please write me some details.

    Many thanks in advance.

    Mladen

  • Hello Mladen

    RE: Just to be sure, you still use SQL scripts via ODBC connection to database? Or does it works now with direct connection?

    • Yes, without the ODBC the SQL dropdown does not work even if you connected to the spatial project with direct connection.
     
    RE: I'm not sure what you use Dummy criteria for
    • This is used in the first domain that gets created when registering the feature – unfortunately BM and OpenCities do not recognize feature tables as domain tables which is the lookup I need so I have created a dummy criteria to cancel out this domain which is pointing to a table that is not a spatial table and not the lookup I require. I do not use this domain but I do not delete it because if I add additional changes and reregister my features, it recreates the first domain and I have to redo the second domain.
     
    Kind Regards,
    <![if !vml]> <![endif]>
    <![if !vml]> <![endif]>
    TANYA GELDENHUYS
    Senior Consultant
     
     
     
    T +27 12 345 5330
    M +27 72 762 2450
     
         
    www.theiglobegroup.com
    <![if !vml]> <![endif]>
     
     
  • Hello Tanya,

    I've tried second part with Dummy criteria and really works. After I reregister features both domains are still connected to the feature.

    For the first part of your answer I have one more quick question. In your GSA project you have two connections. First is connection to graphical source (in your case SQL Server I quess) and second is ODBC connection that you use for non spatial tables (domains) with SQL statement. I'm I right?

    Thanks for your time!

    Kind regards,

    Mladen