February 2020 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-5846) Support "order by" by default in the salesforce translator

by Renat Eskenin (Jira)

[ https://issues.redhat.com/browse/TEIID-5846?page=com.atlassian.jira.plugi... ] Renat Eskenin commented on TEIID-5846: -------------------------------------- Thanks! > Support "order by" by default in the salesforce translator > ---------------------------------------------------------- > > Key: TEIID-5846 > URL: https://issues.redhat.com/browse/TEIID-5846 > Project: Teiid > Issue Type: Bug > Components: Salesforce Connector > Environment: teiid-spring-boot+spring-odata teiid+spring-data-salesforce > Reporter: Renat Eskenin > Assignee: Steven Hawkins > Priority: Major > Fix For: 13.1 > > Original Estimate: 3 hours > Time Spent: 3 hours > Remaining Estimate: 0 minutes > > 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)

4 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5846) Support "order by" by default in the salesforce translator

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-5846?page=com.atlassian.jira.plugi... ] Steven Hawkins commented on TEIID-5846: --------------------------------------- You should see commit links on the right hand side of an issue under the Development heading. > Support "order by" by default in the salesforce translator > ---------------------------------------------------------- > > Key: TEIID-5846 > URL: https://issues.redhat.com/browse/TEIID-5846 > Project: Teiid > Issue Type: Bug > Components: Salesforce Connector > Environment: teiid-spring-boot+spring-odata teiid+spring-data-salesforce > Reporter: Renat Eskenin > Assignee: Steven Hawkins > Priority: Major > Fix For: 13.1 > > Original Estimate: 3 hours > Time Spent: 3 hours > Remaining Estimate: 0 minutes > > 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)

4 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5860) Salesforce translator should support self joins

by Ramesh Reddy (Jira)

[ https://issues.redhat.com/browse/TEIID-5860?page=com.atlassian.jira.plugi... ] Ramesh Reddy updated TEIID-5860: -------------------------------- Sprint: DV Sprint 59 > Salesforce translator should support self joins > ----------------------------------------------- > > Key: TEIID-5860 > URL: https://issues.redhat.com/browse/TEIID-5860 > Project: Teiid > Issue Type: Enhancement > Components: Salesforce Connector > Reporter: Renat Eskenin > Assignee: Steven Hawkins > Priority: Major > Fix For: 13.1 > > Original Estimate: 3 hours > Remaining Estimate: 3 hours > > In this query > {code} > SELECT originalLicense.Id,originalLicense.Status__c,originalLicense.ReplacementLicenseID__c,originalLicense.LicenseId__c,originalLicense.vlic_Contract_Number__c,replacementLicense.LicenseId__c as replacementLicenseId ,replacementLicense.LicenseId__c as replacementLicenseLicenseId FROM Product_License__c originalLicense LEFT OUTER JOIN /*+ MAKEDEP */ Product_License__c replacementLicense ON originalLicense.ReplacementLicenseID__c = replacementLicense.Id where originalLicense.vlic_Contract_Number__c = :contractNumber > {code} > We have two requests to salesforce, but could generate a single SOQL query. -- This message was sent by Atlassian Jira (v7.13.8#713008)

4 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5860) Salesforce translator should support self joins

by Ramesh Reddy (Jira)

[ https://issues.redhat.com/browse/TEIID-5860?page=com.atlassian.jira.plugi... ] Ramesh Reddy updated TEIID-5860: -------------------------------- Sprint: (was: DV Sprint 59) > Salesforce translator should support self joins > ----------------------------------------------- > > Key: TEIID-5860 > URL: https://issues.redhat.com/browse/TEIID-5860 > Project: Teiid > Issue Type: Enhancement > Components: Salesforce Connector > Reporter: Renat Eskenin > Assignee: Steven Hawkins > Priority: Major > Fix For: 13.1 > > Original Estimate: 3 hours > Remaining Estimate: 3 hours > > In this query > {code} > SELECT originalLicense.Id,originalLicense.Status__c,originalLicense.ReplacementLicenseID__c,originalLicense.LicenseId__c,originalLicense.vlic_Contract_Number__c,replacementLicense.LicenseId__c as replacementLicenseId ,replacementLicense.LicenseId__c as replacementLicenseLicenseId FROM Product_License__c originalLicense LEFT OUTER JOIN /*+ MAKEDEP */ Product_License__c replacementLicense ON originalLicense.ReplacementLicenseID__c = replacementLicense.Id where originalLicense.vlic_Contract_Number__c = :contractNumber > {code} > We have two requests to salesforce, but could generate a single SOQL query. -- This message was sent by Atlassian Jira (v7.13.8#713008)

4 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5846) Support "order by" by default in the salesforce translator

by Renat Eskenin (Jira)

