Accessing alias field of a view in from end

[chandan]

I have created a view with following select statement for a new application in MAXIMO 7.1

View select:POINTNUM,MEASUREDATE,MEASUREMENTVALUE,SITEID,ORGID,OBSERVATION,MEASUREMENTID,ASSETNUM,LOCATION,METERNAME,INSPECTOR,rowstamp,startassetfeatureid,startbasemeasure,startmeasure,startmeasureunitid,startoffset,startoffsetunitid,startyoffset,startyoffsetref,startzoffset,startzoffsetref,assetid,basemeasureunitid,endassetfeatureid,endbasemeasure,endmeasure,endmeasureunitid,endoffset,endoffsetunitid,endyoffset,endyoffsetref,endzoffset,endzoffsetref,(select count(metername) from measurement m where m.measuredate > SYSDATE - INTERVAL '1' HOUR and m.metername = a.metername) AS ALCNT
View where:
metername in (select metername from meter where ishistorian=1 and autosrreq=0)

View from:
measurement a

Problem is ... i can't see the attribute ALCNT of view in the attribute list of the view, but the ALCNT field is visible when we see using SQL Developer connected to same maximo database.

Please suggest me the way to get that field in attribute list.

[amdisuk]

I haven't really come across this sort of use of a view before.

Could you just add ALCNT as a field in the Maximo view and create your relationships in Maximo? I think the problem here is that Maximo doesn't understand the relationship that links ALCNT to the MEASUREMENT table.

Al

[Yesterday]

• PM Estimated Due Date whe... by canislupus [Yesterday at 01:56:48 pm]
• unable to get wpmaterial ... by G Jeevan [Yesterday at 12:28:50 pm]
• KPIMAIN lookup not workin... by G Jeevan [Yesterday at 12:26:23 pm]
• add user access by Sarbjeet.Jassal [Yesterday at 08:04:33 am]
• Not able to access the ma... by Sarbjeet.Jassal [Yesterday at 07:57:40 am]
• How to Connect to Fax Mac... by Dileep Kumar [May 16, 2012, 06:26:22 am]
• Is there a way to track t... by rickmac [May 14, 2012, 06:43:03 am]
• how to change the backgou... by gorgehemtr [May 12, 2012, 06:15:14 am]
• How to break description ... by murugovind [May 11, 2012, 12:40:26 pm]
• Enabling Attachment on CL... by G Jeevan [May 11, 2012, 12:24:33 pm]