List Report - Filter value help with HANA xsodata

[former_member289890]

Experts,

I have a List report built using Webide Fiori list report template and annotation modeler . Have XSODATA on calculation view as my datasource.

I have selection fields set but by default the search value list is not available.

Can someone help some hint on what should be done to get the value list for selection fields ?

Thanks,

Tanveer

[andrefernandes]

Hi Tanveer, I don't know if you have solved your problem already, but here goes one solution. You need to add a Value List Annotation referring to an Entity Type that contains the Customer Names.

<Annotations Target="visibility-xs.tenant.CustomersType/CustomerName">
    <Annotation Term="Common.ValueList">
        <Record Type="Common.ValueListType">
            <PropertyValue Property="CollectionPath" String="CustomerNames"/> //"CustomerNames" being the Entity Type with all Customer Names
            <PropertyValue Property="Parameters">
                <Collection>
                    <Record Type="Common.ValueListParameterOut">
                        //Mapping, where CustomersType-CustomerName = CustomerNames-CustomerName_External
		        <PropertyValue Property="LocalDataProperty" PropertyPath="CustomerName"/> 
			<PropertyValue Property="ValueListProperty" String="CustomerName_External"/>
		    </Record>
		    <Record Type="Common.ValueListParameterFilterOnly">
		        <PropertyValue Property="ValueListProperty" String="CustomerName_External"/>
		    </Record>
		</Collection>
            </PropertyValue>
	</Record>
    </Annotation>
</Annotations>