I want to filter based on one field with two values.

[anilkumar_sangareddy8]

Hi All,

I have a requirement where i need to extract monitor report from SCPI and able to extract that monitor report but in that i need only for two artifact data while i'm using to filter that payload by using filter pallet it is working for one value and if i'm applying for second value is not working, the entire payload it is coming. Can any one help out with this solution and below is the payload.

<?xml version="1.0" encoding="UTF-8"?>

<MessageProcessingLogs>

<MessageProcessingLog>

<IntegrationFlowName>I0152_O2A_Retrieve</IntegrationFlowName>

<Completed>1</Completed>

<Failed>0</Failed>

<Processing>0</Processing>

<Retry>0</Retry>

<Escalated>0</Escalated>

</MessageProcessingLog>

<MessageProcessingLog>

<IntegrationFlowName>Retrieve_Jones</IntegrationFlowName>

<Completed>1</Completed>

<Failed>0</Failed>

<Processing>0</Processing>

<Retry>0</Retry>

<Escalated>0</Escalated>

</MessageProcessingLog>

<MessageProcessingLog>

<IntegrationFlowName>Enrich_Acknowledgement</IntegrationFlowName>

<Completed>1</Completed>

<Failed>0</Failed>

<Processing>0</Processing>

<Retry>0</Retry>

<Escalated>0</Escalated>

</MessageProcessingLog>

<MessageProcessingLog>

<IntegrationFlowName>Enrich_Acknowledgement</IntegrationFlowName>

<Completed>1</Completed>

<Failed>0</Failed>

<Processing>0</Processing>

<Retry>0</Retry>

<Escalated>0</Escalated>

</MessageProcessingLog>

<MessageProcessingLog>

<IntegrationFlowName>I0139_-_DJRA</IntegrationFlowName>

<Completed>1</Completed>

<Failed>0</Failed>

<Processing>0</Processing>

<Retry>0</Retry>

<Escalated>0</Escalated>

</MessageProcessingLog>

<MessageProcessingLogs>

[daviddasilva]

Hi,

Without seeing your current filter query it is hard to know what could be going wrong. I would guess you would need to use and OR statement to get what you need.

If it is in OData for example, it would be something like ?$filter= field1 eq 'ABC' or field1 eq 'DEF'

Kind regards,

David

[anilkumar_sangareddy8]

Hi David,

Here is the screen shot for ODATA query and i have removed the filtering of filed.

[daviddasilva]

Hi Anil,

Your filter looks ok to me. I suppose you should check the values of your Properties and see if the filter is actually working as it should. It could be that all the entries do in fact meet the filter query.

Have you tried testing this through Postman?

Kind regards,

David

[Sriprasadsbhat]

Hello Anil,

Could you please share sample query you are running here.

Regards,

Sriprasad Shivaram Bhat

[anilkumar_sangareddy8]

Hi SriPrasad,

Here is the screen shot for ODATA query and i have removed the filtering of filed.