CODEWITHSUNDEEP
restodatafiltering
befre
befre

Reputation: 79

Odata. Filter for some string field not working

Im using Odata v3 with 1C Enterprise 8.3.10. on Apache Tomcat 2.2. This query http://localhost/TEST/odata/standard.odata/AccountingRegister_Типовой/Balance()?$top=1
returns such result:

<d:Result xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices" xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata" m:type="Collection(StandardODATA.AccountingRegister_Типовой_Balance)">
    <d:element m:type="StandardODATA.AccountingRegister_Типовой_Balance">
        <d:Account_Key>8064bbd7-6b39-11e1-978d-00265502bde5</d:Account_Key>
        <d:ExtDimension1>3e0969a1-6b39-11e1-978d-00265502bde5</d:ExtDimension1>
        <d:ExtDimension1_Type>StandardODATA.Catalog_ОсновныеСредства</d:ExtDimension1_Type>
        ...            
    </d:element>
</d:Result>

when I try adding filter http://localhost/TEST/odata/standard.odata/AccountingRegister_Типовой/Balance()?$top=1&$filter=ExtDimension1 eq '3e0969a1-6b39-11e1-978d-00265502bde5'
It returns empty result.
The type of 'ExtDimension1' field is Edm.String, not guid
(from $metadata)

<ComplexType Name="AccountingRegister_Типовой_Balance">
    <Property Name="Account_Key" Type="Edm.Guid" Nullable="true"/>
    <Property Name="ExtDimension1" Type="Edm.String" Nullable="true"/>
    <Property Name="ExtDimension1_Type" Type="Edm.String" Nullable="true"/>
    ...

I also tried to filter like this:
$filter=ExtDimension1 eq guid'3e0969a1-6b39-11e1-978d-00265502bde5'
but it returns an error.

If I filter by another field (for example ExtDimension1_Type) it works correctly.
Does anybody know how to filter by 'ExtDimension1' field?

UPDATE
Here is description of Balance() function from metadata. Hope it will be usefull 

<FunctionImport Name="Balance" IsBindable="true" IsSideEffecting="false" ReturnType="Collection(StandardODATA.AccountingRegister_Типовой_Balance)">
    <Parameter Name="bindingParameter" Type="StandardODATA.AccountingRegister_Типовой"/>
    <Parameter Name="AccountCondition" Type="Edm.String"/>
    <Parameter Name="Condition" Type="Edm.String"/>
    <Parameter Name="Dimensions" Type="Edm.String"/>
    <Parameter Name="ExtraDimensions" Type="Edm.String"/>
    <Parameter Name="Period" Type="Edm.DateTime"/>
</FunctionImport>

Upvotes: 1

Views: 953

Answers (2)

Ilya Koryapkin
Ilya Koryapkin

Reputation: 26

I had a similar problem and I found a solution.

$filter=ExtDimension1 eq cast('3e0969a1-6b39-11e1-978d-00265502bde5', 'Catalog_ОсновныеСредства')

Upvotes: 1

ikirachen
ikirachen

Reputation: 77

Try: http://localhost/TEST/odata/standard.odata/AccountingRegister_Типовой/Balance?$top=1&$filter=ExtDimension1 eq '3e0969a1-6b39-11e1-978d-00265502bde5' E.g. remove '()' or Specify number: http://localhost/TEST/odata/standard.odata/AccountingRegister_Типовой/Balance(1)?$top=1&$filter=ExtDimension1 eq '3e0969a1-6b39-11e1-978d-00265502bde5'

Upvotes: 0

Related Questions