cancel
Showing results for 
Search instead for 
Did you mean: 

Attribute View - Row Count for a View

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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.