GetAll(Nullable<Int32>,String,String,Nullable<Int32>,Nullable<Int32>,Nullable<Double>,Nullable<Boolean>,Nullable<Boolean>,Nullable<Boolean>,Nullable<Boolean>,Nullable<Boolean>,Nullable<Boolean>,Nullable<Boolean>,Nullable<Boolean>,Nullable<Boolean>,Nullable<Boolean>,Nullable<Boolean>,Nullable<Boolean>,Nullable<Boolean>,Nullable<Boolean>,Nullable<Boolean>,Nullable<Boolean>,Nullable<Boolean>,Nullable<Boolean>,Nullable<Boolean>,Nullable<Int32>,Nullable<Int32>,Nullable<Boolean>,String,String,String,String,String,Nullable<DateTime>) Method
- Last UpdatedMar 17, 2026
- 8 minute read
The GetAll() method retrieves one or more entity records from the Ent table, as specified by the filter parameters. Passing no filter parameters will retrieve all entity records from the table.
This overload of the method includes the canCaptureQmData and the can*FromGalaxy flags.
'Declaration
Public Overloads Shared Function GetAll( _
ByVal entId As Nullable(Of Integer), _
ByVal entName As String, _
ByVal description As String, _
ByVal parentEntId As Nullable(Of Integer), _
ByVal site As Nullable(Of Integer), _
ByVal hourlyCost As Nullable(Of Double), _
ByVal canSchedJobs As Nullable(Of Boolean), _
ByVal canRunJobs As Nullable(Of Boolean), _
ByVal canCaptureUtil As Nullable(Of Boolean), _
ByVal canCaptureLabor As Nullable(Of Boolean), _
ByVal canDoDNC As Nullable(Of Boolean), _
ByVal canTrackOEE As Nullable(Of Boolean), _
ByVal canSchedShifts As Nullable(Of Boolean), _
ByVal canStore As Nullable(Of Boolean), _
ByVal canLogData As Nullable(Of Boolean), _
ByVal canShip As Nullable(Of Boolean), _
ByVal canReceive As Nullable(Of Boolean), _
ByVal canCopyFolders As Nullable(Of Boolean), _
ByVal canCaptureQmData As Nullable(Of Boolean), _
ByVal entityFromGalaxy As Nullable(Of Boolean), _
ByVal canSchedJobsFromGalaxy As Nullable(Of Boolean), _
ByVal canRunJobsFromGalaxy As Nullable(Of Boolean), _
ByVal canCaptureUtilFromGalaxy As Nullable(Of Boolean), _
ByVal canTrackOeeFromGalaxy As Nullable(Of Boolean), _
ByVal canStoreFromGalaxy As Nullable(Of Boolean), _
ByVal identicalJobExecs As Nullable(Of Integer), _
ByVal showInDSPTree As Nullable(Of Integer), _
ByVal entClass As Nullable(Of Boolean), _
ByVal spare1 As String, _
ByVal spare2 As String, _
ByVal spare3 As String, _
ByVal spare4 As String, _
ByVal lastEditBy As String, _
ByVal lastEditAt As Nullable(Of Date) _
) As DataSet
'Usage
Dim entId As Nullable(Of Integer)
Dim entName As String
Dim description As String
Dim parentEntId As Nullable(Of Integer)
Dim site As Nullable(Of Integer)
Dim hourlyCost As Nullable(Of Double)
Dim canSchedJobs As Nullable(Of Boolean)
Dim canRunJobs As Nullable(Of Boolean)
Dim canCaptureUtil As Nullable(Of Boolean)
Dim canCaptureLabor As Nullable(Of Boolean)
Dim canDoDNC As Nullable(Of Boolean)
Dim canTrackOEE As Nullable(Of Boolean)
Dim canSchedShifts As Nullable(Of Boolean)
Dim canStore As Nullable(Of Boolean)
Dim canLogData As Nullable(Of Boolean)
Dim canShip As Nullable(Of Boolean)
Dim canReceive As Nullable(Of Boolean)
Dim canCopyFolders As Nullable(Of Boolean)
Dim canCaptureQmData As Nullable(Of Boolean)
Dim entityFromGalaxy As Nullable(Of Boolean)
Dim canSchedJobsFromGalaxy As Nullable(Of Boolean)
Dim canRunJobsFromGalaxy As Nullable(Of Boolean)
Dim canCaptureUtilFromGalaxy As Nullable(Of Boolean)
Dim canTrackOeeFromGalaxy As Nullable(Of Boolean)
Dim canStoreFromGalaxy As Nullable(Of Boolean)
Dim identicalJobExecs As Nullable(Of Integer)
Dim showInDSPTree As Nullable(Of Integer)
Dim entClass As Nullable(Of Boolean)
Dim spare1 As String
Dim spare2 As String
Dim spare3 As String
Dim spare4 As String
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
value = Ent.GetAll(entId, entName, description, parentEntId, site, hourlyCost, canSchedJobs, canRunJobs, canCaptureUtil, canCaptureLabor, canDoDNC, canTrackOEE, canSchedShifts, canStore, canLogData, canShip, canReceive, canCopyFolders, canCaptureQmData, entityFromGalaxy, canSchedJobsFromGalaxy, canRunJobsFromGalaxy, canCaptureUtilFromGalaxy, canTrackOeeFromGalaxy, canStoreFromGalaxy, identicalJobExecs, showInDSPTree, entClass, spare1, spare2, spare3, spare4, lastEditBy, lastEditAt)
public static DataSet GetAll(
Nullable<int> entId,
string entName,
string description,
Nullable<int> parentEntId,
Nullable<int> site,
Nullable<double> hourlyCost,
Nullable<bool> canSchedJobs,
Nullable<bool> canRunJobs,
Nullable<bool> canCaptureUtil,
Nullable<bool> canCaptureLabor,
Nullable<bool> canDoDNC,
Nullable<bool> canTrackOEE,
Nullable<bool> canSchedShifts,
Nullable<bool> canStore,
Nullable<bool> canLogData,
Nullable<bool> canShip,
Nullable<bool> canReceive,
Nullable<bool> canCopyFolders,
Nullable<bool> canCaptureQmData,
Nullable<bool> entityFromGalaxy,
Nullable<bool> canSchedJobsFromGalaxy,
Nullable<bool> canRunJobsFromGalaxy,
Nullable<bool> canCaptureUtilFromGalaxy,
Nullable<bool> canTrackOeeFromGalaxy,
Nullable<bool> canStoreFromGalaxy,
Nullable<int> identicalJobExecs,
Nullable<int> showInDSPTree,
Nullable<bool> entClass,
string spare1,
string spare2,
string spare3,
string spare4,
string lastEditBy,
Nullable<DateTime> lastEditAt
)
Parameters
- entId
- Optional filter parameter. Holds an entity ID.
- entName
- Optional filter parameter. Holds an entity name.
- description
- Optional filter parameter. Holds an entity description.
- parentEntId
- Optional filter parameter. Holds the ID of a parent entity. If an entity has multiple parents, this is the one from which to inherit values that can only be inherited from one (e.g., the shift schedule).
- site
- Optional filter parameter. Holds the ID of an ancestor entity that defines the site at which entities are located.
- hourlyCost
- Optional filter parameter. Holds an hourly cost of running jobs.
- canSchedJobs
- Optional filter parameter. Holds the flag that specifies whether jobs can be scheduled to an entity.
- canRunJobs
- Optional filter parameter. Holds the flag that specifies whether jobs can be run on an entity.
- canCaptureUtil
- Optional filter parameter. Holds the flag that specifies whether utilization data can be captured on an entity.
- canCaptureLabor
- Optional filter parameter. Holds the flag that specifies whether labor data be captured on an entity.
- canDoDNC
- Optional filter parameter. Not used. Will always be set to False.
- canTrackOEE
- Optional filter parameter. Holds the flag that specifies whether OEE statistics can be captured on an entity.
- canSchedShifts
- Optional filter parameter. Holds the flag that specifies whether shifts can be scheduled for an entity.
- canStore
- Optional filter parameter. Holds the flag that specifies whether an entity can be a “warehouse” or storage location.
- canLogData
- Optional filter parameter. Holds the flag that specifies whether an entity can log data.
- canShip
- Optional filter parameter. Holds the flag that specifies whether shipments can be made from an entity.
- canReceive
- Optional filter parameter. Holds the flag that specifies whether material can be received at an entity.
- canCopyFolders
- Optional filter parameter. Holds the flag that specifies whether files in folders for an entity can be copied to its download directories.
- canCaptureQmData
- Optional filter parameter. Holds the flag that specifies whether QM data can be captured on an entity.
- entityFromGalaxy
- Optional filter parameter. Holds the flag that specifies whether the entity was configured in a System Platform galaxy and exported to the MES database using the Entity Model Builder.
- canSchedJobsFromGalaxy
- Optional filter parameter. Holds a flag that specifies whether the canSchedJobs parameter was set by a System Platform galaxy export using Entity Model Builder.
- canRunJobsFromGalaxy
- Optional filter parameter. Holds a flag that specifies whether the canRunJobs parameter was set by a System Platform galaxy export using Entity Model Builder.
- canCaptureUtilFromGalaxy
- Optional filter parameter. Holds a flag that specifies whether the canCaptureUtil parameter was set by a System Platform galaxy export using Entity Model Builder.
- canTrackOeeFromGalaxy
- Optional filter parameter. Holds a flag that specifies whether the canTrackOee parameter was set by a System Platform galaxy export using Entity Model Builder.
- canStoreFromGalaxy
- Optional filter parameter. Holds a flag that specifies whether the canStore parameter was set by a System Platform galaxy export using Entity Model Builder.
- identicalJobExecs
- Optional filter parameter. Holds the maximum number of jobs that can be run at the same time on this entity.
- showInDSPTree
Optional filter parameter. Holds the flag that specifies whether an entity appears in the data source plug-in tree.
Note: This parameter is obsolete.
- entClass
- Optional filter parameter. Holds the flag that specifies whether this is an entity class.
- spare1
- Optional filter parameter. Holds user-defined content for the spare1 field.
- spare2
- Optional filter parameter. Holds user-defined content for the spare2 field.
- spare3
- Optional filter parameter. Holds user-defined content for the spare3 field.
- spare4
- Optional filter parameter. Holds user-defined content for the spare4 field.
- lastEditBy
- Optional filter parameter. Holds the name of the user who added or last changed an entity record.
- lastEditAt
- Optional filter parameter. Holds a date/time of when an entity record was added or last changed.
Return Value
Returns a DataSet that contains a DataRow for each entity record that satisfies the specified filter criteria. Column values are from the Ent, table unless otherwise indicated. If no matching record is found, an empty DataSet is returned.
The columns of the returned DataSet are described below.
| Column Names | Description |
|---|---|
| ent_id | An integer that is the ID of the entity. |
| ent_name | A string that is the name of the entity. |
| description | A string that is the description of the entity. |
| parent_ent_id | An integer that is the default preferred parent entity ID, null for a top-level entity. If an entity has multiple parents, this is the parent entity from which will inherit elements that can only be inherited from one parent entity (e.g., shift schedule). |
| site | An integer that is the ID of the ancestor entity that defines the site of the current identified entity. |
| site_name | A string that is the site name of the entity, from the Site table |
| tz_id | A string that is the time zone identifier for the entity's time zone. |
| hourly_cost | A double that is the hourly cost of running this entity. |
| can_sched_jobs | A Boolean flag that indicates whether jobs can be scheduled to this entity. |
| can_run_jobs | A Boolean flag that indicates whether jobs can be run on this entity. |
| can_capture_util | A Boolean flag that indicates whether utilization data can be captured on this entity. |
| can_capture_labor | A Boolean flag that indicates whether labor data can be captured on this entity. |
| can_do_dnc | Not used. Will always return False. |
| can_track_oee | A Boolean flag that indicates whether OEE statistics can be captured on this entity. |
| can_sched_shifts | A Boolean flag that indicates whether shifts can be scheduled for this entity. |
| can_store | A Boolean flag that indicates whether this entity can be a storage location, such as a warehouse. |
| can_log_data | A Boolean flag that indicates whether this entity can log data. |
| can_ship | A Boolean flag that indicates whether shipments can be made from this entity. |
| can_receive | A Boolean flag that indicates whether material can be received at this entity. |
| can_copy_folders | A Boolean flag that indicates whether files in folders for this entity can be copied to its download directories. |
| can_capture_qm_data | A Boolean flag that indicates whether this entity can capture QM data and have sample requests generated for it. |
| can_sched_jobs_from_galaxy | If the entity originated from a System Platform galaxy, a Boolean flag that indicates whether jobs can be scheduled to this entity. |
| can_run_jobs_from_galaxy | If the entity originated from a System Platform galaxy, a Boolean flag that indicates whether jobs can be run on this entity. |
| can_capture_util_from_galaxy | If the entity originated from a System Platform galaxy, a Boolean flag that indicates whether utilization data can be captured on this entity. |
| can_track_oee_from_galaxy | If the entity originated from a System Platform galaxy, a Boolean flag that indicates whether OEE statistics can be captured on this entity. |
| can_store_from_galaxy | If the entity originated from a System Platform galaxy, a Boolean flag that indicates whether this entity can be a storage location, such as a warehouse. |
| entity_from_galaxy | A Boolean flag that indicates whether this entity originated from a System Platform galaxy. |
| cur_shift_id | An integer that is the current shift ID on this entity. |
| cur_shift_start_time_utc | A datetime that is the current shift start time for this entity in UTC. |
| cur_shift_start_time_local | A datetime that is the current shift start time for this entity in local time. |
| cur_shift_end_time_utc | A datetime that is the current shift end time for this entity in UTC. |
| cur_shift_end_time_local | A datetime that is the current shift end time for this entity in local time. |
| shift_desc | A string that is the shift description, from the Shift table. |
| last_domain_change | A datetime that is the date/time when the domain last changed. |
| tree_icon | A string that is the key for retrieving the hierarchy tree icon image from the Graphics table. Not currently implemented. |
| flow_diag_img | A string that is the key for retrieving the flow diagram image from the Graphics table. Not currently implemented. |
| identical_job_execs | An integer that is the maximum number of jobs that can be run at the same time on this entity. |
| show_in_dsp_tree | A Boolean flag that indicates whether this entity appears in the data source plug-in tree. |
| ent_class | A Boolean that is a flag that indicates whether this object is an entity class. |
| def_std_oper_id | A string that identifies the standard operation to be used when creating a work order with no reference to a process. |
| equipment_type |
An integer that is an enumeration that indicates the source of utilization and production information. 1 = manual entry 2 = automatic (information from an OCO or UCO) 3 = semi-automatic (information from either manual entry or from an OCO or UCO) |
| spare1 | A string that is the contents of the spare1 field. |
| spare2 | A string that is the contents of the spare2 field. |
| spare3 | A string that is the contents of the spare3 field. |
| spare4 | A string that is the contents of the spare4 field. |
| last_edit_comment | A string that is the comment about why the record was added or changed. |
| last_edit_by | A string that is the user ID of the user who added or last edited this record. |
| last_edit_at | A datetime that identifies when the record was added or last modified. |