SAP CPI OData: Invalid filter expression: 'LogStart ge ... and LogEnd le ...'

[aayushaggarwal]

Hi experts,

Could you please suggest me that what is wrong with the below query:

$select=MessageGuid,CorrelationId,ApplicationMessageId,ApplicationMessageType,LogStart,LogEnd,Sender,Receiver,IntegrationFlowName,Status,AlternateWebLink,IntegrationArtifact,LogLevel,CustomStatus,TransactionId,PreviousComponentName&$filter=LogStart ge datetime’${property.StartDate}’ and LogEnd le datetime’${property.EndDate}’

Getting below error while deploying:

Invalid filter expression: 'LogStart ge datetime’2020-01-01T00:00:00 UTC’ and LogEnd le datetime’2020-09-24T10:35:38 UTC’'

Tried changing date formats as well.

Please assist me.

Thanks..

[Sriprasadsbhat]

Hello Aayush,

Please check the quotation marks.Below should work.While copying from SAP HELP or any browser it gets changed ( i guess some junk values will get added ).Please paste this string to Notepad++ or notepad and delete single quotes & add it again to use further in your query.Nothing worng in your query filter.

LogStart ge datetime'2020-09-21T00:00:00' and LogEnd le datetime'2020-09-24T10:35:38'

Regards,

Sriprasad shivaram Bhat

[former_member775757]

Hi ,

This query is not working for

me$select=MessageGuid,CorrelationId,ApplicationMessageId,ApplicationMessageType,LogStart,LogEnd,Sender,Receiver,IntegrationFlowName,Status,AlternateWebLink,IntegrationArtifact,LogLevel,CustomStatus,TransactionId,PreviousComponentName,$top=20&$filter=LogStart ge datetime’${property.StartDate}’ and LogEnd le datetime’${property.EndDate}’

We tried it to give it dynamically it is not working .but it is working for

($select=MessageGuid,CorrelationId,ApplicationMessageId,ApplicationMessageType,LogStart,LogEnd,Sender,Receiver,IntegrationFlowName,Status,AlternateWebLink,IntegrationArtifact,LogLevel,CustomStatus,TransactionId,PreviousComponentName&$filter=LogStart ge datetime'2022-03-28T00:00:00' and LogEnd le datetime'2022-03-28T11:59:00')

How to handle the the fetch data from dynamically, can you please help me out this.

Thanks

ABDUL

[dirugadr]

Hello, did some of you solve this issue? I'm having the same at this moment....