• State Verified Answer
  • +1 person also asked this people also asked this
  • Replies 11 replies
  • Subscribers 61 subscribers
  • Views 3706 views
  • Users 0 members are here

Define criteria-based DomainList in Geospatial Admin

Maik Schulze
Offline

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

Parents
  • 0 Offline

    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]>
     
     
Reply
  • 0 Offline

    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]>
     
     
Children
  • 0 Offline in reply to Tanya Geldenhuys

    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

Communities
Support and Services
Training and Learning
Social Media