SQLDict_hasMessage.zsql 591 Bytes
Newer Older
1 2
<dtml-comment>
title:
3
connection_id:cmf_activity_sql_connection
4
max_rows:1
5 6
max_cache:0
cache_time:0
7 8 9 10
class_name:
class_file:
</dtml-comment>
<params>path
11
method_id
12
active_process_uid
13
only_valid</params>
14 15 16
SELECT count(path) as message_count FROM
  message
WHERE
17 18 19
path = <dtml-sqlvar path type="string">
<dtml-if expr="method_id is not None">AND method_id = <dtml-sqlvar method_id type="string"></dtml-if>
<dtml-if expr="only_valid">AND processing_node > -2</dtml-if>
20
<dtml-if expr="active_process_uid is not None"> AND active_process_uid = <dtml-sqlvar active_process_uid type="int"> </dtml-if>