首页
学习
活动
专区
工具
TVP
发布
社区首页 >问答首页 >如何在HYBRIS中使用Impex从集合中删除一个值?

如何在HYBRIS中使用Impex从集合中删除一个值?
EN

Stack Overflow用户
提问于 2019-02-17 19:58:42
回答 3查看 3.9K关注 0票数 2

我正在尝试扩展OOTB Impex以从customersupportmanagergroup中删除customersupportagentrole,但它不起作用。请帮帮忙。

这里是OOB Impex。

代码语言:javascript
复制
INSERT_UPDATE CsAgentGroup;UID[unique=true];locname[lang=en];groups(uid)[mode=append];description
;customersupportmanagergroup;Customer Support Manager Group;customersupportmanagerrole,customersupportagentrole,csagentgroup,csagentmanagergroup;The Customer Support Manager Group has access to the Customer Support Backoffice's Customer Support Manager Group and Customer Support Agent Group views AND/OR the Assisted Service Module.
;customersupportagentgroup;Customer Support Agent Group;customersupportagentrole,csagentgroup;The Customer Support Agent Group has access to the Customer Support Backoffice's Customer Support Agent Group views and AND/OR the Assisted Service Module.

这是我从customersupportmanagergroup组中删除customersupportagentrole的Impex

代码语言:javascript
复制
INSERT_UPDATE CsAgentGroup;UID[unique=true];locname[lang=en];groups(uid)[mode=append];description
;customersupportmanagergroup;Customer Support Manager Group;customersupportmanagerrole,csagentgroup,csagentmanagergroup;The Customer Support Manager Group has access to the Customer Support Backoffice's Customer Support Manager Group and Customer Support Agent Group views AND/OR the Assisted Service Module.
;customersupportagentgroup;Customer Support Agent Group;customersupportagentrole,csagentgroup;The Customer Support Agent Group has access to the Customer Support Backoffice's Customer Support Agent Group views and AND/OR the Assisted Service Module.
EN

回答 3

Stack Overflow用户

发布于 2019-02-18 22:00:01

您正在使用mode=append,它基本上将您的值附加到现有的集合(组)中。在您的例子中,一些Impex(OOTB)可能在Impex执行之前已经将customersupportagentrole添加到customersupportmanagergroup。现在Impex不会覆盖现有的值,它只是追加。所以尝试使用mode=replace,,它基本上覆盖了现有的值。

代码语言:javascript
复制
INSERT_UPDATE CsAgentGroup; UID[unique=true]            ; groups(uid)[mode=replace]                                   ;                  
                          ; customersupportmanagergroup ; customersupportmanagerrole,csagentgroup,csagentmanagergroup ;                  
                          ; customersupportagentgroup   ; customersupportagentrole,csagentgroup                       ;                  
票数 3
EN

Stack Overflow用户

发布于 2019-02-26 21:48:20

您可以这样做,如果您不在组中使用模式运算符,它将用您指定的组件替换集合

INSERT_UPDATE CsAgentGroup;UIDunique = true;groups(uid) ;;customersupportmanagergroup;csagentgroup,csagentmanagergroup;

或者,如果您放置mode=remove,它将删除您指定的组件

INSERT_UPDATE CsAgentGroup;UIDunique = true;groups(uid) mode=remove ;;uid

票数 2
EN

Stack Overflow用户

发布于 2019-02-20 16:10:08

您希望对 customersupportmanagergroup组进行更新,以便删除将customersupportmanagergroup组连接到customersupportagentrole的任何链接,而customersupportagentrole仍然存在于数据库中。使用remove query将从数据库中删除customersupportagentrole。

代码语言:javascript
复制
UPDATE CsAgentGroup;UID[unique=true];groups(uid)
;customersupportmanagergroup;customersupportmanagerrole,csagentgroup,csagentmanagergroup
票数 0
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/54733015

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档