We will go w/ Option 2

@qa: to test this feature: (See TruncationMessage.png for expected output.)

- Lets say a query will return 10k records.

- In Query Analyzer, specify a max results of 100 & then execute the query. Then launch VA. In VA, the status bar should show the truncated message. Also, if you click view data on the data pane, you should also see a truncated message.

- File > Options > Results > Status Panel Color. Toggle this option & then go back to VA. Click on view data -> ensure that no exception is encountered. Also, if you have multiple data sources & switch between data sources & ensure that no exception occurs.

- File > Options > Results > Status Panel Color => enable this option & set custom colors. Execute a query w/ max results truncation & ensure that the custom colors are displayed in status bar in VA window & in Data Pane view data. 

- Ensure that truncation message is not shown for view data when clicking on a chart segment.

- Ensure that in a multi data source situation, that the truncation message is not shown for a data source whose results are not truncated (both in Data Pane's View Data and VA status bar).

@nhi - I have checked-in the changes to SVN r54169. However, I am not sure if I caught all the situations where the status bar record truncation warning message should be updated. Please review my changes, especially where BIStudio#updateWarning methods are called.

When I extract data from a datasource that was "Truncated by Max Results", save as packaged workbook, and reopen the vizx file, the "Truncated by Max Results" is not being shown. Not sure what's expected here, but IMO it should be shown because when I refresh the extract, the "Truncated by Max Results" is shown. [SP] Agreed, it should be shown

Also, the following scenario does not show the "Truncated by Max Results" msg:

• Query Analyzer 1: Set max results and then run query
• Query Analyzer 2: Do not set max results and then run query
• Launch VA from Query Analyzer 2
• In VA, click the "Connect to Data" icon.
  • Select the query in Query Analyzer 1
• Result: "Truncated by Max Results" is not shown in VA regardless of which datasource is selected.

UPDATE: I've fixed the above with SVN #54176.  I've also merged this to US Trunk.

@Kin-Hong: Please review.

@QA: This involves a small persistence change where the "truncated" state is persisted. Please be sure to test migration to/from v17, with and without the "truncated" msg, for vizw and vizx files.

@nhi - SVN #54176 looks good to me.

3.In Query Analyzer specify Max Result 10 and execute the SELECT query and Launch Visual Analytics and Right click on Data Source and Select option 'Edit Query' and in 'Edit Query' window, click on 'Preview Result' 

Reopening this issue for following three scenario

Scenario 1: On Status bar of VA message, "10 records [Truncated by Max Results]" is displayed instead of "10 record(s) [Truncated by Max Results]" (Scenario1.png)

@nhi: pls address Scenario 3

Fixed in US Trunk SVN #54218 (19.0.0-dev-39) and US v18 Branch SVN #54219 (18.0.10-3)

Scenario 1

1. In QA specify the Max Result = 1000 ( out of total 9000 records) .

Execute the query and QA grid results shows the truncated message of 1000 records.

2. Open VA - VA shows the truncated messgae of 1000 records in Status bar and also in View Data.

3. Go back to Query Ananlyser and change the limit to 2000. 

Execute the query and updated truncation message is displayed with 2000 records .

4. Go to VA , Refresh Data source. 

Actual Result :-

1. The increased records are not fetched in VA. It still has 1000 record data  - Is this correct ? Shouldn't VA have a record set of 2000 records ? [SP] The existing behavior is correct. VA should not have a record set of 2000 records

2. Cause of #1 ,Same truncated message of 1000 records is displayed in status bar and View Data.

Scenario 2 

1. After #2 from above scenario , go to Query Analyser and remove the Max result limit .

All records are fetched and displayed in grid result. No warning is displayed now.

2. Go to VA , Refresh data source.

Actual result -> All results are not fetched . It still displayed 1000 records in view data.

3. Warning message is displayed as there are still 1000 records.

Is this correct behaviour? [SP] The existing behavior is correct. 

Please note : In both scenarios , right click on data source and select 'Edit Query'.

Change the 'Max Results' field or remove the limit.

Now on saving the query, Data source reflects the changes and truncated message of 2000 records is displayed for scenario 1 and no message is displayed for Scenario 2.

>>In VA, [Truncated by Max Results] message is displayed on the status bar and in View Data Window.

Result: After unchecking 'Use Extract' option, on VA status bar [Truncated by Max Results] message is not displayed.Is this expected behavior because after unchecking 'Use Extract' option [Truncated by Max Results] message is displayed in View Data Window.

@nhi: the desired behavior is that message should be displayed in Status bar. Make this change if straightforward (< half-hour) and low impact.

Fixed in US Trunk SVN #54233 and SVN #54240 (19.0.0-dev-40) and US v18 Branch SVN #54238 and SVN #54239 (18.0.10-4)

@nisha: pls verify & close in v19. You should have ADS build 19-dev-40 now.

Verified in Aqua Data Studio 19.0.0-alpha-2 : Verified migration scenario mentioned in this comment ,After unchecking 'Use Extract' option, on VA status bar [Truncated by Max Results] message is displayed. (Please refer screenshot verified_migration_v19.png and verified_migration_v19.vizx)