Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Simplify SQL invoked for list of Export Tasks #1683

Closed
gunterze opened this issue Nov 17, 2018 · 0 comments
Closed

Simplify SQL invoked for list of Export Tasks #1683

gunterze opened this issue Nov 17, 2018 · 0 comments
Assignees
@vrindanayak
Labels
enhancement New feature or request
Milestone
5.15.0

Comments

@gunterze
Copy link
Member

gunterze commented Nov 17, 2018 •
edited by vrindanayak

There is no need for the sub-select

exporttask0_.queue_msg_fk in (select queuemessa2_.pk from queue_msg queuemessa2_ ...)

because all filter attributes (except status and batchID) are columns of the export_task table.

If query parameter status is specified with a value != TO_SCHEDULE or if batchID is specified, an inner join can be used.

Related #1682
@gunterze gunterze added the enhancement New feature or request label Nov 17, 2018
@gunterze gunterze added this to the 5.15.0 milestone Nov 17, 2018
@gunterze gunterze changed the title Simply SQL invoked for list of Export Tasks Simplify SQL invoked for list of Export Tasks Nov 17, 2018
vrindanayak added a commit that referenced this issue Nov 20, 2018
@vrindanayak
Simplify SQL invoked for list of Export Tasks #1683
aacc093
vrindanayak added a commit that referenced this issue Nov 20, 2018
@vrindanayak
RESTful service to delete multiple export tasks #1163 not working as …
14d58b8 
…expected : caused by changes done for #1575

- simplify SQL similar to changes done for #1682, #1683
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@vrindanayak vrindanayak

Labels
enhancement New feature or request
Projects
None yet
Milestone
5.15.0
Development

No branches or pull requests
2 participants
@gunterze @vrindanayak