Skip to Content

List Report - Filter value help with HANA xsodata

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

capture.jpg (24.0 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jul 24 at 08:48 AM

    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>
    
    Add comment
    10|10000 characters needed characters exceeded