OData Query: Getting several rows based on a column criteria

Question

I have a table that holds an attribute field and its corresponding value. For an instance several attributes are applicable, and I would like to return a specific set of attributes for this instance.

    |Attribute|Value|
    ----------
    | A       | 1   |
    ----------
    | B       | 2   |
    ----------
    | C       | 3   |
    ----------

How can I query with Odata to get attribute A and C and their corresponding values?

As of now I'm only able to get a single row with $filter=endswith(Attribute, 'A').

That worked, thanks :) If you reply as answer I can mark that as solution? — jonas, May 18 '15 at 12:16

score 1 · Accepted Answer · answered May 18 '15 at 12:44

1

You can simply add more filters with or operator on ODATA query, something like this:

$filter=(endswith(Attribute, 'A') or endswith(Attribute, 'C'))

answered May 18 '15 at 12:44

cuongle

74,024
28
151
206

The key element for me here was to surround the hole query with () and their sub-queries by their own ()'s. – jonas May 22 '15 at 08:15

OData Query: Getting several rows based on a column criteria

1 Answers1