Subject: [rt-users] rt 2-0-15 and oracle

[Stoyan Genov]

The problem goes further -- the SearchBuilder module
is not adopted to make queries that oracle understands.
It has problems with the join clause, the limit/offset clause,
the distinct selections over CLOB type of fields, and others.

A colleague of mine did a preliminary version of SearchBuilder
which runs for oracle and _does not_ run for mysql/pgsql. When
we have time, we will most probably rearrange the SearchBuilder
module entirely, so it is complaint with mysql/pgsql/oracle and
will post this to the community. However, we're overloaded with work
and this might take days to finish.

Also, the schema for oracle has to be patched as well to keep
relational integrity of foreign keys in the database.

What is the official way to submit patches for rt?

--sdg

---- Joop van de Wege said: ----
> I have just completed this and seems to work quite nice.
> One thing that strikes me is that if I do a search on ticket content
> that doesn't match 'test' and belongs to owner 'Dick' that I get a
> result set which contains duplicate entries. The reason for this is that
> there are normally more than one transaction per ticket which don't
> contain the search string.
> Is this normal behaviour?
> The problem I have with this is that it leads to quite a big result set
> if there are a lot of transactions per ticket which makes picking the
> right ticket quite a problem.
> 
> Joop
> 
> 
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users
> 
> Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm