Docabasic-API script help

Hi,

I tested the DQL "select group_name from dm_group where any i_all_users_names = 'purchasing' and group_name like 'fotl_%'" in DA. I got a result.

I used the same DQL in my dm_even_sender.ebs script as follows:

query_str3 = select group_name from dm_group where any i_all_users_names = 'purchasing' and group_name like 'fotl_%'query_id$=dmAPIGet("query,c," & query_str3)While query_id <> "" And dmAPIExec("next,c," & query_id ) > 0
      ECRLastPerfGroup=dmAPIGet("get,c," & query_id)
      print #2, "99999: " &   ECRLastPerfGroup
Wend

I am not getting any result. Would you please help me in fixing my above while loop. DQL is perfect.

Please share your knowledge and experiences for figuring this out.

Thanks.

Find more posts tagged with

Documentum

Captiva

Note:

If there are Accepted Answers, those will be shown by default. You can switch to 'All Replies' by selecting the tab below.

Accepted answers

pettitk

You are missing the fetching of the column from the query… In the query, you get group_name. To fetch the collection row record, use what I added below.

query_str3 = select group_name from dm_group where any i_all_users_names = 'purchasing' and group_name like 'fotl_%'

query_id$=dmAPIGet("query,c," & query_str3)

While query_id <> "" And dmAPIExec("next,c," & query_id ) > 0

‘ECRLastPerfGroup=dmAPIGet("get,c," & query_id)

ECRLastPerfGroup= dmAPIGet("get,c," & query_id & ",group_name")

print #2, "99999: " & ECRLastPerfGroup

Wend

All comments