system.mes.spc.sample.getSampleList(sampleFilter)

Sepasoft MES Module Suite

system.mes.spc.sample.getSampleList(samplefilter)

Returns a sample list that matches the filter parameter. Used with system.mes.spc.sample.data.createFilter(location_path).

For sort keys, see sortType Key.

system.mes.spc.sample.getSampleList(samplefilter) → Dataset

Syntax

system.mes.spc.sample.data.getSampleList(samplefilter) 

  • Parameters

MESSampleFilter sampleFilter - MES Sample filter to use.

  • Returns

Dataset - Samples for a specified location path (equipment path with a sampling location configured).

  • Scope

All

Code Example

Copy Code
Python
location_path = "Enterprise\Site 1\Area 1\Location 1"

sample_filter = system.mes.spc.sample.createFilter(location_path)
sample_filter.setSortType("Taken Date Time (Descending)")
sample_filter.setLocationPath(location_path)
sample_filter.setStartDate(system.date.addMinutes(system.date.now(), -2))
sample_filter.setEndDate(system.date.addMinutes(system.date.now(), 4))
#sample_filter.setStartDate(system.date.parse("2021-11-05 13:00:00"))
#sample_filter.setEndDate(system.date.parse("2021-11-05 23:00:00"))

sample_filter.setShowDueSamples(True)

sample_filter.setShowComingDueSamples(True)

sample_filter.setShowOverDueSamples(True)
sample_filter.setShowWaitingApproval(False)
sample_filter.setShowApprovedSamples(False)
sample_filter.setShowRemovedSamples(False)
print "State:",  sample_filter.getSampleStateTypes().getState()


results = system.mes.spc.sample.getSampleList(sample_filter)
print results.getRowCount()
print results.getColumnNames()
for i in range(results.getRowCount()):
	row = []
	for j in range(results.getColumnCount()):
		row.append(results.getValueAt(i, j))
	print row




Sepasoft MES Module Suite