Howto search on Customfield's largecontent?

Hi,

It seams that RT does not search on largecontent for custom fields.

RT use two fields in order to manage customfields large content :

content | character varying(255) |
largecontent | text |

When the value on the CF is bigger than 255, RT put the value in the
largecontent field but does NOT make search on that field.

I’d like to known it witch file the search is build? In order to fix that
issue.

Best Regards,

Nowicki Christophe
http://csquad.org

Hi,

It seams that RT does not search on largecontent for custom fields.

RT use two fields in order to manage customfields large content :

content | character varying(255) |
largecontent | text |

When the value on the CF is bigger than 255, RT put the value in the
largecontent field but does NOT make search on that field.

I’d like to known it witch file the search is build? In order to fix that
issue.
lib/RT/Tickets_Overlay.pm

Best Regards,


Nowicki Christophe
http://csquad.org


List info: http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-devel

Best Practical is hiring! Come hack Perl for us: http://bestpractical.com/about/jobs.html

Best regards, Ruslan.

Hi Zakirov,

Hi,

It seams that RT does not search on largecontent for custom fields.

RT use two fields in order to manage customfields large content :

content | character varying(255) |
largecontent | text |

When the value on the CF is bigger than 255, RT put the value in the
largecontent field but does NOT make search on that field.

I’d like to known it witch file the search is build? In order to fix
that
issue.
lib/RT/Tickets_Overlay.pm

Yes, I’ve patched the _CustomFieldLimit function :


$self->_OpenParen if ($null_columns_ok);

$self->_SQLLimit(
    ALIAS      => $TicketCFs,
    FIELD      => 'Content',
    OPERATOR   => $op,
    VALUE      => $value,
    QUOTEVALUE => 1,
    @rest
);
  • $self->_SQLLimit(
  •    ALIAS      => $TicketCFs,
    
  •    FIELD      => 'LargeContent',
    
  •    OPERATOR   => $op,
    
  •    VALUE      => $value,
    
  •    QUOTEVALUE => 1,
    
  •    ENTRYAGGREGATOR => 'OR',
    
  • );
if ($null_columns_ok) {

And now it’s working, thanks

Nowicki Christophe
http://csquad.org