Issues returning multiple worflow ID results

Hello,

Currently I am using the following code to identity worflows that have been initilated based on workflow id 692060:

Select map_mapid from wmap where map_mapobjid=692060

This works fine.

What I would like to do is amend this code to pick up worflows initiated for multiple workflow ID's, I have tried the following:

Select map_mapid from wmap where map_mapobjid=692060 AND map_mapobjid=692054

This returns no results at all, can somebody help me solve my problem here please?

Many thanks

Paul

Find more posts tagged with

Comments

Lori_Himsl

Use “or” not “and” – where (map_mapobjid=692060 OR map_mapobjid=692054)

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Friday, October 07, 2011 6:17 AM
To: eLink Recipient
Subject: Issues returning multiple worflow ID results

Issues returning multiple worflow ID results

Posted by paul.marrison@derbyshire.gov.uk (Marrison, Paul) On 2011/10/07 06:11

Hello,

Currently I am using the following code to identity worflows that have been initilated based on workflow id 692060:

Select map_mapid from wmap where map_mapobjid=692060

This works fine.

What I would like to do is amend this code to pick up worflows initiated for multiple workflow ID's, I have tried the following:

Select map_mapid from wmap where map_mapobjid=692060 AND map_mapobjid=692054

This returns no results at all, can somebody help me solve my problem here please?

Many thanks

Paul

[To post a comment, use the normal reply function]
Forum:	Content Server LiveReports Forum
Livelink Server:	knowledge-wlweb01

Paul_Marrison

Thanks for this,

It now works as expected.

Many thanks

Paul

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: 07 October 2011 13:40
To: eLink Recipient
Subject: RE Issues returning multiple worflow ID results

RE Issues returning multiple worflow ID results

Posted bylhimsl@opentext.com (Himsl, Lori) On 2011/10/07 08:40

Use “or” not “and” –where (map_mapobjid=692060 OR map_mapobjid=692054)

Issues returning multiple worflow ID results

Posted by paul.marrison@derbyshire.gov.uk (Marrison, Paul) On 2011/10/07 06:11

&nbs! p;

Hello,

Currently I am using the following code to identity worflows that have been initilated based on workflow id 692060:

Select map_mapid from wmap where map_mapobjid=692060

This works fine.

What I would like to do is amend this code to pick up worflows initiated for multiple workflow ID's, I have tried the following:

Select map_mapid from wmap where map_mapobjid=692060 AND map_mapobjid=692054

This returns no results at all, can somebody help me solve my problem here please?

Many thanks

Paul

[To post a comment, use the normal reply function]
Forum:	Content Server LiveReports Forum
Livelink Server:	knowledge-wlweb01

[To post a comment, use the normal reply function]
Topic:	Issues returning multiple worflow ID results
Forum:	Content Server LiveReports Forum
Livelink Server:	knowledge-wlweb01

Think before you print! Save energy and paper.Do you really need to print this email?

Derbyshire County Council works to improve the lives of local people by delivering high quality services.You can find out more about us by visiting 'www.derbyshire.gov.uk'. If you want to work for us go to our job pages on 'www.derbyshire.gov.uk/jobs'. You can register for e-mail alerts, download job packs and apply on-line.

Please Note
This email is confidential, may be legally privileged and may contain personal views that are not the views of Derbyshire County Council. It is intended solely for the addressee. If this email was sent to you in error please notify us by replying to the email. Once you have done this please delete the email and do not disclose, copy, distribute, or rely on it.
Under the Data Protection Act 1998 and the Freedom of Information Act 2000 the contents of this email may be disclosed.

Derbyshire County Council reserves the right to monitor both sent and received emails.