[teiid-issues] [JBoss JIRA] (TEIID-3034) Add support for OData query parameters

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-3034?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12985330#comment-12985330 ] 

Steven Hawkins commented on TEIID-3034:
---------------------------------------

> ?$inlineCount=allpages&$top=N : always returns count = $top

This was addressed by TEIID-2935

> $expand : does not appear to work (but no ostensible error)

Yes, it's documented that expand does not work.  You would prefer an error correct?

> $count : "TEIID30088 Unrelated order by column g0.SYSID cannot be used in a SET query, with SELECT DISTINCT, or GROUP BY" occurs using this URI pattern entity/$count , per the OData documentation for using this parameter

Yes that is an issue.  The query that is being generated is SELECT count(*) from tbl order by pk - it should not have the order by.

> Add support for OData query parameters
> --------------------------------------
>
>                 Key: TEIID-3034
>                 URL: https://issues.jboss.org/browse/TEIID-3034
>             Project: Teiid
>          Issue Type: Feature Request
>      Security Level: Public(Everyone can see) 
>          Components: OData
>    Affects Versions: 8.7
>            Reporter: Greg MacKinnon
>            Assignee: Steven Hawkins
>            Priority: Minor
>
> There are some OData v2 query parameters that don't appear to work as of Teiid 8.7 (please see teiid forum thread 241566 on this topic). I believe these are all OData v2 conventions.
> ?$inlineCount=allpages&$top=N   :  always returns count = $top
> $expand   : does not appear to work (but no ostensible error)
> $count  :  "TEIID30088 Unrelated order by column g0.SYSID cannot be used in a SET query, with SELECT DISTINCT, or GROUP BY"  occurs using this URI pattern entity/$count  , per the OData documentation for using this parameter



--
This message was sent by Atlassian JIRA
(v6.2.6#6264)