Download the

Plasma Selection
Guide

Free PDF Download

Viewing Remnant Plate History, Show Related Plates and SQL Search

A new function Show Related Plates has been added to the plate selector in nesting mode. It allows you to view all plates descended from a common ancestor stock plate. It leverages the new SQL Search function to achieve this, and also provides a good example of this functions use.

EXAMPLE

Here we are viewing currently scheduled plates. Plate 13957 we can see is a scheduled on a remnant, and we wish to find out how long this plate has been in stock since the original plate was purchased. By right-clicking on plate 13975, and choosing Show Related Plates…

showrelated1

…we get all plates in this “remnant family”. If we sort the Plate Created column ascending (by clicking on the column header, you may need to click more than once), we can sort the plates into their chronological order. We can see that the first plate, the plate originally purchased, was Plate 13934, and that it was added to stock 11/7/2011. We can then also see that it was cut producing a first offcut 13941, and that this was cut again producing the current scheduled second offcut 13957. Because Show Expected Remnants is ticked we can also see that the skeleton is an “expected remnant” however it is unlikely that this will be kept, it will likely be deleted when plate 13957 is reconciled.

showrelated2

Another means of getting this result would be to use the SQL Search function. First open plate 13957, and look at its properties, in particular the Parent Plate property which shows the IDs of the parent plate and the original plate purchased, in this case 13934 as we saw above:

showrelated4

We can than click on SQL Search and add the SQL selection statement “WHERE p.ADAMPLATEID=13934” which produces the same result as Show Related Plates.

showrelated3

How Do Kinetic Machines

Reduce Cost + Increase Productivity?

Smart Machine Design

Our machines are built for 24/7/365 operation, in order to minimize downtime and keep your business running smoothly three shifts a day.

Learn More

All-In-One Cutting, Drilling & More

See how our K5000xmc plasma cutting system delivers less fixturing, less moving WIP from station to station, and dramatically increased output.

See Video

Best-In-Class Accuracy

We lead the industry in cutting accuracy, milling accuracy and repeatability. Find out how this can help your business save time and maximize production.

Learn More

How Can We Help You?