https://issues.qgis.org/https://issues.qgis.org/favicon.ico2015-05-19T04:36:22ZQGIS Issue TrackingQGIS Application - Bug report #12774: Attribute table only show first 99 rows from SQL Server viewshttps://issues.qgis.org/issues/12774?journal_id=611522015-05-19T04:36:22ZJason Moorejasmo380@gmail.com
<ul></ul><p>I was wrong, this behavior is not found from the local SQL Server db. I get all rows from the same views.</p> QGIS Application - Bug report #12774: Attribute table only show first 99 rows from SQL Server viewshttps://issues.qgis.org/issues/12774?journal_id=612562015-05-21T06:54:15ZJason Moorejasmo380@gmail.com
<ul></ul><p>Found that views return all rows if the setting Options->Data Sources->Attribute table row cache is set to anything but "All". When set to all attribute table returns 99 or 100 rows.</p> QGIS Application - Bug report #12774: Attribute table only show first 99 rows from SQL Server viewshttps://issues.qgis.org/issues/12774?journal_id=612652015-05-21T21:26:29ZGiovanni Manghigiovanni.manghi@gmail.com
<ul><li><strong>Status</strong> changed from <i>Open</i> to <i>Feedback</i></li></ul><p>Jason Moore wrote:</p>
<blockquote>
<p>Found that views return all rows if the setting Options->Data Sources->Attribute table row cache is set to anything but "All". When set to all attribute table returns 99 or 100 rows.</p>
</blockquote>
<p>do you mean "attribute table behavior" or "attribute table row cache"? does it happens for other datasources?</p> QGIS Application - Bug report #12774: Attribute table only show first 99 rows from SQL Server viewshttps://issues.qgis.org/issues/12774?journal_id=612662015-05-21T21:26:40ZGiovanni Manghigiovanni.manghi@gmail.com
<ul><li><strong>Category</strong> changed from <i>Data Provider</i> to <i>Data Provider/MSSQL</i></li></ul> QGIS Application - Bug report #12774: Attribute table only show first 99 rows from SQL Server viewshttps://issues.qgis.org/issues/12774?journal_id=613632015-05-22T09:55:30ZJason Moorejasmo380@gmail.com
<ul></ul><p>Attribute table cache. And I have found any other data sources that exhibit this behavior. Tried shp and dxf.</p> QGIS Application - Bug report #12774: Attribute table only show first 99 rows from SQL Server viewshttps://issues.qgis.org/issues/12774?journal_id=613642015-05-22T09:57:20ZJason Moorejasmo380@gmail.com
<ul></ul><p>Jason Moore wrote:</p>
<blockquote>
<p>Attribute table cache. And I haven't found any other data sources that exhibit this behavior. Tried shp and dxf.</p>
</blockquote> QGIS Application - Bug report #12774: Attribute table only show first 99 rows from SQL Server viewshttps://issues.qgis.org/issues/12774?journal_id=624412015-06-17T20:20:46ZNathan Woodrow
<ul></ul><p>Do you still see this happening. I can't reproduce it here</p> QGIS Application - Bug report #12774: Attribute table only show first 99 rows from SQL Server viewshttps://issues.qgis.org/issues/12774?journal_id=624812015-06-18T02:27:40ZJason Moorejasmo380@gmail.com
<ul></ul><p>Still happens, only on non-spatial attribute tables (looks like only those that reference views in mssql) and only if Options->Data Sources->Attribute table row cache is set to all.</p> QGIS Application - Bug report #12774: Attribute table only show first 99 rows from SQL Server viewshttps://issues.qgis.org/issues/12774?journal_id=624952015-06-18T13:36:58ZNathan Woodrow
<ul></ul><p>So just to check that is: non spatial tables which are views?</p> QGIS Application - Bug report #12774: Attribute table only show first 99 rows from SQL Server viewshttps://issues.qgis.org/issues/12774?journal_id=664472015-12-19T13:11:53ZGiovanni Manghigiovanni.manghi@gmail.com
<ul><li><strong>Resolution</strong> set to <i>not reproducable</i></li></ul><p>closing for lack of feedback.</p> QGIS Application - Bug report #12774: Attribute table only show first 99 rows from SQL Server viewshttps://issues.qgis.org/issues/12774?journal_id=667962015-12-27T12:14:21ZGiovanni Manghigiovanni.manghi@gmail.com
<ul><li><strong>Status</strong> changed from <i>Feedback</i> to <i>Closed</i></li></ul>