473,320 Members | 1,965 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

ICM question for searching

Hi,

I don't know if this is the right news group to ask content manger
questions but I have to try it.

It's resource manager related. I have several documents in the resource
manager and I want to start a search on them in the way some of them
have equal attributes that mark them as consisting to a specific
document bundle. Imagine three docs every doc has the attribute "DocID"
which is not unique over the documents. So lets have 2 of my 3 documents
have the same DocIDs. I want to start a search so that the CM (8.2)
thinks that all documents with the same DocIDs are one document. All I
need is the "contains-text-basic" functionality. Mark phrases with " and
- for (must not include).

Sample

Doc 1: DocID=1 content: foo
Doc 2: DocID=1 content: bar
Doc 3: DocID=2 content: foo

I wan't to start a search like: foo -bar. And I want it to return Doc 3
because Doc 1 has the same DocID as Doc 2 but that contains bar.

How do I do that?
regards

Thomas Scheffler

Nov 12 '05 #1
3 2971
Something like:

select docid from tablex where content='foo' and
docid not in (select docid from tablex where content='bar')
Thomas Scheffler wrote:
Hi,

I don't know if this is the right news group to ask content manger
questions but I have to try it.

It's resource manager related. I have several documents in the
resource manager and I want to start a search on them in the way some
of them have equal attributes that mark them as consisting to a
specific document bundle. Imagine three docs every doc has the
attribute "DocID" which is not unique over the documents. So lets have
2 of my 3 documents have the same DocIDs. I want to start a search so
that the CM (8.2) thinks that all documents with the same DocIDs are
one document. All I need is the "contains-text-basic" functionality.
Mark phrases with " and - for (must not include).

Sample

Doc 1: DocID=1 content: foo
Doc 2: DocID=1 content: bar
Doc 3: DocID=2 content: foo

I wan't to start a search like: foo -bar. And I want it to return Doc
3 because Doc 1 has the same DocID as Doc 2 but that contains bar.

How do I do that?
regards

Thomas Scheffler


--
Anton Versteeg
IBM Certified DB2 Specialist
IBM Netherlands
Nov 12 '05 #2
Anton Versteeg wrote:
Something like:

select docid from tablex where content='foo' and
docid not in (select docid from tablex where content='bar')

Currently it looks like follows (per file search):

DKNVPair options[] = new DKNVPair[3];
options[0] = new DKNVPair(DKConstant.DK_CM_PARM_MAX_RESULTS,
"0"); // No Maximum (Default)
options[1] = new DKNVPair(DKConstant.DK_CM_PARM_RETRIEVE,new
Integer(DKConstant.DK_CM_CONTENT_YES));
options[2] = new DKNVPair(DKConstant.DK_CM_PARM_END,null);
DKResults results =
(DKResults)connection.evaluate("/test[contains-text-basic (@TIEREF,\"foo
-bar\")=1]",
DKConstantICM.DK_CM_XQPE_QL_TYPE, options);
dkIterator iter = results.createIterator();
logger.debug("Number of Results: "+results.cardinality());

I really don't know how your sql query helps me but I forgot to tell you
that I use the JAVA api for it...

So what do I have to change?

regards Thomas
I don't know if this is the right news group to ask content manger
questions but I have to try it.

It's resource manager related. I have several documents in the
resource manager and I want to start a search on them in the way some
of them have equal attributes that mark them as consisting to a
specific document bundle. Imagine three docs every doc has the
attribute "DocID" which is not unique over the documents. So lets have
2 of my 3 documents have the same DocIDs. I want to start a search so
that the CM (8.2) thinks that all documents with the same DocIDs are
one document. All I need is the "contains-text-basic" functionality.
Mark phrases with " and - for (must not include).

Sample

Doc 1: DocID=1 content: foo
Doc 2: DocID=1 content: bar
Doc 3: DocID=2 content: foo

I wan't to start a search like: foo -bar. And I want it to return Doc
3 because Doc 1 has the same DocID as Doc 2 but that contains bar.

How do I do that?
regards

