Sent: Monday, December 29, 2014 3:14 PM

Subject: regarding Sortable and Filterable flag for OpportunityNotes

我们新增的诸如TextObjectID，TextObject description等字段在设计时也要考虑是否支持Sort, filter.下面是印度同事为OpportunityNotes的Creator和CreatedAt维护的sortable和Filterable：

目前对于后台返回的note，只支持按照CreatedAt降序排序，不支持按照creator sort，所以上述的设置是有问题的。

试图按照creator排序报错： https://jerry:4080/sap/opu/odata/sap/CRM_OPPORTUNITY/Opportunities(guid’3440B5B1-73AE-1ED4-A3E4-395AE611C6A1’)?KaTeX parse error: Expected 'EOF', got '&' at position 13: expand=Notes&̲orderby=Creator&sap-client=001

按照createdAt降序排序：( works ) https://jerry4080/sap/opu/odata/sap/CRM_OPPORTUNITY/Opportunities(guid’3440B5B1-73AE-1ED4-A3E4-395AE611C6A1’)?$expand=Notes& $orderby=CreatedAt desc&sap-client=001

按照createdAt升序排序：https://jerry:4080/sap/opu/odata/sap/CRM_OPPORTUNITY/Opportunities(guid’3440B5B1-73AE-1ED4-A3E4-395AE611C6A1’)?$expand=Notes& $orderby=CreatedAt asc&sap-client=001

结果和createdAt降序排序的结果完全相同。