summaryrefslogtreecommitdiff
path: root/rt/docs/design_docs/cf_search
diff options
context:
space:
mode:
authorcvs2git <cvs2git>2006-08-23 22:25:40 +0000
committercvs2git <cvs2git>2006-08-23 22:25:40 +0000
commit58d093219cf60264550b8c34649d9f3190eda042 (patch)
tree10418dd70b52416a5f52da8e17d8e282d914595d /rt/docs/design_docs/cf_search
parent3ce7691203a7737406bf2d4442f7fd84b81f847e (diff)
This commit was manufactured by cvs2svn to create tagAFTER_FINAL_MASONIZE
'AFTER_FINAL_MASONIZE'.
Diffstat (limited to 'rt/docs/design_docs/cf_search')
-rw-r--r--rt/docs/design_docs/cf_search72
1 files changed, 0 insertions, 72 deletions
diff --git a/rt/docs/design_docs/cf_search b/rt/docs/design_docs/cf_search
deleted file mode 100644
index 456a9febb..000000000
--- a/rt/docs/design_docs/cf_search
+++ /dev/null
@@ -1,72 +0,0 @@
-find all tickets where:
-
-
- CF Foo
- Has values (talk or read) AND
- Has values (bar and baz) AND
- doesn't have values (bing or bong)
-
-
-LimitCustomFieldValues {
- my %args = ( CustomField => undef,
- ClauseId => 'CustomFields',
- OPERATOR => undef,
- ENTRYAGGREGATOR => undef,
- VALUES => undef,
- @_) ;
-
- unless ( $self->{'TicketAliases'}{$args{'ClauseId'}}{'CustomField'} ) {
- $self->{'TicketAliases'}{$args{'ClauseId'}}{'CustomField'} = $self->NewAlias('CustomFields');
- $self->Join(TABLE1 =>$self->{'TicketAliases'}{$args{'ClauseId'}}{'CustomField' },
- FIELD1 => 'QueueId',
- TABLE2 => 'main', FIELD2 => 'QueueId');
-
- if ($args{'OPERATOR'} =~ /!=|IS/i) {
- }
- else {
- }
-
-}
- # {{{ if it's a keyword
- elsif ( $TYPES{ $restriction->{'FIELD'} } eq 'CUSTOMFIELD' ) {
-
- my $null_columns_ok;
- my $TicketCFs = $self->Join( TYPE => 'left',
- ALIAS1 => 'main',
- FIELD1 => 'id',
- TABLE2 => 'TicketCustomFieldValues',
- FIELD2 => 'Ticket' );
-
- foreach my $value ( @{ $restriction->{'VALUES'} } ) {
- $self->SUPER::Limit( ALIAS => $TicketCFs,
- FIELD => 'Content',
- OPERATOR => $restriction->{'OPERATOR'},
- VALUE => $value,
- QUOTEVALUE => $restriction->{'QUOTEVALUE'},
- ENTRYAGGREGATOR => 'AND', );
- }
- if ( ( $restriction->{'OPERATOR'} =~ /^IS$/i ) or ( $restriction->{'OPERATOR'} eq '!=' ) ) {
- $null_columns_ok = 1;
- }
-
- #If we're trying to find tickets where the keyword isn't somethng, also check ones where it _IS_ null
- if ( $restriction->{'OPERATOR'} eq '!=' ) {
- $self->SUPER::Limit( ALIAS => $TicketCFs,
- FIELD => 'Content',
- OPERATOR => 'IS',
- VALUE => 'NULL',
- QUOTEVALUE => 0,
- ENTRYAGGREGATOR => 'OR', );
- }
-
- $self->SUPER::Limit( LEFTJOIN => $TicketCFs,
- FIELD => 'CustomField',
- VALUE => $restriction->{'CUSTOMFIELD'},
- ENTRYAGGREGATOR => 'OR' );
-
- }
-
- # }}}
-
- }
-