Database view for incident and ar_incident tables

[User175049]

Is it possible to join an archive table in a database view? 

I have a request to create a report that would include records on the archive table and the incident table.  Creating a report for both tables is preferred over changing our Archive Rules for Incident.   The database view seems like the best option, and I am attempting to create one, but the database view table is missing records.

Any help is appreciated.

Thank you

[Maik Skoddow]

If the "ar_incident" table is not selectable in the database builder than you cannot build a database view.

[User175049]

I am able to add the ar_incident and the incident tables to the builder. However, I am not getting as many records as I would expect. The ar_incident table has 675,554 records and the incident table has 130,045 records. Oddly the database view also has 130,045 records, of which 184 are from ar_incident and 129,861 are from incident.  My goal is to fully combine the two tables so the total records should be 805,599.  

I do not have a Where clause in place. Could that be this issue? Or is a configuration somewhere else that I am missing? 

[varaprasad123]

Double-check your query logic to ensure you're joining the archive table (ar_incident) correctly with the incident table. Make sure you're using the appropriate keys or columns to join these tables. A mistake in the join condition could result in missing records.

[Bert_c1]

Post a screenshot of your database view, add 'Left join' to the column list of the View Tables. then folks here can assist better. there are plenty of Database View examples in your instance.