summaryrefslogtreecommitdiff
path: root/httemplate/search/elements/search.html
diff options
context:
space:
mode:
Diffstat (limited to 'httemplate/search/elements/search.html')
-rw-r--r--httemplate/search/elements/search.html3
1 files changed, 3 insertions, 0 deletions
diff --git a/httemplate/search/elements/search.html b/httemplate/search/elements/search.html
index 4cf187aa0..26e56e657 100644
--- a/httemplate/search/elements/search.html
+++ b/httemplate/search/elements/search.html
@@ -132,6 +132,8 @@ Example:
# insert an Agent column (query needs to be a
# qsearch hashref and header & fields need to
# be defined)cust_pkg_susp.html
+ 'agent_column' => 'COALESCE( cust_main.agentnum, prospect_main.agentnum )',
+ # Arbitrarily override the column used for agentvirt
# sort, link & display properties for fields
@@ -281,6 +283,7 @@ if ( $opt{'agent_virt'} ) {
'null' => $opt{'agent_null'},
'null_right' => $opt{'agent_null_right'},
'table' => $query->{'table'},
+ 'column' => $opt{'agent_column'},
);
# this is ridiculous, but we do have searches where $query has constraints