DQL-docabsic help
Hi,
I have a working DQL:
select group_name from dm_group where any i_all_users_names = 'forecasting' and group_name like 'fotl_%'
I am getting result with the above DQL.
I need to insert a string variable (ECRLastPerf) for hard coded value 'forecasting'.
I did the following:
query_str3 = "select group_name from dm_group where any i_all_users_names = '" & ECRLastPerf & "' and group_name like 'fotl_%'"
Do you think it is correct? I am not getting result.
Can any expert in docbasic/DQL help me? How can I debug it in docbasic script dm_event_sender.ebs? Can I trace? How? Which log I have to look into? docbase log or server.log? I do not see any logging info in either about my method.
Please share your knowledge and experiences for figuring this out.
Thanks.
ta
Best Answer
-
alternatively try this query (replace & with +):
query_str3 = "select group_name from dm_group where any i_all_users_names = '" + ECRLastPerf + "' and group_name like 'fotl_%'"
to troubleshoot this, create a separate ebs script that connects to the repository and runs this query. Check if that ebs script is working and then incorporate the changes in the dm_event_sender.ebs.
you will have to look into the docbase log as this is a dmbasic script execution.
-karthik
0
Answers
-
alternatively try this query (replace & with +):
query_str3 = "select group_name from dm_group where any i_all_users_names = '" + ECRLastPerf + "' and group_name like 'fotl_%'"
to troubleshoot this, create a separate ebs script that connects to the repository and runs this query. Check if that ebs script is working and then incorporate the changes in the dm_event_sender.ebs.
you will have to look into the docbase log as this is a dmbasic script execution.
-karthik
0 -
query_str3 = "select group_name from dm_group where any i_all_users_names = '"+ECRLastPerf +"' and group_name like 'fotl_%'"
0
Categories
- All Categories
- 111 Developer Announcements
- 49 Articles
- 102 General Questions
- 123 IM Services
- 40 OpenText Hackathon
- 31 Developer Tools
- 20.6K Analytics
- 4.1K AppWorks
- 8.9K Extended ECM
- 898 Cloud Fax and Notifications
- 77 Digital Asset Management
- 9.3K Documentum
- 29 eDOCS
- 124 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management
- 1 XM Fax