I have not seen the syntax your are leveraging. I have gotten results with:
POST: {{tenantURL}}/entities/_searchConnections?max=250&returnFullRelations=true&returnAnalyticAttributes=false&options=ovOnly&select=uri,label&filter=(equals(attributes.FirstName,'Dan') and equals(attributes.Specialties.Specialty,'ON'))
Body:
[
{
"outRelations": [
{
"uri": "configuration/relationTypes/HCPisAffiliatedWithHCO"
}
],
"filter": "startsWith(attributes.Name,'Prisma')"
}
]
Note that the results are designed to return ALL profiles which meet the filter condition specified in the querystring filter, and then for each of those records, see if any of them have the relationship(s) specified which link to objects which meets the filter criteria in the body.
Not all records in the base search results will have the indicated relationship. You will need to parse the results relations array to see which start and end objects match both criteria. This API is not intended to be a graph search, but rather a search across parent and subsequently child objects without having to make multiple API calls.
------------------------------
Dan Gage
Principal Solution Consultant
------------------------------
Original Message:
Sent: 11-01-2023 11:03
From: sayan mallick
Subject: Search Connection API not working with filter
The 2nd filter which we are using to filter target entities after the inRelations or outRelations is not working and we are not getting expected result. If we start the search from Person and want to fetch all related contract entities where policy number is given, we are only getting the person information. No relations ad related entities.
For example
https://mpe-01.reltio.com/reltio/api/TenantId/entities/_searchConnections
Body:
{
"filter": "equals(type,'Person') and equals(attributes.CustomerId,'4352425')",
"connections": [
{
"outRelations": [
{
"uri": "configuration/relationTypes/PersonToContract1"
},
{
"uri": "configuration/relationTypes/PersonToContract2"
},
{
"uri": "configuration/relationTypes/PersonToContract3"
},
],
"filter": "equals(type,'Contract') and equals(attributes.policyNumber,'GAB12435')"
}
]
}
Response:
{
"entities": [
{
"uri": "entities/ytyt65",
"type": "configuration/entityTypes/Person",
"attributes": {
.....
},
"crosswalks": [
{
..........
}
]
}
]
}
------------------------------
sayan mallick
Aviva
------------------------------