SITS: Export field code and name
- Joel Lipman
- Extensible Markup Language
- Hits: 2824
- Microsoft Windows 7 Enterprise
- SITS:Vision Students (v8.7.0)
You might be able to work it out from the online manuals but it took me a while, we wanted to bring back both the code and the lookup value in our XML to our Staging environment.
Why?
Let's take the country of birth of a person as an example as it is expected to be a long list and where just using the parameter &S is not workable. Instead I want to use &G[] and get both the code and the lookup value:
-- What I have: no export format <stu_codc>5826</stu_codc> -- What I could have: export format set to get lookup value -- &GCOD_NAME.COD.SRS <stu_codc>England</stu_codc> -- What I want: export format to get multiple values -- &G[COD.SRS:•<•<COD_CODE.COD•>•>|•<•<COD_NAME.COD•>•>] <stu_codc>5826|England</stu_codc>
- -- What I have: no export format
- <stu_codc>5826</stu_codc>
- -- What I could have: export format set to get lookup value
- -- &GCOD_NAME.COD.SRS
- <stu_codc>England</stu_codc>
- -- What I want: export format to get multiple values
- -- &G[COD.SRS:•<•<COD_CODE.COD•>•>|•<•<COD_NAME.COD•>•>]
- <stu_codc>5826|England</stu_codc>
How?