Form:SMART BenefitDrilldown - Revision history

Barry.grenon@genesys.com at 21:29, March 11, 2021

2021-03-11T21:29:32Z

2020-11-16T22:20:44Z

2020-11-16T22:20:13Z

2020-11-16T22:19:24Z

2020-11-16T22:19:03Z

2020-11-16T22:18:37Z

2020-11-16T22:17:19Z

2020-01-06T16:36:32Z

2020-01-06T16:35:55Z

2020-01-06T16:33:23Z

@@ Line 12: / Line 12: @@
 {{{end template}}}
 {{#css: #pf-expand-all {display:none} }}
 <nowiki /></includeonly><noinclude>[[Category:SMART_Cargo]]</noinclude>

@@ Line 4: / Line 4: @@
 <includeonly>{{{info|query form at top|query title=&nbsp;}}}
 {{{for template|SMART_BenefitDrilldown}}}
-{{{field|CanonicalBenefit|input type=combobox|values={{#cargo_query:tables=SMART_Benefits|fields=CanonicalBenefitID|where=CanonicalBenefitID IS NOT NULL|no html}} }}}
+{{{field|CanonicalBenefit|input type=combobox|values={{#cargo_query:tables=SMART_Benefits|fields=CanonicalBenefitID|where=CanonicalBenefitID IS NOT NULL|no html|group by=CanonicalBenefitID}} }}}
 <div style="display:none;">
 {{{field|TestTinyMCE|input type=textarea|editor=visualeditor}}}

@@ Line 4: / Line 4: @@
 <includeonly>{{{info|query form at top|query title=&nbsp;}}}
 {{{for template|SMART_BenefitDrilldown}}}
-{{{field|CanonicalBenefit|input type=combobox|values={{#cargo_query:tables=SMART_Benefits|fields=CanonicalBenefitID|no html}} }}}
+{{{field|CanonicalBenefit|input type=combobox|values={{#cargo_query:tables=SMART_Benefits|fields=CanonicalBenefitID|where=CanonicalBenefitID IS NOT NULL|no html}} }}}
 <div style="display:none;">
 {{{field|TestTinyMCE|input type=textarea|editor=visualeditor}}}

@@ Line 4: / Line 4: @@
 <includeonly>{{{info|query form at top|query title=&nbsp;}}}
 {{{for template|SMART_BenefitDrilldown}}}
-{{{field|CanonicalBenefit|input type=combobox|values={{#cargo_query:tables=SMART_Benefits|field=CanonicalBenefitID|no html}} }}}
+{{{field|CanonicalBenefit|input type=combobox|values={{#cargo_query:tables=SMART_Benefits|fields=CanonicalBenefitID|no html}} }}}
 <div style="display:none;">
 {{{field|TestTinyMCE|input type=textarea|editor=visualeditor}}}

@@ Line 4: / Line 4: @@
 <includeonly>{{{info|query form at top|query title=&nbsp;}}}
 {{{for template|SMART_BenefitDrilldown}}}
-{{{field|CanonicalBenefit|input type=combobox|values={{#cargo_query:tables=SMART_Benefits|field=CanonicalBenefitID}} }}}
+{{{field|CanonicalBenefit|input type=combobox|values={{#cargo_query:tables=SMART_Benefits|field=CanonicalBenefitID|no html}} }}}
 <div style="display:none;">
 {{{field|TestTinyMCE|input type=textarea|editor=visualeditor}}}

@@ Line 2: / Line 2: @@
 This is the 'SMART_BenefitDrilldown' form. The form is used via the [[Special:RunQuery/SMART_BenefitDrilldown|special 'run query']] page.
 </noinclude>
-<includeonly>{{{info|query form at top|query title=}}}
+<includeonly>{{{info|query form at top|query title=&nbsp;}}}
 {{{for template|SMART_BenefitDrilldown}}}
 {{{field|CanonicalBenefit|input type=combobox|cargo table=SMART_Benefits|cargo field=CanonicalBenefitID|placeholder=Select a benefit }}}