Returns a list of records from the dest table which related to the source system.
collapseRecords=true, only records from dest table which are related to the source tables (.ie., INNER JOIN)
collapseRecords=false, all records from dest table including optional related source records (i.e., LEFT JOIN)
Namespace: Caisis.DataAccessAssembly: Caisis.DataAccess (in Caisis.DataAccess.dll) Version: 4.0.4947.22627
Syntax
C# |
---|
public static DataTable GetRelatedRecordsByTableAndKey( int patientId, string destTable, string destTableKeyName, Nullable<int> destTableKeyValue, string sourceTable, string sourceTableKeyName, bool collapseRecords ) |
Visual Basic |
---|
Public Shared Function GetRelatedRecordsByTableAndKey ( patientId As Integer, destTable As String, destTableKeyName As String, destTableKeyValue As Nullable(Of Integer), sourceTable As String, sourceTableKeyName As String, collapseRecords As Boolean ) As DataTable |
Visual C++ |
---|
public: static DataTable^ GetRelatedRecordsByTableAndKey( int patientId, String^ destTable, String^ destTableKeyName, Nullable<int> destTableKeyValue, String^ sourceTable, String^ sourceTableKeyName, bool collapseRecords ) |
Parameters
- patientId
- Type: System..::..Int32
The patient id
- destTable
- Type: System..::..String
The table which to check for relation
- destTableKeyName
- Type: System..::..String
The table's pri key used for relation
- destTableKeyValue
- Type: System..::..Nullable<(Of <(<'Int32>)>)>
[Missing <param name="destTableKeyValue"/> documentation for "M:Caisis.DataAccess.RelatedRecordsDa.GetRelatedRecordsByTableAndKey(System.Int32,System.String,System.String,System.Nullable{System.Int32},System.String,System.String,System.Boolean)"]
- sourceTable
- Type: System..::..String
The table which to check for relations
- sourceTableKeyName
- Type: System..::..String
[Missing <param name="sourceTableKeyName"/> documentation for "M:Caisis.DataAccess.RelatedRecordsDa.GetRelatedRecordsByTableAndKey(System.Int32,System.String,System.String,System.Nullable{System.Int32},System.String,System.String,System.Boolean)"]
- collapseRecords
- Type: System..::..Boolean
True=inner join, False=outer join
Return Value
Type: DataTable[Missing <returns> documentation for "M:Caisis.DataAccess.RelatedRecordsDa.GetRelatedRecordsByTableAndKey(System.Int32,System.String,System.String,System.Nullable{System.Int32},System.String,System.String,System.Boolean)"]