What exactly is the syntax for a filtered query using the client.GetAsync() method?

sschapma · July 12, 2018, 8:56pm

I have been trying for hours to return a filtered list of documents with no luck. I can, however, pull the whole list when I call the GetAsync method with no arguments. The following code keeps coming back with

“No function signature for the function with name ‘contains’ matches the specified arguments. The function signatures considered are: contains(Edm.String Nullable=true, Edm.String Nullable=true).”

var category = “data/Description”;
var term = “ESV”;
var tryme = String.Format(“contains({0}, {1})”, term, category);

var client = clientManager.GetClient<Documentation, DocumentationData>(“productdocs”);
var docs = await client.GetAsync(filter : tryme);

Any help would be great.

Thanks

Sebastian · July 13, 2018, 11:38am

I have to improve the docs, but you can check the tests in the meantime:

github.com

Squidex/squidex/blob/master/tests/Squidex.Domain.Apps.Entities.Tests/Contents/OData/ODataQueryTests.cs#L173


{
    var i = F("$filter=endswith(data/firstName/de, 'Sebastian')");
    var o = C("{ 'do.1.de' : /Sebastian$/i }");


    Assert.Equal(o, i);
}


[Fact]
public void Should_make_query_with_cointains()
{
    var i = F("$filter=contains(data/firstName/de, 'Sebastian')");
    var o = C("{ 'do.1.de' : /Sebastian/i }");


    Assert.Equal(o, i);
}


[Fact]
public void Should_make_query_with_equals()
{
    var i = F("$filter=contains(data/firstName/de, 'Sebastian') eq true");
    var o = C("{ 'do.1.de' : /Sebastian/i }");