List result

The ListResult property returns all members of the list and their member properties as an xml variable. The xml contains element unique names such as keys and all the member properties of the list as properties.

Note that the order of elements in the xml may not correspond to the order of elements in the list. If there are multiple elements with the same unique name in the list, only one of its occurrences will be in the xml.

Note: The content of the first column of your relational result must be unique.

Example

The example is built on a list based on the REGION dimension with the LEVEL_NUMBER member property.

<Table>
 <Row name="[REGION].[All Regions]">
  <Property name="MEMBER_CAPTION" value="All Regions" />
  <Property name="LEVEL_NUMBER" value="0" />
 </Row>
 <Row name="[REGION].[All Regions].[Asia]">
  <Property name="MEMBER_CAPTION" value="Asia" />
  <Property name="LEVEL_NUMBER" value="1" />
 </Row>
 <Row name="[REGION].[All Regions].[Europe]">
  <Property name="MEMBER_CAPTION" value="Europe" />
  <Property name="LEVEL_NUMBER" value="1" />
 </Row>
</Table>

Example: Creating a list of recipients to deliver a book to many recipients

You have groups of colleagues in different countries. You want to create a delivery action so that, when a country is selected from a list, the report is delivered only to the colleagues in the selected country.

In a delivery driving report, you have a list in combo box 'lv_Recipients' with these fields:

FullName (ID), First Name, Last Name, Country, EmailAddress

The list is filtered by another combobox lv_country. lv_Country is the delivery driving combo box in the report book, that is the parameter with the Deliver By checkmark.

The function =lv_Recipients.List.ListResult will return:

<Table>
 <Row name="JohnDoe">
  <Property name="First Name" value="John" />
  <Property name="Last name" value="Doe" />
<Property name="Country" value="US" />
<Property name=" EmailAddress" value="john.doe@infor.com" />
 </Row>
<Row name="JaneDoe">
  <Property name="First Name" value="Jane" />
  <Property name="Last name" value="Doe" />
<Property name="Country" value="US" />
<Property name=" EmailAddress" value="jane.doe@infor.com" />
 </Row>
<Row name="JamesRoe">
  <Property name="First Name" value="James" />
  <Property name="Last name" value="Roe" />
<Property name="Country" value="US" />
<Property name=" EmailAddress" value="james.roe@infor.com" />
 </Row>

In the delivery action of the delivering report, you add this formula to Recipients Input (Email Address):

=GETPROPERTYVALUES(ReportObjects.lv_Recipients.List.ListResult," EmailAddress",";")

The formula will result in this list of recipients: John.doe@infor.com; jane.doe@infor.com;james.roe@infor.com ...

The action will then send out one email to this list of recipients, when the combobox lv_Country =US