DQL Read/Write and IN value_list

Hello!

I have met an issue when I try run a dql query with IN value_list like this:

select count(*) from dm_document where object_name IN(?)

Instead of placeholder '?' I use a process parameter with value (without apostrophe): 'doc1, doc2'. I am sure that documents with these names are exists in the repository. If I try to use just one parameter (for example, doc1), I got the the count of the documents.

I know I can use the 'getValue' function in Data Mapping tab but I want to run a single query.

It seems to me it is not possible. Or I am doing something wrong?

PS. I try a few combinations with and without apostrophe:

'doc1', 'doc2'

doc1', 'doc2

but it doesn't help.

Thanks in advance!

~ Konstantin

Find more posts tagged with

Comments

DCTM_Guru

What about:

1) 'doc1,doc2'

2) "doc1,doc2"

3) "'doc1','doc2'" (double quotes followed by single quote)

lastnitescurry

The following works for me on D6.6

Please enter a docbase name (docubase): documentum
Please enter a user (dmadmin):
Please enter password for dmadmin: *******

        EMC Documentum idql - Interactive document query interface
        (c) Copyright EMC Corp., 1992 - 2010
        All rights reserved.
        Client Library Release 6.6.0.039


Connecting to Server using docbase documentum
[DM_SESSION_I_SESSION_START]info:  "Session 01de75d180028516 started for user dmadmin."


Connected to Documentum Server running Release 6.6.0.041  Win32.SQLServer
1> select COUNT(*) from dm_document
2> WHERE object_name IN ('Answers - Advark.xml', 'Answers - test .xml', 'Jobs')
3> GO
dm_attr_0001
------------
           2
(1 row affected)
1> select * from dm_document
2> WHERE object_name IN ('Answers - Advark.xml', 'Answers - test .xml', 'Jobs')
3> GO
r_object_id       object_name   
09de75d180014940  Answers - Advark.xml
09de75d180014936  Answers - test
(2 rows affected)
1>

Miller-zzMST

Johnny,

Thanks, but it does not works

I think, it would be better to create the serviec request.

~ Konstantin

Miller-zzMST

Brian,

Thanks, but I want to run this query by DQL Read/Write activity in the Process Builder. Sorry if I did not clearly specify my requirements.

~ Konstantin

Tord

Hi Konstantin,

The problem you face is that two transformations are applied to values where the parameter type is String:

A single quote (') is prepended and appended.
Any occurrence of ' within the string is escaped by duplicating it.

So, it isn't possible, afaik, to do what you want with the ootb DQL Read activity.

May I instead suggest you take a look at one of these two xCelerators for a solution to your problem:

Hope it helps

Thanks

--Tord

DCTM_Guru

You could always write your own custom activity template.

Tord

That is true of course, but reusing one of those xCelerators is probably faster I would guess...

--T

Miller-zzMST

Tord, Johnny, thanks!