Why is incorrect data shown in dataset preview, but correct in the database with the same query?

There are several potential reasons why incorrect data might appear in the dataset preview in AIV even though the query works fine in the database. Here are the possible causes and solutions:

1. Incorrect Data Source Selected:
   If the wrong data source is selected, the dataset will display incorrect data. Make sure to verify that the correct data source is chosen for your dataset.
   

2. Incorrect Table, Stored Procedure (SP), or View Used:
   The wrong table, stored procedure, or view may be used when creating the dataset. Double-check the names used to ensure you are querying the correct database objects.
   

3. Dataset Mismatch for Widgets:
   Sometimes, users create multiple datasets with the same name in different folders (e.g., one for development, another for live use). Ensure you have selected the correct dataset folder before adding it to your widget to avoid displaying the wrong data.
   

4. Stored Procedure or View Returning Incorrect Data:
   For complex calculations, views or stored procedures are often used. If these objects pull from multiple tables, there could be an issue with how the data is combined. Store the SP or view results into a temporary table to cross-check with the dataset preview to identify discrepancies.
   
   

   For inquiries, please contact support at support@aivhub.com.