Open main menu

Changes

Searching for Custom Field Settings Using a Report

9,388 bytes added, 17:01, 3 April 2014
Created page with "You can import the following SmartSimple report to search for custom fields in your system with certain values in the Options/Template/..."
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]]
Arthur Lathrop
8,849
edits
Retrieved from ‘https://wiki.smartsimple.com/wiki/Special:MobileDiff/21587’