search

SAP / olingo-jpa-processor-v4

The JPA Processor fills the gap between Olingo V4 and the database, by providing a mapping between JPA metadata and OData metadata, generating queries and supporting the entity manipulations.
Apache License 2.0
122 stars 76 forks source link

Filtering with Edm.Date #206

Open kishanp519 opened 1 year ago

kishanp519 commented 1 year ago

Is there any information on filtering with Edm.Date:

The exact filter is: /Opportunity?%24top=50&%24filter=CloseDate%20ge%202023-01-01%20and%20CloseDate%20lt%202023-04-01&%24count=true&%24select=Id](https://ds-useast1.ownbackup.com:4003/Backup20230223_a409d7/Opportunity?%24top=50&%24filter=CloseDate%20ge%202023-01-01%20and%20CloseDate%20lt%202023-04-01&%24count=true&%24select=Id)

The metadata is: 

<EntityType Name="Opportunity">
                <Key>
                    <PropertyRef Name="Id"/>
                </Key>
                <Property Name="HasOpenActivity" Type="Edm.Boolean"/>
                <Property Name="CurrentGeneratorsC" Type="Edm.String" MaxLength="100"/>
                <Property Name="HasOverdueTask" Type="Edm.Boolean"/>
                <Property Name="TotalOpportunityQuantity" Type="Edm.Double"/>
                <Property Name="SystemModstamp" Type="Edm.DateTimeOffset" Precision="0"/>
                <Property Name="Description" Type="Edm.String" MaxLength="16777215"/>
                <Property Name="IsPrivate" Type="Edm.Boolean"/>
                <Property Name="Type" Type="Edm.String" MaxLength="65535"/>
                <Property Name="OwnerId" Type="Edm.String" MaxLength="18"/>
                <Property Name="Pricebook2id" Type="Edm.String" MaxLength="18"/>
                <Property Name="StageName" Type="Edm.String" MaxLength="65535"/>
                <Property Name="DeliveryInstallationStatusC" Type="Edm.String" MaxLength="65535"/>
                <Property Name="IsDeleted" Type="Edm.Boolean"/>
                <Property Name="LastActivityDate" Type="Edm.Date"/>
                <Property Name="LastModifiedById" Type="Edm.String" MaxLength="18"/>
                <Property Name="ForecastCategoryName" Type="Edm.String" MaxLength="65535"/>
                <Property Name="MainCompetitorsC" Type="Edm.String" MaxLength="100"/>
                <Property Name="TrackingNumberC" Type="Edm.String" MaxLength="12"/>
                <Property Name="Id" Type="Edm.String" Nullable="false" MaxLength="18"/>
                <Property Name="HasOpportunityLineItem" Type="Edm.Boolean"/>
                <Property Name="CreatedById" Type="Edm.String" MaxLength="18"/>
                <Property Name="ExpectedRevenue" Type="Edm.Double"/>
                <Property Name="Amount" Type="Edm.Double"/>
                <Property Name="OrderNumberC" Type="Edm.String" MaxLength="8"/>
                <Property Name="FiscalQuarter" Type="Edm.Int32"/>
                <Property Name="ContactId" Type="Edm.String" MaxLength="18"/>
                <Property Name="LastModifiedDate" Type="Edm.DateTimeOffset" Precision="0"/>
                <Property Name="LastStageChangeDate" Type="Edm.DateTimeOffset" Precision="0"/>
                <Property Name="Probability" Type="Edm.Double"/>
                <Property Name="LeadSource" Type="Edm.String" MaxLength="65535"/>
                <Property Name="CampaignId" Type="Edm.String" MaxLength="18"/>
                <Property Name="LastCloseDateChangedHistoryId" Type="Edm.String" MaxLength="18"/>
                <Property Name="LastAmountChangedHistoryId" Type="Edm.String" MaxLength="18"/>
                <Property Name="CloseDate" Type="Edm.Date"/>
                <Property Name="IsWon" Type="Edm.Boolean"/>
                <Property Name="AccountId" Type="Edm.String" MaxLength="18"/>
                <Property Name="CreatedDate" Type="Edm.DateTimeOffset" Precision="0"/>
                <Property Name="IsClosed" Type="Edm.Boolean"/>
                <Property Name="Fiscal" Type="Edm.String" MaxLength="6"/>
                <Property Name="PushCount" Type="Edm.Int32"/>
                <Property Name="ForecastCategory" Type="Edm.String" MaxLength="256"/>
                <Property Name="Name" Type="Edm.String" MaxLength="120"/>
                <Property Name="NextStep" Type="Edm.String" MaxLength="65535"/>
                <Property Name="FiscalYear" Type="Edm.Int32"/>
            </EntityType>