Data export after SELECT WHERE in CQB and CM

Details

Description

Many of DBAs and Developers use Data import/export feature in CM, CQB.
However they only support "column check option" in the table, which means I have to export all records from the table.
However most of cases need to extract only data satisfying a condition.

When DATA export, it should support a SELECT statement with a condition so that users only extract partial records.
CMT has already support this feature however CM and CQB more needs at this moment.

  1. File
    CODE_REVIEW.creview
    11/Mar/12 10:19 PM
    58 kB
    付雷
  1. T1.PNG
    25 kB
    18/Mar/12 11:15 AM
  2. T2.PNG
    75 kB
    18/Mar/12 11:15 AM
  3. x6.PNG
    16 kB
    24/Mar/12 12:40 PM

Issue Links

relates to

New Feature - A new feature of the product, which has yet to be developed. TOOLS-795 It is needed to import *.sql

  • Minor - Minor loss of function, or other problem where easy workaround is present.
  • Closed - The issue is considered finished, the resolution is correct. Issues which are closed can be reopened.

Improvement - An improvement or enhancement to an existing feature or task. TOOLS-787 Supporting NULL data option for both Data Import and Export and moving the option setting menu inside Data import, Export UI

  • Major - Major loss of function.
  • Closed - The issue is considered finished, the resolution is correct. Issues which are closed can be reopened.

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
付雷 (Inactive) added a comment -

Fixed

Show
付雷 (Inactive) added a comment - Fixed
Hide
Permalink
Isaiah Choe added a comment -

Test process
1. Click a table that you want to export on left pane. (T1.PNG)
2. Input where condition without "Where" keyword on Condition (where) column. (T2.PNG)
3. Click Export button

Show
Isaiah Choe added a comment - Test process 1. Click a table that you want to export on left pane. (T1.PNG) 2. Input where condition without "Where" keyword on Condition (where) column. (T2.PNG) 3. Click Export button
Hide
Permalink
Isaiah Choe added a comment -

I was using where clause, but it exported no data.
For instance, I add s_name='M' in where clause on the code table of the demodb.
But, exported results has no record.

Show
Isaiah Choe added a comment - I was using where clause, but it exported no data. For instance, I add s_name='M' in where clause on the code table of the demodb. But, exported results has no record.
Hide
Permalink
付雷 (Inactive) added a comment -

Fixe a bug about casesensitive

Show
付雷 (Inactive) added a comment - Fixe a bug about casesensitive
Hide
Permalink
Isaiah Choe added a comment -

To QA:
1. Right click a table and click "Export Data.." on the left navigation tree
2. Input a where statement on "Condition (where)" tab of table list
ex) where s_name = 'M' on code table
3. Click the Browse.. button and select any folder
4. Click the Export button
5. see {table}.csv and check an exported data

Show
Isaiah Choe added a comment - To QA: 1. Right click a table and click "Export Data.." on the left navigation tree 2. Input a where statement on "Condition (where)" tab of table list ex) where s_name = 'M' on code table 3. Click the Browse.. button and select any folder 4. Click the Export button 5. see {table}.csv and check an exported data
Hide
Permalink
Isaiah Choe added a comment -

Please see the x6.png of attached images.
In "Select the columns of table or view to be exported.",
The right tab title is "Condition (where)" but the left tab title is empty.
It should be named, I think, "Tables" is sutable.

Show
Isaiah Choe added a comment - Please see the x6.png of attached images. In "Select the columns of table or view to be exported.", The right tab title is "Condition (where)" but the left tab title is empty. It should be named, I think, "Tables" is sutable.
Hide
Permalink
付雷 (Inactive) added a comment -

Fixed

Show
付雷 (Inactive) added a comment - Fixed
Hide
Permalink
高艳铭 added a comment -

Fixed in CM8.4.1.2003

Show
高艳铭 added a comment - Fixed in CM8.4.1.2003

People

  • Assignee:
    高艳铭
    Reporter:
    Laura Oh
Vote (0)
Watch (0)

Dates

  • Created:
    Updated:
    Resolved: