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

  • Maik,

    Let me rephrase your question to make sure I properly understand the question.

    What you would like to achieve, is I think, based on a value (3th column for instance - ATKIS_VEG_F), you would like to filter your domain list to display only values from column one that match the ATKIS_VEG_F from column 3. Is that right ?

    If so, when you select the value = ATKIS_VEG_F ? From a previous property ?

    In any case, there is any way to filter a domain list within the same property out of the box. It might achevable with custom code however, this would need to be verified. But, with property watchers you can what I think you talk about. But to do so, you will need get different domain list and different properties. The behavior, is roughly : the domain list for property B is selected based on the value set to property A. This means that you at least have 2 domain list assigned to property B.

    There is a very good example of that in provided the geo_example schema located in C:\ProgramData\Bentley\MapEnterprise V8i\WorkSpace\Projects\Examples\Geospatial\geo_example\xml\schema Under the Address feature. Based on the value you select to State property, you will get a different domain list for the County property, and then based on the value you select to County property, you will get a different domain list for the City property.

    Thanks

    Sebastien Cote

    Regards

    Answer Verified By: Maik Schulze 

  • Hello Sebastien,

    these are very good examples, thanks for the suggestion. What I was trying to achieve is to filter the domain list based on a static value not another property. For instance: show all value1 where value3 is 'ATKIS_VEG_F'. I thought I could use the criteria entry like shown here:

    But I realized how to use the criteria by the help of the geo_example. I wanted to use one domain list (with filters) for all my features, but I better create several domain lists to get to the desired result.

    Thank you,

    Maik

  • Hello Maik and Sebastien,

    Did you manage to get a solution? I don't see it here. I too want to filter the domain list dropdown by one column in the domain list and not by a filter on another feature property.

    Regards,

    Tanya

  • Hi Tanya,

    I couldn't manage to filter by that criteria as I wanted and I split the Domain into several single Domain lists, as I had no time to do try and error. The example in my last screenshot didn't work.

    If you are able to get it configured as you desired, please let us know here Slight smile

    Regards,
    Maik

  • Hello Maik
     
    I’m using a SQL spatial project so I ended up adding a SQL domain and adding the filter into the script. Then I added a dummy criteria to the domain that gets created automatically so that does not get used. Deleting it is not advised because if you reregister features then it will overwrite the domain you created.
    This works but you will need to link the database project with ODBC otherwise it will not read the SQL statement I used.
     
     
    Kept name of Value and Edit columns as they were as I use the SQL script in many features and it easier to change the SQL script
     
    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]>