Changes

Searching for Custom Field Settings Using a Report

1 byte added, 08:29, 8 April 2014

m

Changed "Enter search term" to "-Enter search term"

<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>

• ← Older edit
• Newer edit →

0

edits