// Build the columns schema dynamically based on Contact.getDetailSchema()
public ContactDetailVirtualTable(SiebelVirtualReportTablesPackage package)
: base(package)
{
this.Name = "ContactDetailTable";
this.Label = "Siebel Contact Detail Table";
this.Description = "Siebel Contact Detail Table";
Dictionary <string, string> dictDetail = ContactModel.getDetailSchema();
addColumns(dictDetail);
}
// Build the columns schema dynamically
public ActivityDetailVirtualTable(SiebelVirtualReportTablesPackage package)
: base(package)
{
this.Name = "ActivityDetailTable";
this.Label = "Siebel Activity Detail Table";
this.Description = "Siebel Activity Detail Table";
Dictionary<string, string> dictDetail = Activity.getActivitySchema();
addColumns(dictDetail);
}
// Build the columns schema dynamically
public AssetListVirtualTable(SiebelVirtualReportTablesPackage package)
: base(package)
{
this.Name = "AssetListTable";
this.Label = "Siebel Asset List Table";
this.Description = "Siebel Asset List Table";
Dictionary <string, string> dictDetail = Asset.getAssetSchema();
addColumns(dictDetail);
}
// Build the columns schema dynamically based on Contact.getDetailSchema()
public ContactDetailVirtualTable(SiebelVirtualReportTablesPackage package)
: base(package)
{
this.Name = "ContactDetailTable";
this.Label = "Siebel Contact Detail Table";
this.Description = "Siebel Contact Detail Table";
Dictionary<string, string> dictDetail = ContactModel.getDetailSchema();
addColumns(dictDetail);
}
// Build the columns schema dynamically
public AssetListVirtualTable(SiebelVirtualReportTablesPackage package)
: base(package)
{
this.Name = "AssetListTable";
this.Label = "Siebel Asset List Table";
this.Description = "Siebel Asset List Table";
Dictionary<string, string> dictDetail = Asset.getAssetSchema();
addColumns(dictDetail);
}
// Build the columns schema dynamically
public ActivityDetailVirtualTable(SiebelVirtualReportTablesPackage package)
: base(package)
{
this.Name = "ActivityDetailTable";
this.Label = "Siebel Activity Detail Table";
this.Description = "Siebel Activity Detail Table";
Dictionary <string, string> dictDetail = Activity.getActivitySchema();
addColumns(dictDetail);
}
/* Build the columns schema dynamically based on ServiceRequest.getDetailSchema()
* and add one more column, HiddenSRconcatIncident_ID.
* The reason is the Service Request List view has "Subject" as report linking
* to this detail table, and it is based on this special column
*/
public SRdetailVirtualTable(SiebelVirtualReportTablesPackage package)
: base(package)
{
this.Name = "SRDetailTable";
this.Label = "Siebel SR Detail Table";
this.Description = "Siebel SR Detail Table";
Dictionary<string, string> dictSRDetail = ServiceRequest.getDetailSchema();
addColumns(dictSRDetail);
// format is either SrID_ OR _IncidentID
this.Columns.Add(new ReportColumn()
{
DataType = ReportColumnType.String,
Label = "HiddenSRconcatIncident_ID",
Name = "HiddenSRconcatIncident_ID",
CanDisplay = false,
CanFilter = true
});
}
/* Build the columns schema dynamically based on ServiceRequest.getDetailSchema()
* and add one more column, HiddenSRconcatIncident_ID.
* The reason is the Service Request List view has "Subject" as report linking
* to this detail table, and it is based on this special column
*/
public SRdetailVirtualTable(SiebelVirtualReportTablesPackage package)
: base(package)
{
this.Name = "SRDetailTable";
this.Label = "Siebel SR Detail Table";
this.Description = "Siebel SR Detail Table";
Dictionary <string, string> dictSRDetail = ServiceRequest.getDetailSchema();
addColumns(dictSRDetail);
// format is either SrID_ OR _IncidentID
this.Columns.Add(new ReportColumn()
{
DataType = ReportColumnType.String,
Label = "HiddenSRconcatIncident_ID",
Name = "HiddenSRconcatIncident_ID",
CanDisplay = false,
CanFilter = true
});
}
public SRlistVirtualTable(SiebelVirtualReportTablesPackage package)
: base(package)
{
this.Name = "SRlistTable";
this.Label = "Siebel Service Request List Table";
this.Description = "Siebel Service Request List Table";
this.Columns.Add(new ReportColumn()
{
DataType = ReportColumnType.Integer,
Label = "SR ID",
Name = "SrID",
CanDisplay = true,
CanFilter = true
});
this.Columns.Add(new ReportColumn()
{
DataType = ReportColumnType.String,
Label = "SR Number",
Name = "SrNumber",
CanDisplay = true,
CanFilter = true
});
this.Columns.Add(new ReportColumn()
{
DataType = ReportColumnType.Integer,
Label = "Contact Party ID",
Name = "ContactPartyID",
CanDisplay = true,
CanFilter = true
});
this.Columns.Add(new ReportColumn()
{
DataType = ReportColumnType.String,
Label = "Incident Reference",
Name = "IncidentRef",
CanDisplay = true,
CanFilter = false
});
this.Columns.Add(new ReportColumn()
{
DataType = ReportColumnType.String,
Label = "Status",
Name = "Status",
CanDisplay = true,
CanFilter = true
});
this.Columns.Add(new ReportColumn()
{
DataType = ReportColumnType.String,
Label = "Summary",
Name = "Summary",
CanDisplay = true
});
this.Columns.Add(new ReportColumn()
{
DataType = ReportColumnType.Date,
Label = "Created",
Name = "Created",
CanDisplay = true
});
// format is either SrID_ OR _IncidentID
this.Columns.Add(new ReportColumn()
{
DataType = ReportColumnType.String,
Label = "HiddenSRconcatIncident_ID",
Name = "HiddenSRconcatIncident_ID",
CanDisplay = true,
CanFilter = true
});
}
public SRlistVirtualTable(SiebelVirtualReportTablesPackage package)
: base(package)
{
this.Name = "SRlistTable";
this.Label = "Siebel Service Request List Table";
this.Description = "Siebel Service Request List Table";
this.Columns.Add(new ReportColumn()
{
DataType = ReportColumnType.Integer,
Label = "SR ID",
Name = "SrID",
CanDisplay = true,
CanFilter = true
});
this.Columns.Add(new ReportColumn()
{
DataType = ReportColumnType.String,
Label = "SR Number",
Name = "SrNumber",
CanDisplay = true,
CanFilter = true
});
this.Columns.Add(new ReportColumn()
{
DataType = ReportColumnType.Integer,
Label = "Contact Party ID",
Name = "ContactPartyID",
CanDisplay = true,
CanFilter = true
});
this.Columns.Add(new ReportColumn()
{
DataType = ReportColumnType.String,
Label = "Incident Reference",
Name = "IncidentRef",
CanDisplay = true,
CanFilter = false
});
this.Columns.Add(new ReportColumn()
{
DataType = ReportColumnType.String,
Label = "Status",
Name = "Status",
CanDisplay = true,
CanFilter = true
});
this.Columns.Add(new ReportColumn()
{
DataType = ReportColumnType.String,
Label = "Summary",
Name = "Summary",
CanDisplay = true
});
this.Columns.Add(new ReportColumn()
{
DataType = ReportColumnType.Date,
Label = "Created",
Name = "Created",
CanDisplay = true
});
// format is either SrID_ OR _IncidentID
this.Columns.Add(new ReportColumn()
{
DataType = ReportColumnType.String,
Label = "HiddenSRconcatIncident_ID",
Name = "HiddenSRconcatIncident_ID",
CanDisplay = true,
CanFilter = true
});
}
