如何在 ATG 存储库结构中表示 Oracle 视图
我有一些跨 ATG 存储库的查询。我不知道如何将存储库链接在一起以便将数据从一个存储库提供到另一个存储库。这些查询确实有一些共谋性,因此尝试手动构建它们将需要大量代码行。
所以我的想法是,我可以使用查询创建一个视图,然后将存储库定义附加到它。但是,根据存储库 xml 文件的 DTD,需要使用的表名称是什么?
谢谢
I have some queries which cross repositories in ATG. I am not aware of a way to link repositories together in order to provide data from one repository to the other. The queries do have some complicity to them such that trying to build them by hand will take a lot of lines of code.
So my thought is that I could just create a view with the query and then attach the repository definition to it. But, what would be the table name that would be required to use based on the DTD for the repository xml file?
Thanks
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(2)
不确定这是否是您正在寻找的内容,但可以链接 ATG 中的存储库。一个存储库中的存储库项目的属性可以引用不同存储库中的另一个存储库项目。手册中的示例是:
您需要添加的唯一属性是“repository”属性,它是您要链接的项目所在的存储库组件的核心路径。现在查询“员工”地址不应该是一个如此费力的查询。
Not sure if this is what you're looking for but it is possible to link repositories in ATG. A property from a repository item in one repository can reference another repository item in a different repository. The example in the manuals is:
The only attribute you need to add is the 'repository' attribute, which is the nucleus path to the repository component that the item you are linking to resides. Querying for an "employee" address should not be such a laborious query now.
您提供的表名称应该只是视图名称。确保将其标记为只读,假设您的视图被设计为只读(大多数视图都是只读的)。某些数据库支持对视图进行写入操作,然后填充基础表,如果是这种情况,您还需要相应地使缓存无效,以确保您的用户看到适当的数据。
The table name you provide should simply be the view name. Make sure and mark it as read only, assuming your view is designed to be read only, which most are. Some databases support write operations to views which then populate underlying tables, if this is the case, you will also want to invalidate caches accordingly to ensure your users are seeing the appropriate data.