Does anyone know how to add Constituency to Output Set Builder? Thanks.
Hi Elizabeth,
Are you on V10 or V11? I can't seem to find the most recent version of the Output Set Builder Cookbook on the website here but I do have an older one saved on my computer. This should give you the constituency string (from the header) for V10. And maybe V11....? Good luck!
800x600 Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4
This element outputs the constituency string that is used in the Constituent Header.
Column Name
Example Value
Description
Constituency_String
Category
Custom
Data_Select
!.constit
Data_From
(select customer_no, dbo.fs_const_string(customer_no) as 'constit', list_no from t_list_contents)
Data_Where
list_no = <<p##>>
Control_Group
[Blank]
Single_row
[Checked]
List
Data_Type
Number
End_Of_Day
[Unchecked]
Multi_Select
Ref_Tbl
vs_list
Ref_Idcol
list_no
Ref_Desccol
list_desc
Ref_Where
Ref_sort