ITask.GetFieldsValuesFromDb Method
Function GetFieldsValuesFromDb( _
ByVal fields As List(Of String) _
) As Dictionary(Of String, Object)
This language is not supported or no code example is available.
Parameters
A list of field mnemonics whose content you want to retrieve.
Return Value
Dictionary<string, object>A dictionary of results. Keys contain matching field mnemonics and values contain corresponding field values.
| Exception type | Condition |
|---|---|
|
A problem occurred. |
Because this function reads directly from database, it cannot get values which are calculated by the WBS workbook. Use GetFieldValue to read directly from the workbook.
You cannot get blob values, i.e. embedded files, with this method. If you want to get the values of the fields that have their IWbsField.DataType set to WbsFieldDataType.AnyFile, such as "_Document" or "_Workbook", you need to call GetBlob method.
The function also supports fields which cannot be displayed in the WBS. You can access all free fields with the name you give them + the following native fields:
| Field mnemonic | Description |
|---|---|
| WBS_Description | the description (first row only) |
| WBS_Guid | the unique identifier to the row |
| WBS_Level | the indentation level |
| WBS_HexIndex | the hexadecimal identifier where each 3 chars match one level |
| WBS_Incidence | the calculated value being in the incidence column |
| WBS_InternalQuantity | the quantity multiplied by quantities of branches |
| WBS_InternalQuantityOptions | the quantity multiplied by quantities of branches ignoring the 0 value of possible options |
| WBS_IsAMinute | 1 when the row matches a task (a minute) and 0 when it matches a branch (a chapter) |
| WBS_ByTotal | 1 when the task is evaluated by total and 0 when it is evaluated per unit |
| WBS_IsOption | 1 when the task or branch is set an option, 2 when it belongs to an optional branch, 0 when not an option |
| WBS_Item | the item (string) |
| WBS_Owner | the owner (string) |
| WBS_Quantity | the quantity |
| WBS_SellingPriceBeforeCoeffPerUnit | the selling price per unit before IDIQ factors |
| WBS_ForcedCoeff | the factor in the 'incidence' columns when forced |
| WBS_ForcedMode | 0 when not forced, 1 when factor is forced, 2 when selling price is forced |
| WBS_ForcedSellingPricePerUnit | the value forced in the selling price per unit column |
| WBS_ForcedSellingTotalPrice | the value forced in the selling total price column |
| WBS_CostDataFromMinute | the cost coming from the minute (either per unit or total) |
| WBS_SellingDataFromMinute | the selling price from the minute (either per unit or total) |
| WBS_CostPerUnit | the cost per unit |
| WBS_TotalCost | the total cost |
| WBS_SPPerUnitAfterCoeffs | the selling price per unit after application of IDIQ factors |
| WBS_SPTotalAfterCoeffs | the selling total price after application of IDIQ factors |
| WBS_TypeOfLink | is the type of link for linked tasks 0 = not linked, 1 = linked |
| WBS_CostDataIsWrong | when 1 the cost is N/A and may require computation |
| WBS_SellingDataIsWrong | when 1 the selling price is N/A and may require computation |
