前往小程序,Get更优阅读体验!
立即前往
首页
学习
活动
专区
工具
TVP
发布
社区首页 >专栏 >SAP Fiori 应用无法根据contact搜索的原因分析

SAP Fiori 应用无法根据contact搜索的原因分析

原创
作者头像
Jerry Wang
修改2020-02-12 14:53:36
3950
修改2020-02-12 14:53:36
举报

Issue description: account 4024555 下面挂了一个contact 4098335:

但是在Fiori ui上,根据Thompson搜索不出这个contact出来:

Debug后台逻辑:

Search bar里输入的Thompson作为substringof的参数传到后台,按照fullName搜索:

https://sap.corp:4080/sap/opu/odata/sap/CRM_TASK/ContactCollection?$skip=0&$top=20&$filter=accountID%20eq%20%274024555%27%20and%20substringof(%27Thompson%27,fullName)&$inlinecount=allpages

accountID:

fullname:

cl_crm_bp_odata_rt

select_entityset_by_sql

from

where

select contact~partner AS contact_id, contact~partner_guid AS contact_guid, contact~persnumber AS pers_number, contact~name_last AS name_last, contact~name_first AS name_first, contact~birthdt AS birthdate, contact~title AS title, contact~title_aca1 AS title_aca1, account~partner AS account_id, account~partner_guid AS account_guid, account~name_org1 AS company_name1, account~name_org2 AS company_name2, account~name_last AS ACCOUNT_NAME_LAST, account~name_first AS ACCOUNT_NAME_FIRST, account~name_grp1 AS ACCOUNT_NAME_GRP1, account~name_grp2 AS ACCOUNT_NAME_GRP2, account~type AS account_category, account~persnumber AS account_pers_number, cp_relation~fnctn AS function, cp_relation~dprtmnt AS department, relation_cp~xdfrel AS is_main_contact, relation_cp~crdat AS contact_crdat, relation_cp~crtim AS contact_crtim, contact~mc_name1 AS contact_mc_name1, contact~mc_name2 AS contact_mc_name2, account~mc_name1 AS account_mc_name1

最后很清楚了,contact 4098335 在BUT000中的数据,MC_NAME1和MC_NAME2­都不包含输入的string,所以搜不出结果:

原创声明:本文系作者授权腾讯云开发者社区发表,未经许可,不得转载。

如有侵权,请联系 cloudcommunity@tencent.com 删除。

原创声明:本文系作者授权腾讯云开发者社区发表,未经许可,不得转载。

如有侵权,请联系 cloudcommunity@tencent.com 删除。

评论
登录后参与评论
0 条评论
热度
最新
推荐阅读
领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档