MapThat Admin – Requested Value ‘Any’ Was Not Found

Question:

How can I resolve the error – “Requested Value ‘Any’ Was Not Found” ?

Answer:

MapThat allows you to define what type of Geometry a user can edit and create for any specific layer when using the MapThat Drawing Tools. For example, you may wish users to only create Points for your Schools layer or Polylines for your Bus Routes layer. This option can be defined layer by layer, by simply stating a value in the VE_Layers.Edit_Geometry_Type field. 

Valid values in this field are:

• Any – Uses any of the Drawing Tools
• Point – Only allows the user to use the Point Drawing Tool
• LineString– Only allows the user to use the Polyline Drawing Tool
• Polygon– Only allows the user to use the Polygon Drawing Tools
• MultiPoint– Only allows the user to use the Point Drawing Tool
• MultiLineString– Only allows the user to use the Polyline Drawing Tool
• MultiPolygon– Only allows the user to use the Polygon Drawing Tools

This value is case sensitive, so if the value is either incorrectly spelt or has been entered in full capitals then MapThat will generate an error message as per the below:

To resolve the error message, simply correct the value in the VE_Layers.Edit_Geometry_Type field and save the SQL table.

You can update all the records in the VE_Layers table by using the following SQL statement (replacing the value of ‘Polygon’ as required):