[ https://issues.redhat.com/browse/TEIID-5846?page=com.atlassian.jira.plugi... ] Renat Eskenin commented on TEIID-5846: -------------------------------------- Hi! Can you give link to commit with this functionality? > Support "order by" by default in the salesforce translator > ---------------------------------------------------------- > > Key: TEIID-5846 > URL: https://issues.redhat.com/browse/TEIID-5846 > Project: Teiid > Issue Type: Bug > Components: Salesforce Connector > Environment: teiid-spring-boot+spring-odata teiid+spring-data-salesforce > Reporter: Renat Eskenin > Assignee: Steven Hawkins > Priority: Major > Fix For: 13.1 > > Original Estimate: 3 hours > Time Spent: 3 hours > Remaining Estimate: 0 minutes > > 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)

4 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5846) Support "order by" by default in the salesforce translator

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-5846?focusedWorklogId=12450059&pag... ] Steven Hawkins logged work on TEIID-5846: ----------------------------------------- Author: Steven Hawkins Created on: 07/Feb/20 11:02 AM Start Date: 07/Feb/20 11:01 AM Worklog Time Spent: 3 hours Issue Time Tracking ------------------- Remaining Estimate: 0 minutes (was: 3 hours) Time Spent: 3 hours Worklog Id: (was: 12450059) > Support "order by" by default in the salesforce translator > ---------------------------------------------------------- > > Key: TEIID-5846 > URL: https://issues.redhat.com/browse/TEIID-5846 > Project: Teiid > Issue Type: Bug > Components: Salesforce Connector > Environment: teiid-spring-boot+spring-odata teiid+spring-data-salesforce > Reporter: Renat Eskenin > Assignee: Steven Hawkins > Priority: Major > Fix For: 13.1 > > Original Estimate: 3 hours > Time Spent: 3 hours > Remaining Estimate: 0 minutes > > 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)

4 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5846) Support "order by" by default in the salesforce translator

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-5846?page=com.atlassian.jira.plugi... ] Steven Hawkins resolved TEIID-5846. ----------------------------------- Resolution: Done [~rareddy] it turns salesforce does provide the filter/search metadata. For some reason that was never utilized... Updated the metadata processor to consult the field level metadata. > Support "order by" by default in the salesforce translator > ---------------------------------------------------------- > > Key: TEIID-5846 > URL: https://issues.redhat.com/browse/TEIID-5846 > Project: Teiid > Issue Type: Bug > Components: Salesforce Connector > Environment: teiid-spring-boot+spring-odata teiid+spring-data-salesforce > Reporter: Renat Eskenin > Assignee: Steven Hawkins > Priority: Major > Fix For: 13.1 > > Original Estimate: 3 hours > Remaining Estimate: 3 hours > > 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)

4 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5846) Support "order by" by default in the salesforce translator

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-5846?page=com.atlassian.jira.plugi... ] Steven Hawkins updated TEIID-5846: ---------------------------------- Original Estimate: 3 hours Remaining Estimate: 3 hours Story Points: 0.5 Sprint: DV Sprint 59 > Support "order by" by default in the salesforce translator > ---------------------------------------------------------- > > Key: TEIID-5846 > URL: https://issues.redhat.com/browse/TEIID-5846 > Project: Teiid > Issue Type: Bug > Components: Salesforce Connector > Environment: teiid-spring-boot+spring-odata teiid+spring-data-salesforce > Reporter: Renat Eskenin > Assignee: Steven Hawkins > Priority: Major > Fix For: 13.1 > > Original Estimate: 3 hours > Remaining Estimate: 3 hours > > 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)

4 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5860) Salesforce translator should support self joins

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-5860?page=com.atlassian.jira.plugi... ] Steven Hawkins updated TEIID-5860: ---------------------------------- Original Estimate: 3 hours Remaining Estimate: 3 hours Story Points: 0.5 Sprint: DV Sprint 59 > Salesforce translator should support self joins > ----------------------------------------------- > > Key: TEIID-5860 > URL: https://issues.redhat.com/browse/TEIID-5860 > Project: Teiid > Issue Type: Enhancement > Components: Salesforce Connector > Reporter: Renat Eskenin > Assignee: Steven Hawkins > Priority: Major > Fix For: 13.1 > > Original Estimate: 3 hours > Remaining Estimate: 3 hours > > In this query > {code} > SELECT originalLicense.Id,originalLicense.Status__c,originalLicense.ReplacementLicenseID__c,originalLicense.LicenseId__c,originalLicense.vlic_Contract_Number__c,replacementLicense.LicenseId__c as replacementLicenseId ,replacementLicense.LicenseId__c as replacementLicenseLicenseId FROM Product_License__c originalLicense LEFT OUTER JOIN /*+ MAKEDEP */ Product_License__c replacementLicense ON originalLicense.ReplacementLicenseID__c = replacementLicense.Id where originalLicense.vlic_Contract_Number__c = :contractNumber > {code} > We have two requests to salesforce, but could generate a single SOQL query. -- This message was sent by Atlassian Jira (v7.13.8#713008)

4 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5898) Wrong force-wsc jar in translator / force.api module 41

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-5898?page=com.atlassian.jira.plugi... ] Steven Hawkins updated TEIID-5898: ---------------------------------- Fix Version/s: 7.6-13.0.2 > Wrong force-wsc jar in translator / force.api module 41 > ------------------------------------------------------- > > Key: TEIID-5898 > URL: https://issues.redhat.com/browse/TEIID-5898 > Project: Teiid > Issue Type: Bug > Components: Build/Kits > Affects Versions: 12.2 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Critical > Fix For: 13.1, 12.3.2, 13.0.3, 7.6-13.0.2 > > Original Estimate: 4 hours > Time Spent: 4 hours > Remaining Estimate: 0 minutes > > For some reason between 12.1 and 12.2 the wrong force-wsc began to be picked up in the 41 translator. This was not due to TEIID-5713 as the 12.1.2 kit is correct, so this was likely introduced by the wildfly related refactoring (but it's not clear why). -- This message was sent by Atlassian Jira (v7.13.8#713008)

4 years, 10 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues February 2020