| 1 | [[PageOutline]] |
| 2 | = !HowTo set displayed attribute on query = |
| 3 | |
| 4 | == Introduction == |
| 5 | |
| 6 | This feature is to limit the displayed attributes on query. This following document explains how to set displayed attributes on query. |
| 7 | |
| 8 | == Setting up the Mapfile == |
| 9 | |
| 10 | The suggested method to define the displayed attributes is through the layer's METADATA. The available mapfile parameters are defined below: |
| 11 | |
| 12 | * '''query_include_items''': Include these items to display. The string '''all''' can be set to include all items. |
| 13 | * '''query_exclude_items''': Exclude these items to display. |
| 14 | * '''query_*_alias''' : Set the Alias (diplayed label) of an item where '''*''' is replaced by the item name. |
| 15 | |
| 16 | The items name are the exact name retreived in the database. All items in '''query_include_items''' and '''query_exclude_items''' must be separated by a comma. |
| 17 | |
| 18 | == Example of use == |
| 19 | |
| 20 | '''Example 1''' |
| 21 | |
| 22 | {{{ |
| 23 | LAYER |
| 24 | NAME "Parcels" |
| 25 | GROUP "Parcels" |
| 26 | DATA "parcelsDatabase" |
| 27 | STATUS on |
| 28 | TYPE polygon |
| 29 | MAXSCALE 20000 |
| 30 | TEMPLATE "ttt" |
| 31 | METADATA |
| 32 | "SELECTABLE" "TRUE" |
| 33 | "query_include_items" "PARCEL_ID, OWNER, LOCATION" |
| 34 | "query_PARCEL_ID_alias" "# Parcel" |
| 35 | "query_OWNER_alias" "The Owner" |
| 36 | END |
| 37 | CLASS |
| 38 | NAME "Parcels" |
| 39 | STYLE |
| 40 | OUTLINECOLOR 156 156 156 |
| 41 | END |
| 42 | END |
| 43 | END |
| 44 | }}} |
| 45 | |
| 46 | '''Example 2''' |
| 47 | |
| 48 | {{{ |
| 49 | LAYER |
| 50 | NAME "Parcels" |
| 51 | GROUP "Parcels" |
| 52 | DATA "parcelsDatabase" |
| 53 | STATUS on |
| 54 | TYPE polygon |
| 55 | MAXSCALE 20000 |
| 56 | TEMPLATE "ttt" |
| 57 | METADATA |
| 58 | "SELECTABLE" "TRUE" |
| 59 | "query_include_items" "all" |
| 60 | "query_exclude_items" "LOCATION" |
| 61 | "query_PARCEL_ID_alias" "# Parcel" |
| 62 | "query_OWNER_alias" "The Owner" |
| 63 | END |
| 64 | CLASS |
| 65 | NAME "Parcels" |
| 66 | STYLE |
| 67 | OUTLINECOLOR 156 156 156 |
| 68 | END |
| 69 | END |
| 70 | END |
| 71 | }}} |