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

举报
汪子熙 发表于 2022/02/21 20:34:52 2022/02/21
【摘要】 Issue description: account 4024555 下面挂了一个contact 4098335:但是在Fiori ui上,根据Thompson搜索不出这个contact出来:Debug后台逻辑:Search bar里输入的Thompson作为substringof的参数传到后台,按照fullName搜索:https://sap:4080/sap/opu/odata/sap/...

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

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

Debug后台逻辑:

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

https://sap:4080/sap/opu/odata/sap/CRM_TASK/ContactCollection?skip=0&top=20& f i l t e r = a c c o u n t I D 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

[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-VavJYqJE-1581216089285)(https://upload-images.jianshu.io/upload_images/2085791-97550cf76a207d34.png?imageMogr2/auto-orient/strip)]

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,所以搜不出结果:

【版权声明】本文为华为云社区用户原创内容,转载时必须标注文章的来源(华为云社区)、文章链接、文章作者等基本信息, 否则作者和本社区有权追究责任。如果您发现本社区中有涉嫌抄袭的内容,欢迎发送邮件进行举报,并提供相关证据,一经查实,本社区将立刻删除涉嫌侵权内容,举报邮箱: cloudbbs@huaweicloud.com
  • 点赞
  • 收藏
  • 关注作者

评论(0

0/1000
抱歉,系统识别当前为高风险访问,暂不支持该操作

全部回复

上滑加载中

设置昵称

在此一键设置昵称,即可参与社区互动!

*长度不超过10个汉字或20个英文字符,设置后3个月内不可修改。

*长度不超过10个汉字或20个英文字符,设置后3个月内不可修改。