DQL help in docbasic script (and API too)

athati

Hi,

The following docbasic script works fine:

    query_str2 = "select r_last_performer from dm_workflow where r_object_id='" & WorkflowId &"'" & " ENABLE (ROW_BASED)"
    query_id$=dmAPIGet("query,c," & query_str2)    If ( (query_id <> "") And (dmAPIExec("next,c," & query_id ) > 0) ) Then
           ECRLastPerf=dmAPIGet("get,c," & query_id & ",r_last_performer")
    End If

I get a value in to "ECRLastPerf" from 'if' statement. dmAPIGet.... is extracting the attribute 'r_last_performer'.

I have a similar DQL as follows:

    query_str3 = "select group_name from dm_group where any i_all_users_names='" & ECRLastPerf &"'" & " and group_name like 'fotl_"'
    query_id$=dmAPIGet("query,c," & query_str3)    If ( (query_id <> "") And (dmAPIExec("next,c," & query_id ) > 0) ) Then
      ECRLastPerfGroup=dmAPIExec("next,c," & query_id )
    End If

The 'if' block is not returning a value.

Any body can please help me what is wrong in there? The mistake must be either in query_str3 or in 'if' block.

Please share your knowledge and experiences for figuring this out.

Thanks.

ta

DCTM_Guru

Your code is all wrong.  Here's an example from API manual:

query_id = \

dmAPIGet("query," session ",select r_object_id from dm_document)

if (query_id == NULL) {

err_msg = dmAPIGet("getmessage," session)

print "Error querying the repository"

print err_msg

exit

}

resp_cntr = 0

while( dmAPIExec("next," session "," query_id) > 0 ) {

obj_id = dmAPIGet("get," session "," query_id ",r_object_id")

if (obj_id == NULL) {

err_msg = dmAPIGet("getmessage," session)

print "Error retrieving object ID from the query collection"

print err_msg

exit

}

print ++resp_cntr " : " obj_id

}

err_flag = dmAPIExec("close," session "," query_id)

if (err_flag == 0) {

err_msg = dmAPIGet("getmessage," session)

print "Error closing the query collection"

print err_msg

exit

}