Skip to Content
avatar image
Former Member

Attribute View - Row Count for a View

Hi

1.i have created a attribute View A. I need the  total count of Rows generated by the Attribute View.

how to find the total count

2.Where to find the SQL Query generated by Attribute View

Thanks in advance

Regards,

Suresh

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Sep 11, 2014 at 03:14 PM

    Select Data Preview on the view, then Raw Data. Select Show Log and then open the line with SQL. This will give you a SQL statement with the name of the view in "_SYS_BIC".

    SELECT COUNT(*) FROM VIEWNAME in another SQL window.

    Add comment
    10|10000 characters needed characters exceeded