Thomas Scheffler


Nov 12 '05 #3
Sorry I wouldn't know.
Anyone else perhaps?

Thomas Scheffler wrote:
Anton Versteeg wrote:
Something like:

select docid from tablex where content='foo' and
docid not in (select docid from tablex where content='bar')


Currently it looks like follows (per file search):

DKNVPair options[] = new DKNVPair[3];
options[0] = new DKNVPair(DKConstant.DK_CM_PARM_MAX_RESULTS,
"0"); // No Maximum (Default)
options[1] = new DKNVPair(DKConstant.DK_CM_PARM_RETRIEVE,new
Integer(DKConstant.DK_CM_CONTENT_YES));
options[2] = new DKNVPair(DKConstant.DK_CM_PARM_END,null);
DKResults results =
(DKResults)connection.evaluate("/test[contains-text-basic
(@TIEREF,\"foo -bar\")=1]",
DKConstantICM.DK_CM_XQPE_QL_TYPE, options);
dkIterator iter = results.createIterator();
logger.debug("Number of Results: "+results.cardinality());

I really don't know how your sql query helps me but I forgot to tell
you that I use the JAVA api for it...

So what do I have to change?

regards Thomas
I don't know if this is the right news group to ask content manger
questions but I have to try it.

It's resource manager related. I have several documents in the
resource manager and I want to start a search on them in the way
some of them have equal attributes that mark them as consisting to a
specific document bundle. Imagine three docs every doc has the
attribute "DocID" which is not unique over the documents. So lets
have 2 of my 3 documents have the same DocIDs. I want to start a
search so that the CM (8.2) thinks that all documents with the same
DocIDs are one document. All I need is the "contains-text-basic"
functionality. Mark phrases with " and - for (must not include).

Sample

Doc 1: DocID=1 content: foo
Doc 2: DocID=1 content: bar
Doc 3: DocID=2 content: foo

I wan't to start a search like: foo -bar. And I want it to return
Doc 3 because Doc 1 has the same DocID as Doc 2 but that contains bar.

How do I do that?
regards

Thomas Scheffler


--
Anton Versteeg
IBM Certified DB2 Specialist
IBM Netherlands
Nov 12 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: John | last post by:
Hi everyone ! This is a first time I post a message here. If I post my message in a wrong group. Please ignore it. I am trying to build a website which allows users (can be thousands of...
18
by: jblazi | last post by:
I should like to search certain characters in a string and when they are found, I want to replace other characters in other strings that are at the same position (for a very simply mastermind game)...
4
by: tgiles | last post by:
Hi, all. Another bewildered newbie struggling with Python goodness. This time it's searching strings. The goal is to search a string for a value. The string is a variable I assigned the name...
2
by: Kakarot | last post by:
I'm gona be very honest here, I suck at programming, *especially* at C++. It's funny because I actually like the idea of programming ... normally what I like I'm atleast decent at. But C++ is a...
8
by: Gordon Knote | last post by:
Hi can anyone tell me what's the best way to search in binary content? Best if someone could post or link me to some source code (in C/C++). The search should be as fast as possible and it would...
33
by: Geoff Jones | last post by:
Hiya I have a DataTable containing thousands of records. Each record has a primary key field called "ID" and another field called "PRODUCT" I want to retrieve the rows that satisy the following...
5
by: justobservant | last post by:
When more than one keyword is typed into a search-query, most of the search-results displayed indicate specified keywords scattered throughout an entire website of content i.e., this is shown as...
7
by: pbd22 | last post by:
Hi. I am somewhat new to this and would like some advice. I want to search my xml file using "keyword" search and return results based on "proximity matching" - in other words, since the search...
5
by: lemlimlee | last post by:
hello, this is the task i need to do: For this task, you are to develop a Java program that allows a user to search or sort an array of numbers using an algorithm that the user chooses. The...
2
by: Bart Kastermans | last post by:
I have a file in which I am searching for the letter "i" (actually a bit more general than that, arbitrary regular expressions could occur) as long as it does not occur inside an expression that...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.