LIMS.eu

When performing calculations with formulas, it is possible to access additional information:

Using the following schema, you can access master data of the sample, other samples, or even results of other samples:

Master data of the same sample:
Please strictly observe the correct capitalization of the master data field labels.
stammdatenfeld('masterdatafield')
e.g.: stammdatenfeld('DDF_Quantity')

Master data of another sample ID:
stammdatenfromsample(1234, 'DDF_Quantity')

Values in a column of another sample ID:
valuefromsample(sample ID, Parametershort, column)
e.g.: valuefromsample(1234,'pH', 0)

Specifications / Rules

Master data of a specification:
stammdatenfromspec(Specs-ID, 'master data field')
e.g.: stammdatenfromspec(123,'DDF_SOP')

Master data of the linked specification:
stammdatenfromthisspec('master data field')
e.g.: stammdatenfromthisspec('DDF_SOP')

Target value of column X of the parameter:
sollwert(column)
e.g.: sollwert(0)

Target value 1 or 2 of column X of the parameter when it is a range, e.g., pH value 6.5 - 9.5:
sollwert(column, 'value' )
e.g.: sollwert(0, 'value' )
or
sollwert(column, 'value2' )
e.g.: sollwert(0, 'value2' )

Target value 1 or 2 of an assigned type of column X of the parameter:
sollwert(column, 'value', 'Type' )
e.g.: sollwert(0, 'value', 'Limit Value' )

Master data field of a target value:
sollwert(column, DDF_Field)
e.g.: sollwert(column, 'DDF_Type')

Materials / Batches

Master data of the material of a batch (DDF_Fields and material_name):
getbatchdata(batch.id, 'material_DDF_field')
e.g.: getbatchdata(this(0), 'material_DDF_Synonyms')

Master data of a batch (only for the master data fields: DDF_Density, DDF_concentration, DDF_value, and Customer_id):
getbatchdata(batch.id, 'DDF_field')
e.g.: getbatchdata(this(0), 'DDF_Density')

Additional examples:
Name of the manufacturer linked to a batch:
getcustomerdata(getbatchdata(batch.id,'customer_id'))
z.B.:getcustomerdata(getbatchdata(this(1),'customer_id'))

Expiration date of a batch:
getbatchdata(batch.id, 'valid_till'))
z.B.:getbatchdata(this(1), 'valid_till'))

Master data of an order:
getorderdata(Orders-ID, 'master data field')
z.B.: getorderdata(123,'DDF_SOP')

Master data of a customer:
getcustomerdata(Customer-ID, 'master data field')
z.B.: getcustomerdata(123,'DDF_SOP')

Master data of a Parameter:
stammdatenfromparameter(Parametertypes-ID, 'master data field')
z.B.: stammdatenfromparameter(123,'DDF_SOP')
==> When replacing a parameter, this function of course still works on the ID that was stored here

Master data of this Parameter:
stammdatenfromthisparameter( 'master data field')
z.B.: stammdatenfromthisparameter('DDF_SOP')