Like the module name already suggests, this module can be used for advanced data retrieval, making use of user friendly database queries. The advantage of this module comes to life in the middle or bigger production environments. The more data in the database, the more valuable it becomes.Beginning with a clean install of MeasureColor, the database does not contain that much measurement data. Of course you can still search for specific data.


To setup the right query, you can select just one or make a combination of the following terms:
ClientColor method is densityColor strip
Description Dotgain method is densityInk set
Is production modeJob strip current end indexJob strip current start index
Last dateMachineMeasurement condition
Measurement typeNameNumber
Ok sheetPaperPaper white sample
ReferenceSequenceSheet number
Tolerance setUser group
ActiveCompanyDefault mapping
DescriptionNameNumber of zones
Patch heightPatch widthPatches per zone
RepeatsRow count
Default toleranceMachine typeName
Number of colorsNumber of ink zonesZone width
Density standardDotgain methodIlluminant
NameObserver angleUse density poll filter
Use spectral poll filterWhite base
ContentCreated atFlow change
Is production modeIs wetJob
Job stripJob strip end indexJob strip start index
Measurement typeNameOk sheet
ActiveCompany Name
Paper typeSharedWeight
CompanyDefault dotgain listIs spot lib
Average calculatedAverage toleranceDefault measurement condition
Delta CMCCDelta CMCLDelta E method
Delta H calculatedDelta H primaries calc.Delta H primaries tol.
Delta H toleranceDensity calculatedDensity tolerance
Density variationDotgain calculatedDotgain spread
Dotgain toleranceDotgain variationGraybalance calculated
Graybalance toleranceGraybalance variationMax calculated
Max toleranceNamePaper white calculated
Paper white tolerancePrimaries calculatedPrimaries tolerance
Primaries variationScore for gray balanceScore for other
Score for overprintScore for paper whiteScore for primaries
Score for secundariesSecondaries calculatedSecondaries tolerance
Secondaries variationSpotcolor calculatedSpotcolor tolerance
Spotcolor variationUse densitom. dotgain

In the next case, we will be searching for all jobs with reference ISOcoated, measured within the last 90 days, and where the job mode is set to ‘Production’. Above all, this query needs to be saved with the name ‘Coated Production’, for future use.

To get the right information, you need to get used to the many different combinations for setting up the right query. Although all the options may have a dazzling effect, rest assured that retrieving the wrong information, or composing the wrong query, won’t hurt the data at all. Just start over.

For setting up a new query, click on the +-icon in the ‘Criteria’ section.

Where once was ‘ok sheets’, it now says ‘sentence_1’, which means; a new query. For every other single click on the +-icon, a new ‘sentence’ adds up.

In the ‘Selected’ part of the left side of the window, you can give the new query a name. Search for ‘jobs’ in this case. Don’t use the checker for ‘One time only search’. It will prevent you from saving the query.

There is no right order in which you should build your query. In this case we’ll start by adding (+) a rule for the reference. The next rule states something about ‘Last date’. Fill in 90, for ninety days. Last but not least, we need ‘Is production mode is true’ to finalize this query. To save this query, simply hit ‘Save’ at the bottom of this window.

For future use, this query can be found in the drop-down menu ‘Criteria’. When the query is saved, click on the magnifying glass icon. Depending on the content of the database and the kind of connection, data retrieval can take a few seconds.

  • advanced_statistics_module.txt
  • Last modified: 2021/04/28 13:02
  • (external edit)