title: How does CRM 2011 auto-wire the StringMapBase table in for Option List picks in Advanced Finds?
body: <p>The StringMapBase SQL table is the table that holds Option List values that have been added to an entity. When using an Advanced Find in CRM 2011, if you select a pick list column (Option List) value from an entity to be added to the resultset, the Advanced Find mechanism somehow auto-wires in the string value of the pick list from the StringMapBase table instead of showing the StringMapBase's Primary Key value that's actually stored on the record.</p>
  
  <p>I'm in the process of creating SSRS reports that hinge on some Option List values:</p>
  
  <pre><code>// SQL psuedocode
  Select...
  ...
  Where Value = 'Some String Value of Interest'
  </code></pre>
  
  <p>However, I very much dislike the fact that, so far, it looks like I basically have to write in some ad-hoc SQL in order to get the applicable StringMapBase value. In order to do so, I have to hard-code some magic values, which I despise.</p>
  
  <p>Does anyone know by what mechanism the CRM Advanced Find engine auto-wires these values in? Or does it simply do its own join to the StringMap system view or use a SPROC somewhere?</p>