View source for Searching for Custom Field Settings Using a Report

You can [[Importing and Exporting Reports|import]] the following SmartSimple report to search for [[custom fields]] in your system with certain values in the Options/Template/Default Value section of the custom field settings.

When the report is imported, it will be named "Custom Field - Search Contents" and will be located in the "Custom Fields" report category.

When run, the report will prompt you for a text string to be found in the Options/Template/Default Value section of all custom fields in your system and will allow you to view the field settings.

<pre style="white-space: pre-wrap;  white-space: -moz-pre-wrap;  white-space: -pre-wrap;  white-space: -o-pre-wrap;  word-wrap: break-word;"><reportexport>
 <cfmapping></cfmapping>
 <typemapping></typemapping>
 <customfieldlist></customfieldlist>
 <excel_start></excel_start>
 <excel_file>0</excel_file>
 <excel_exformat>1</excel_exformat>
 <excel_mstart></excel_mstart>
 <word_tablebm></word_tablebm>
 <donotrebuild>0</donotrebuild>
 <mergesubrpt>0</mergesubrpt>
 <objectids>9000,</objectids>
 <primaryobjectid>9000</primaryobjectid>
 <fieldlist>,0,844,845,846,842</fieldlist>
 <custabletype></custabletype>
 <totallist>Custom Fields</totallist>
 <totalcustomfield></totalcustomfield>
 <reportfilter></reportfilter>
 <header></header>
 <footer></footer>
 <description>Searches the contents (Options, default values, WPV content etc) for the text entered</description>
 <compiledsql>SELECT customfieldid as objpkey,0 as `~Index~`,customfieldid as 1_customfieldid,name as 2_name,caption as 3_caption,if(allowempty=1,&quot;Yes&quot;,&quot;No&quot;) as 5_allowempty,CONCAT(&quot;&lt;a href=&apos;/s_editcustomfield.jsp?nextlevel=1&amp;entity=&quot;,entity,&quot;&amp;appid=&quot;,CASE WHEN entity in (24,23,26,18,31,28) THEN 102884 WHEN entity=78 THEN itemid ELSE &quot;&quot; END,&quot;&amp;field=&quot;,customfieldid,&quot;&amp;itemid=&quot;,itemid,&quot;&amp;title=Edit&apos; target=&apos;_blank&apos;&gt;View Field&lt;/a&gt;&quot;) as 6_customfieldid FROM SS_System.tblcustomfields
 WHERE (rootcompanyid=@rootcompanyid@) aNd (1=1) AND ((options like concat(&quot;%&quot;,*10_0_850*,&quot;%&quot;))) Group By customfieldid Order By 1_customfieldid ASC </compiledsql>
 <promptmsg>-Enter search term</promptmsg>
 <compiledheader>&quot;#&quot;,&quot;Custom Field ID&quot;,&quot;Field Name&quot;,&quot;Field Caption&quot;,&quot;Allow Empty&quot;,&quot;Edit&quot;</compiledheader>
 <htmlheader>&lt;tr&gt;&lt;th class=Sub&gt;&lt;/th&gt;&lt;th class=Sub&gt;&lt;a class=SubHead href=&quot;javascript:orderreport(&apos;1_customfieldid&apos;)&quot;&gt;Custom Field ID&lt;/a&gt;&lt;/th&gt;&lt;th class=Sub&gt;&lt;a class=SubHead href=&quot;javascript:orderreport(&apos;2_name&apos;)&quot;&gt;Field Name&lt;/a&gt;&lt;/th&gt;&lt;th class=Sub&gt;&lt;a class=SubHead href=&quot;javascript:orderreport(&apos;3_caption&apos;)&quot;&gt;Field Caption&lt;/a&gt;&lt;/th&gt;&lt;th class=Sub&gt;&lt;a class=SubHead href=&quot;javascript:orderreport(&apos;5_allowempty&apos;)&quot;&gt;Allow Empty&lt;/a&gt;&lt;/th&gt;&lt;th class=Sub&gt;&lt;a class=SubHead href=&quot;javascript:orderreport(&apos;6_customfieldid&apos;)&quot;&gt;Edit&lt;/a&gt;&lt;/th&gt;&lt;/tr&gt;</htmlheader>
 <compiledtag>&lt;tr&gt;&lt;td class=Data1&gt;~Index~&lt;/td&gt;&lt;td class=Data1&gt;~1_customfieldid~&lt;/td&gt;&lt;td class=Data1&gt;~2_name~&lt;/td&gt;&lt;td class=Data1&gt;~3_caption~&lt;/td&gt;&lt;td class=Data1&gt;~5_allowempty~&lt;/td&gt;&lt;td class=Data1&gt;~6_customfieldid~&lt;/td&gt;&lt;/tr&gt;</compiledtag>
 <compiledtemplate></compiledtemplate>
 <criteriatemplate></criteriatemplate>
 <recordlimit>0</recordlimit>
 <usenewbuilder>1</usenewbuilder>
 <buildermatrix>&lt;reportbuilder&gt;
 &lt;column&gt;
 &lt;columnindex&gt;0&lt;/columnindex&gt;
 &lt;columnname&gt;#&lt;/columnname&gt;
 &lt;tabletype&gt;9000&lt;/tabletype&gt;
 &lt;fieldtype&gt;9000:0:0&lt;/fieldtype&gt;
 &lt;fields&gt;0 as `~Index~`::0&lt;/fields&gt;
 &lt;columnsql&gt;0 as `~Index~`&lt;/columnsql&gt;
 &lt;visibles&gt;1&lt;/visibles&gt;
 &lt;totals&gt;0&lt;/totals&gt;
 &lt;/column&gt;
 &lt;column&gt;
 &lt;columnindex&gt;1&lt;/columnindex&gt;
 &lt;columnname&gt;Custom Field ID&lt;/columnname&gt;
 &lt;tabletype&gt;9000&lt;/tabletype&gt;
 &lt;fieldtype&gt;9000:0:0&lt;/fieldtype&gt;
 &lt;fields&gt;customfieldid as customfieldid::844&lt;/fields&gt;
 &lt;columnsql&gt;customfieldid as customfieldid&lt;/columnsql&gt;
 &lt;groupby&gt;10&lt;/groupby&gt;
 &lt;sortby&gt;ASC&lt;/sortby&gt;
 &lt;visibles&gt;1&lt;/visibles&gt;
 &lt;totals&gt;0&lt;/totals&gt;
 &lt;/column&gt;
 &lt;column&gt;
 &lt;columnindex&gt;2&lt;/columnindex&gt;
 &lt;columnname&gt;Field Name&lt;/columnname&gt;
 &lt;tabletype&gt;9000&lt;/tabletype&gt;
 &lt;fieldtype&gt;9000:0:0&lt;/fieldtype&gt;
 &lt;fields&gt;name as name::845&lt;/fields&gt;
 &lt;columnsql&gt;name as name&lt;/columnsql&gt;
 &lt;visibles&gt;1&lt;/visibles&gt;
 &lt;totals&gt;0&lt;/totals&gt;
 &lt;/column&gt;
 &lt;column&gt;
 &lt;columnindex&gt;3&lt;/columnindex&gt;
 &lt;columnname&gt;Field Caption&lt;/columnname&gt;
 &lt;tabletype&gt;9000&lt;/tabletype&gt;
 &lt;fieldtype&gt;9000:0:0&lt;/fieldtype&gt;
 &lt;fields&gt;caption as caption::846&lt;/fields&gt;
 &lt;columnsql&gt;caption as caption&lt;/columnsql&gt;
 &lt;visibles&gt;1&lt;/visibles&gt;
 &lt;totals&gt;0&lt;/totals&gt;
 &lt;/column&gt;
 &lt;column&gt;
 &lt;columnindex&gt;4&lt;/columnindex&gt;
 &lt;columnname&gt;Field Description&lt;/columnname&gt;
 &lt;tabletype&gt;9000&lt;/tabletype&gt;
 &lt;fieldtype&gt;9000:0:0&lt;/fieldtype&gt;
 &lt;fields&gt;cusdesp as cusdesp::847&lt;/fields&gt;
 &lt;columnsql&gt;cusdesp as cusdesp&lt;/columnsql&gt;
 &lt;visibles&gt;0&lt;/visibles&gt;
 &lt;totals&gt;0&lt;/totals&gt;
 &lt;/column&gt;
 &lt;column&gt;
 &lt;columnindex&gt;5&lt;/columnindex&gt;
 &lt;columnname&gt;Allow Empty&lt;/columnname&gt;
 &lt;tabletype&gt;9000&lt;/tabletype&gt;
 &lt;fieldtype&gt;9000:0:0&lt;/fieldtype&gt;
 &lt;fields&gt;if(allowempty=1,&quot;Yes&quot;,&quot;No&quot;) as allowempty::842&lt;/fields&gt;
 &lt;columnsql&gt;if(allowempty=1,&quot;Yes&quot;,&quot;No&quot;) as allowempty&lt;/columnsql&gt;
 &lt;visibles&gt;1&lt;/visibles&gt;
 &lt;totals&gt;0&lt;/totals&gt;
 &lt;/column&gt;
 &lt;column&gt;
 &lt;columnindex&gt;6&lt;/columnindex&gt;
 &lt;columnname&gt;Edit&lt;/columnname&gt;
 &lt;tabletype&gt;9000&lt;/tabletype&gt;
 &lt;fieldtype&gt;9000:0:0&lt;/fieldtype&gt;
 &lt;fields&gt;customfieldid as customfieldid::844&lt;/fields&gt;
 &lt;columnsql&gt;CONCAT(&quot;@lt@a href=&apos;/s_editcustomfield.jsp?nextlevel=1@at@entity=&quot;,entity,&quot;@at@appid=&quot;,CASE WHEN entity in (24,23,26,18,31,28) THEN 102884 WHEN entity=78 THEN itemid ELSE &quot;&quot; END,&quot;@at@field=&quot;,customfieldid,&quot;@at@itemid=&quot;,itemid,&quot;@at@title=Edit&apos; target=&apos;_blank&apos;@gt@View Field@lt@/a@gt@&quot;) as customfieldid&lt;/columnsql&gt;
 &lt;advcus&gt;CONCAT(&quot;@lt@a href=&apos;/s_editcustomfield.jsp?nextlevel=1@at@entity=&quot;,[9],&quot;@at@appid=&quot;,CASE WHEN [9] in (24,23,26,18,31,28) THEN 102884 WHEN [9]=78 THEN [8] ELSE &quot;&quot; END,&quot;@at@field=&quot;,[2],&quot;@at@itemid=&quot;,[8],&quot;@at@title=Edit&apos; target=&apos;_blank&apos;@gt@View Field@lt@/a@gt@&quot;)&lt;/advcus&gt;
 &lt;visibles&gt;1&lt;/visibles&gt;
 &lt;totals&gt;0&lt;/totals&gt;
 &lt;/column&gt;
 &lt;column&gt;
 &lt;columnindex&gt;7&lt;/columnindex&gt;
 &lt;columnname&gt;Item ID&lt;/columnname&gt;
 &lt;tabletype&gt;9000&lt;/tabletype&gt;
 &lt;fieldtype&gt;9000:0:0&lt;/fieldtype&gt;
 &lt;fields&gt;itemid as itemid::839&lt;/fields&gt;
 &lt;columnsql&gt;itemid as itemid&lt;/columnsql&gt;
 &lt;visibles&gt;0&lt;/visibles&gt;
 &lt;totals&gt;0&lt;/totals&gt;
 &lt;/column&gt;
 &lt;column&gt;
 &lt;columnindex&gt;8&lt;/columnindex&gt;
 &lt;columnname&gt;Entity&lt;/columnname&gt;
 &lt;tabletype&gt;9000&lt;/tabletype&gt;
 &lt;fieldtype&gt;9000:0:0&lt;/fieldtype&gt;
 &lt;fields&gt;entity as entity::840&lt;/fields&gt;
 &lt;columnsql&gt;entity as entity&lt;/columnsql&gt;
 &lt;visibles&gt;0&lt;/visibles&gt;
 &lt;totals&gt;0&lt;/totals&gt;
 &lt;/column&gt;
 &lt;column&gt;
 &lt;columnindex&gt;9&lt;/columnindex&gt;
 &lt;columnname&gt;Options/Template/Default Value&lt;/columnname&gt;
 &lt;tabletype&gt;9000&lt;/tabletype&gt;
 &lt;fieldtype&gt;9000:0:0&lt;/fieldtype&gt;
 &lt;fields&gt;options as options::850&lt;/fields&gt;
 &lt;columnsql&gt;options as options&lt;/columnsql&gt;
 &lt;visibles&gt;0&lt;/visibles&gt;
 &lt;totals&gt;0&lt;/totals&gt;
 &lt;criteria1&gt;like concat(&quot;%&quot;,???,&quot;%&quot;)&lt;/criteria1&gt;
 &lt;/column&gt;
 &lt;columnmapping&gt;#==~Index~;;Custom Field ID==~1_customfieldid~;;Field Name==~2_name~;;Field Caption==~3_caption~;;==;;Allow Empty==~5_allowempty~;;Edit==~6_customfieldid~;;==;;==;;==;;&lt;/columnmapping&gt;
 &lt;/reportbuilder&gt;</buildermatrix>
 <issingleview>0</issingleview>
 <rinetenabled>0</rinetenabled>
 <singleviewtemplate></singleviewtemplate>
 <compiledsingleview></compiledsingleview>
 <cacheenabled>0</cacheenabled>
 <hideglobaltemplate>0</hideglobaltemplate>
 <cacheinterval>0</cacheinterval>
 <cacheuser>0</cacheuser>
 <straightjoin>0</straightjoin>
 <enabletranslate>0</enabletranslate>
 <noparas>0</noparas>
 <name>Custom Field - Search Contents</name>
 </reportexport>
 </pre>

==See Also==
* [[Importing and Exporting Reports]]
* [[Reporting on Custom Fields]]

[[Category:Reports]][[Category:Custom Fields]]