Skip to main content
S
ShaylynJoy1-Visitor
1-Visitor
August 29, 2011
Question

Way to query on iteration changes but not move changes

  • August 29, 2011
  • 4 replies
  • 1232 views


Hi All,


I have an SQL query that brings back any Part that has been iterated and is in a Released state on the current date.


"and TO_CHAR(h.updatestampa2, 'DD-MON-YY')= TO_CHAR(sysdate - 1, 'DD-MON-YY')"


I'm using updatestampa2 column but this also displays parts that have been moved to another location that day and not actually iterated. Does the database seperate in a way that allows us to only query on iteration changes and not move changes?


Thank you!


4 replies

A
AL_ANDERSON12-Amethyst
12-Amethyst
August 29, 2011
Use the last modified date on the Current Phase object linked to the Part
in the Released state via the Current Phase link.

The Current Phase only changes when the object changes to its current
state, which seems to be what you are looking for.

Al






Shaylyn Joy <->
08/29/2011 10:57 AM
Please respond to
Shaylyn Joy <->


To
-
cc

Subject
[solutions] - Way to query on iteration changes but not move changes




Caterpillar: Confidential Green Retain Until: 09/28/2011




Hi All,
I have an SQL query that brings back any Part that has been iterated and
is in a Released state on the current date.
"and TO_CHAR(h.updatestampa2, 'DD-MON-YY')= TO_CHAR(sysdate - 1,
'DD-MON-YY')"
I'm using updatestampa2 column but this also displays parts that have been
moved to another location that day and not actually iterated. Does the
database seperate in a way that allows us to only query on iteration
changes and not move changes?
Thank you!


Site Links: View post online View mailing list online Send new post
via email Unsubscribe from this mailing list Manage your subscription
Use of this email content is governed by the terms of service at:
S
ShaylynJoy1-VisitorAuthor
1-Visitor
August 29, 2011


Hi Albert,


Do you use MODIFYSTAMPA2?


Thank you.


M
MikeLockwood22-Sapphire I
22-Sapphire I
August 29, 2011
Going directly to the database is sometimes helpful / necessary but a query builder report is better for this case.

In the database, UpdatestampA2 includes move - which you don't want to include.
In query builder, "Last Modified" relates to the Iteration and excludes moves.

This criteria returns all Parts Checked In during the past one day. Note that running this on a Monday will not pick up Parts modified the previous Friday - better to make the "1" a parameter instead of a constant so that the user can enter (the attached has it as a parameter).

[cid:image001.png@01CC663F.B8FB6E00]
S
ShaylynJoy1-VisitorAuthor
1-Visitor
August 29, 2011

Thank you Mike.


We are currently using this query in a LogiXML report that is scheduled to email out on a daily basis. Is this something that is not possible in the database but is possible in query builder?


I thought that all query builder reports could be exported as SQL but I may be wrong.


Thanks for your help.



Terms & ConditionsAccessibility statement