I am sure I'm doing something silly. Basically it looks like my data is being
altered upon search.
This is my fieldType:
<fieldType name="TrimmedString" class="solr.TextField" omitNorms="true">
<analyzer>
<!-- Removes anything that isn't a letter or digit -->
<charFilter class="solr.PatternReplaceCharFilterFactory"
pattern="([^A-Za-z0-9])" replacement=""/>
<tokenizer class="solr.KeywordTokenizerFactory" />
<!-- Normalizes token text to upper case -->
<filter class="solr.UpperCaseFilterFactory" />
</analyzer>
</fieldType>
I have a string field called "INSTRUCTIONS" using this field type that looks
like this:
ABC_D= PAYMENT FOR CONTRACT AX3764-MP-000-37
With a URL like the one below, I return a bunch of columns of data:
/solr/aml/select?q=TRANSACTION_REFERENCE_NUMBER%3A%22${transactionReferenceNumber}%22&fq=doc_type%3Atrxn&wt=json&fl=_1_Trigger:def(TRIGGER_IND,%22N%22),_2_Transaction_No:TRANSACTION_REFERENCE_NUMBER,_3_Date:TRANSACTION_DATE,_4_Amount:CURRENCY_AMOUNT,_20_Instructions_And_Notes:def(INSTRUCTIONS,%22%22),_21_Transaction_Type:def(TRANSACTION_CDI_DESC,%22%22)&rows=100000
But the data being returned for "INSTRUCTIONS" looks like this:
ABCDPAYMENTFORCONTRACTAX3764MP00037
All spaces and special characters removed. I thought the field Type filters
would impact the index and the query lookup but not the data.
What's even weirder is that other fields that also use this field type (like
transaction reference number) do not show the same behavior.
For example a transaction_reference_number like 123-456-7890 is returned
correctly.
Can anyone please help me understand or troubleshoot?
Thank you so much,
Teresa
