This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
I have created 2 new fields in Labtrans called Fiststart and Lastfinish.
I then create a view to extend labtrans and my select statement is written as:
select distinct refwo, siteid, orgid,
MIN(CAST(CAST(STARTDATE AS DATE)AS DATETIME) + CAST(STARTTIME AS TIME)) as FIRSTSTART,
MAX(CAST(CAST(FINISHDATE AS DATE) AS DATETIME) + CAST(finishtime AS TIME)) as LASTFINISH
from statement is:
FROM LABTRANS
group by refwo, labtransid, siteid, orgid
I then create a relationship from the view to labtrans.
I add 2 new fields to workorder tracking called labtrans.FirstStart and labtrans.LastFinish, expecting that the data based on the view would populate those fields, but when i enter a labor transaction the fields become read-only..
so what step did i miss?
Shouldn't it be labtrans.relationshipname.firststart ?
On Wed, Mar 13, 2013 at 3:59 PM, shannon sutton
<shannonsuttondale@yahoo.com> wrote:
> I have created 2 new fields in Labtrans called Fiststart and Lastfinish.
> I then create a view to extend labtrans and my select statement is written as:
> select distinct refwo, siteid, orgid,
> MIN(CAST(CAST(STARTDATE AS DATE)AS DATETIME) + CAST(STARTTIME AS TIME)) as FIRSTSTART,
> MAX(CAST(CAST(FINISHDATE AS DATE) AS DATETIME) + CAST(finishtime AS TIME)) as LASTFINISH
> from statement is:
> FROM LABTRANS
> group by refwo, labtransid, siteid, orgid
> I then create a relationship from the view to labtrans.
> I add 2 new fields to workorder tracking called labtrans.FirstStart and labtrans.LastFinish, expecting that the data based on the view would populate those fields, but when i enter a labor transaction the fields become read-only..
> so what step did i miss?
>
I was thinking relationship1.relationhip2.firststart relationship1 being work order to lab trans and relationship2 being from lab trans to the new view.
Sent from my iPhone
On Mar 13, 2013, at 7:12 PM, "Chris Lawless" <lawlessc@gmail.com> wrote:
> Shouldn't it be labtrans.relationshipname.firststart ?
>
> On Wed, Mar 13, 2013 at 3:59 PM, shannon sutton
> <shannonsuttondale@yahoo.com> wrote:
>
> > I have created 2 new fields in Labtrans called Fiststart and Lastfinish.
> > I then create a view to extend labtrans and my select statement is written as:
> > select distinct refwo, siteid, orgid,
> > MIN(CAST(CAST(STARTDATE AS DATE)AS DATETIME) + CAST(STARTTIME AS TIME)) as FIRSTSTART,
> > MAX(CAST(CAST(FINISHDATE AS DATE) AS DATETIME) + CAST(finishtime AS TIME)) as LASTFINISH
> > from statement is:
> > FROM LABTRANS
> > group by refwo, labtransid, siteid, orgid
> > I then create a relationship from the view to labtrans.
> > I add 2 new fields to workorder tracking called labtrans.FirstStart and labtrans.LastFinish, expecting that the data based on the view would populate those fields, but when i enter a labor transaction the fields become read-only..
> > so what step did i miss?
> >
>
>
>
>
So far the only combination that does not cause an invalid binding is LABTRANS.FIRSTSTART, but it is not working as expected..
________________________________
From: john rice <ecirnhoja@msn.com>
To: "MAXIMO@yahoogroups.com" <MAXIMO@yahoogroups.com>
Sent: Thursday, March 14, 2013 12:23 AM
Subject: Re: [MAXIMO List] Using a View to extend LAbtrans
I was thinking relationship1.relationhip2.firststart relationship1 being work order to lab trans and relationship2 being from lab trans to the new view.
Sent from my iPhone
On Mar 13, 2013, at 7:12 PM, "Chris Lawless" <lawlessc@gmail.com> wrote:
> Shouldn't it be labtrans.relationshipname.firststart ?
>
> On Wed, Mar 13, 2013 at 3:59 PM, shannon sutton
> <shannonsuttondale@yahoo.com> wrote:
>
> > I have created 2 new fields in Labtrans called Fiststart and Lastfinish.
> > I then create a view to extend labtrans and my select statement is written as:
> > select distinct refwo, siteid, orgid,
> > MIN(CAST(CAST(STARTDATE AS DATE)AS DATETIME) + CAST(STARTTIME AS TIME)) as FIRSTSTART,
> > MAX(CAST(CAST(FINISHDATE AS DATE) AS DATETIME) + CAST(finishtime AS TIME)) as LASTFINISH
> > from statement is:
> > FROM LABTRANS
> > group by refwo, labtransid, siteid, orgid
> > I then create a relationship from the view to labtrans.
> > I add 2 new fields to workorder tracking called labtrans.FirstStart and labtrans.LastFinish, expecting that the data based on the view would populate those fields, but when i enter a labor transaction the fields become read-only..
> > so what step did i miss?
> >
>
>
>
>