clearquest Questions

I have a stated record type of Escalation which has a parent/child relationship with a stateless record type of CodeStreams. CodeStreams has a resolution field for each child CodeStream. There can be many CodeStreams to one escalation.

I am trying to create a query that will only return records in which none of the children have a resolution of "fixed".

I have tried a variety of and/or options to no avail, seems some records still come back where a child is "fixed". I am thinking this may have to be done with SQL, any help would be much appreciated.

Hi, am new to ClearQuest development. i am trying to debug a code not able to to do so.

I am trying to check the par/child relationship. If the Defect is being put in Completedstate it should first check the child activity is in completed state or not if not it should not put the Defect in completed state. i am trying to send the o/p to the dbwin32 console but the statement i have put in OutputDebugString is not appearing in dbwin32 so i am not able to figure out the code is executed or not...

Any help would be appreciated ?

Here is my code:

sub Defect_Validation {
my($actionname, $actiontype) = @_;
my $result;

# }
$sessionObj = $entity->GetSession();
#Display a debug string via a debugger
$sessionObj->OutputDebugString(" Inside the Defect_Validation routine.\n");

$ActList = $entity->GetFieldValue("parchildact")->GetValueAsList();

$sessionObj->OutputDebugString(" ActList= $ActList \n" );

if ( $entity->GetFieldValue("parchildact")->GetValueStatus == $CQPerlExt::CQ_HAS_VALUE)
{

foreach my $act (@$ActList)
{
# &Debug("*** BaseCMActivity:" . $act);
# Get each Activity Record
my $Act = $session->GetEntity( "BaseCMActivity", $act );
# Get the State of the Activity Record
$ActState = $Act->GetFieldValue("State")->GetValue();
# &Debug("*** State:" . $ActState);
# if the state of any associated Activity Record is NOT Completed, then fail
if ($ActState ne "Complete") {
$result = "All associated BaseCMActivities must be in the \"Complete\" State.";
return $result;
}

}

}

$result = "";
return $result;
}

We are an interop shop currently upgraded to CC/CQ 7.1.1.1 Our vob/view server is unix (SOL). End users are all Windows XP Prof OS (some Linux later)

One of the uses for Rational is a 4 year old home grown DocMgmt app which uses CQ as the document request meta data piece and CC as the document repository for the documents.

One of our user groups (call them TEO for 'Their Eyes Only') wishes to use the system, but needs more security than what is provided currently. Clearcase is set up with only one Clearcase group which has access to all VOBS in an effort to reduce operational maintenance costs (I'm told). However, this means anyone who can create a view, in any region, on any stream on any VOB.

I would like to create a special TEO DEV stream off of the DocMgmt INT stream we now have with 10,000 tech docs in it and create a trigger to validate who is creating a view on the stream and prevent them from doing so if they are not one of a list of ten network IDs. If necessary, we could create a network group and place TEO users in it or just maintain the list with the trigger.

Can this be done and any special considerations?

Thanks,
--Craig

I am importing updates to ClearQuest data.

My import file is a text file that was created as export from another (non CQ) database. I select that I import "updates to existing records) however the import tools creates new records and updates also. I map id in the text file to the id in CQ.

Can anyone help, please? This is urgent.