"NOT LIKE" operator

Is there any way to effect a "NOT LIKE" or "NOT IN" operator when defining thematic labeling or symbology?

Parents Reply Children
  • Microstation: 08.11.07.443

    Map: 08.11.07.425

    I have a field with values along the lines of "TEST1", "TEST2", "TEST3", etc..

    I'd like to label features that don't have values like that. Actually, I just realized that I can use multiple !='s ANDed together since there are only 3 options currently. However, since the data will change and I'd rather not edit my label style each time, a "NOT LIKE" would be handy.

    Thanks

  • Rob;

    Are you trying to make a decision upon the value and then labeling it accordingly ? For instance

    if (strcmp("Test1", "1") > 1) then <do something> ?

    But you are not wanting to use the actual value stored in the property for the feature instance ?

     

  • Pretty close. In this case, I'm checking the value of the meta_id field (SDSFIE). If the meta_id indicates that the last change was made by a certain party, then I want to label it one way. If it was not changed by that party, then I need to label it differently. The values will be something like

    SomeCo110330

    SomeCo110331

    SomeCo110401

    OtherCo101120

    ...

    I want to label updates by 'SomeCo' in one way, and everything else in another way. I'm trying to make a graphical comparison of the data as I merge it.

    I can handle the first part using a LIKE clause, I just don't have a NOT LIKE to catch features that weren't update by 'SomeCo'. For now, it's not too hard to use ANDed '!='s.

  • Rob;

    The labeling tools was set up to just do fairly simple labeling. If you want to make a graphical comparison based upon the value in each feature instance,you could use the Symbology option for the paticular layer ( feature) in the map manager. Set the symbology type to Thematic, in the first form. You then can specify the feature symbology based upon property values. This also can be saved as a .theme file and reused in another map model.

     

    HTH

    Jerry