将自定义字段添加到 Maximo 结果集 [英] Add custom fields to Maximo Result Set

问题描述

我使用的是 Maximo 7.5，并且在自定义表中添加了几列.如何在 Startcenter 结果集中获取这些列.新字段在工单应用程序中可见

I'm using Maximo 7.5 and I added few columns to an custom table. How to get those columns in Startcenter result set. The new fields are visible in Workorder application

推荐答案

如果您使用的是较旧的修订包，则需要在 RESULTSETCOLS 中插入一行，如下面的插入语句所示，该语句摘自 本技术说明.请注意，您需要调整前三列的值以满足您的需要.

If you're on an older fix pack, you'll need to insert a row into RESULTSETCOLS, as demonstrated by the insert statement below which was excerpted from this Technote. Note that you will need to adjust the values for the first three columns to suit your needs.

insert into resultsetcols
( app, attribute, maintable, resultsetcolsid ,rowstamp)
values
('WOTRACK', 'LOCATION.DESCRIPTION', 'WORKORDER', resultsetcolsseq.nextval, maxseq.nextval);

但是，如果您使用的是 Maximo 7.5.0.7+，则可以使用前端来实现您的目标.如本技术说明(讨论 7.6 但也适用于7.5.0.7+)...

However, if you're on Maximo 7.5.0.7+, you can use the front end to accomplish your goals. As detailed in this Technote (which talks about 7.6 but also applies to 7.5.0.7+)...

1. 基于结果集查询来自的应用程序的主表创建对象结构.将 Consumed By 设置为 REPORTING 并在第二级或更低级别的结果集中包含要显示数据的对象非常重要.
2. 使用报告管理"应用程序中的设置报告对象结构安全性"选项授予自己使用刚刚创建的对象结构的权限.
3. 创建/编辑结果集并选择要包含的字段.(注意:如果结果集设置屏幕缺少对象列表树控件，您可能需要将 webclient.resultset.relatedattributes 系统属性更改为 1，如 本技术说明.)

1. Create an Object Structure based on the Main Table of the application the Result Set's Query is from. It is important to set Consumed By to REPORTING and include objects you want to show data from in your Result Set on the second or lower level.
2. Use the Set Report Object Structure Security option in the Report Administration application to grant yourself permission to use the Object Structure you just created.
3. Create/edit the Result Set and choose the fields you want to include. (Note: If the Result Set Setup screen lacks an Object List tree-control, you probably need to change the webclient.resultset.relatedattributes System Property to 1, as detailed in this Technote.)

希望有所帮助.

这篇关于将自定义字段添加到 Maximo 结果集的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！