Skip to Content
0
Nov 23, 2021 at 03:15 PM

SAP Asset Manager - Target alternatives

393 Views Last edit Nov 23, 2021 at 03:17 PM 2 rev

Hello,

I'm working ion the SAM2010 implementation with some additional components (Meter management)

I'm trying to perform some customizations.

For instance, i need to execute the next OData query, in the RouteDetails.page

"Target": { 
"EntitySet": "{{#Property:@odata.readLink}}/StreetRouteConnObj_Nav", 
"Service": "/SAPMeterManager/Services/AssetManager.service", 
"QueryOptions": "$filter=StreetRoute_Nav/any(sr: sap.entityexists(sr/Device_Nav/PeriodicMeterReading_Nav))&$expand=StreetRoute_Nav,ConnectionObject_Nav/AuthorizationGroup_Nav,ConnectionObject_Nav/PolRegStructElement_Nav,ConnectionObject_Nav/ConnectionObjectMRNote_Nav,ConnectionObject_Nav/Devices_Nav,ConnectionObject_Nav/FuncLocation_Nav/Address,ConnectionObject_Nav/FuncLocation_Nav/Partners,ConnectionObject_Nav/FuncLocation_Nav/RelatedWOHistory,ConnectionObject_Nav/FuncLocation_Nav/NotifHistory_Nav,ConnectionObject_Nav/FuncLocation_Nav/ObjectStatus_Nav/SystemStatus_Nav,ConnectionObject_Nav/Premises_Nav&$orderby=ConnectionObject_Nav/Premises_Nav/StreetSupplement2" },
  
This query is intended to retrieve the connection objects and perform an orderby using the field StreetSupplement2. The query retrieves the data, however it is not ordered as expected.
Is there an alternative to perform this query and then using javascript to customize the code to order the result based on the required field?Best Regards.