[teiid-issues] [JBoss JIRA] (TEIIDSB-135) top in odata query is not working
Steven Hawkins (Jira)
issues at jboss.org
Tue Nov 12 10:23:07 EST 2019
[ https://issues.jboss.org/browse/TEIIDSB-135?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13811469#comment-13811469 ]
Steven Hawkins commented on TEIIDSB-135:
----------------------------------------
If you are using a ddl vdb, you can specify the property in the option clause of the create server statement:
{code}
CREATE SERVER samplesf FOREIGN DATA WRAPPER salesforce OPTIONS ("resource-name" 'samplesf', supportsOrderBy true);
{code}
Actually it does not appear that you can use application.properties for translator properties.
> top in odata query is not working
> ---------------------------------
>
> Key: TEIIDSB-135
> URL: https://issues.jboss.org/browse/TEIIDSB-135
> Project: Teiid Spring Boot
> Issue Type: Bug
> Components: OData
> Affects Versions: 1.2.0
> Environment: teiid-spring-boot+spring-odata teiid+spring-data-salesforce
> Reporter: Renat Eskenin
> Priority: Major
>
> When we call simple request as
> salesforce-odata-facade/odata/salesforce/Product_License__c?$top=1&$select=Id
> request processing time is 1min. But this request processing by simple SOAP SOQL request is ~150ms.
> I think this do because teiid select all objects by ignoring top in request.
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
More information about the teiid-issues
mailing list