JS Client not returning results


(Vivek) #1

Hi,
I have the following structure in the elasticSearch -- When i perform search by dbEntityName i get results , however when i perform search by
legacyEntityAttributeName i do not get results , please note that kibana give me details , however my elasticSearch js client does not give me results

sample code :
$scope.search = function() {
alert($scope.queryTerm);
client.search({
index: 'legacytables',
type: 'existingtables',
body: {
"query" : {
"match" : {legacyEntityAttributeName: $scope.queryTerm} // if i give entityAttributes.legacyEntityAttributeName angular throws error
}
}
}).then(function (resp) {
alert(resp.hits.total);
$scope.results = resp.hits.hits[0]._source;
}, function (err) {
console.trace(err.message);
}

[
{
"_index": "legacytables",
"_type": "existingtables",
"_id": "AVNC54hNO04QfeJDGYBX",
"_score": 3.9704144,
"_source": {
"dbEntityName": "TAAGENT_REMARK",
"otherEntityName": [
"pc_account",
"pc_note",
""
],
"entityAttributes": [
{
"legacyEntityAttributeName": "HOUSEHOLD_NUM",
"legacydataType": "CHAR",
"legacydatalength": "10.0",
"legacydataDefinition": "A unique system generated number which is used to identify a specific household.",
"legacydataClassification": "",
"dataTeamReviewComments": "",
"functionalTeamReviewComments": "",
"xmlTag": "",
"mappingLastUpdatedDate": "",
"mappingLastUpdatedBy": "",
"gwentityAttributeName": "AccountNumber",
"gwtableName": "pc_account",
"gwdataType": "Varchar(255)",
"gwdatalength": "Varchar(255)",
"mappedBy": "",
"mappedDate": "",
"team": "",
"gwdataDefinition": "The account number of this account. ",
"gwdataClassification": ""
}, <!--- Repeats omitted for clarity>>
]
}
} ]


(system) #2