IEstimateVersion.UpdateMinuteValues (String, Object, String, Object, WhereConditionType, Boolean, IEnumerable<ITask>) Method

Updates a field value of multiple minutes based on a test condition. The search is performed on the specified WBS tasks.
Sub UpdateMinuteValues( _ 
ByVal UpdateColumnName As String, _ 
ByVal NewValue As Object, _ 
ByVal WhereColumnName As String, _ 
ByVal WhereValue As Object, _ 
ByVal WhereType As WhereConditionType, _ 
ByVal WhereIsCaseSensitive As Boolean, _ 
ByVal Tasks As IEnumerable(Of ITask) _ 
)
This language is not supported or no code example is available.
void UpdateMinuteValues( 
string UpdateColumnName
object NewValue
string WhereColumnName
object WhereValue
WhereConditionType WhereType
bool WhereIsCaseSensitive
IEnumerable<ITask> Tasks 
)
This language is not supported or no code example is available.

Parameters

UpdateColumnName
string

The mnemonic of the minute column to be updated.

NewValue
object

The new value to be set in the column.

WhereColumnName
string

The mnemonic of the minute column to be tested.

WhereValue
object

The value to be tested in the condition.

WhereType
WhereConditionType

The type of test to be performed.

WhereIsCaseSensitive
bool

Indicates whether the test is case sensitive.

Tasks
IEnumerable<ITask>

A set of input tasks whose minutes will be tested for the condition and updated if the test passed.

Special virtual tasks can be included in this list, which represent the database of the estimate or the overhead minute.

Exception type Condition

QdvApiException

A problem occurred.

Remarks
 
This method tests for the condition the minutes of each task from the Tasks parameter. The condition is specified with WhereColumnName, WhereValue, WhereType and WhereIsCaseSensitive parameters. If the condition is satisfied, the UpdateColumnName column of the minute will be updated with the new value.

If you want to search also in the database of the estimate or in the overhead minute, you can include their virtual tasks in Tasks argument. You can get them from IMinute.Task property of the minutes that you get with DatabaseOfEstimateMinute and OverheadCostsMinute.

Example
 

The following example of a macro code replaces all minute rows with the description "AAA" with the new description "BBB". The update is performed everywhere, i.e., also in the database of estimate and in the overhead minute.

var tasks = es.CurrentVersion.Wbs.GetTasksForScope("", GetAlsoChapters: false);
 tasks.Add(es.CurrentVersion.DatabaseOfEstimateMinute.Task);
 tasks.Add(es.CurrentVersion.OverheadCostsMinute.Task);
 es.CurrentVersion.UpdateMinuteValues(UpdateColumnName: "Description",
     NewValue: "BBB",
     WhereColumnName: "Description",
     WhereValue: "AAA",
     WhereType: WhereConditionType.Equal,
     WhereIsCaseSensitive: false,
     Tasks: tasks);
 
 es.RepaintCurrentView();					
This language is not supported or no code example is available.
Version
 
Available since QDV 7.13.0001.

.NET Framework

Supported in: 4.8, 4.7, 4.6, 4.5.2

In this article

Definition