How to know If an attributte is been used in a view? Workview

[Alejandro_Cont1]

I want to know which attributes are active in a view on workview, May be if you know a query that i can use.

Thanks.

[Stefan_Sulea]

Hi Alejandro,

Here's a query which does this:

select 	fields.rmname FieldName	,props.value AttributeID	,attrs.attributename AttributeName	,views_.rmname ViewNamefrom	hsi.rmcomponent fields 	inner join hsi.rmcomponent views_ on fields.primarycomponentid = views_.rmcomponentid	inner join hsi.rmcomponentprop props on fields.rmcomponentid = props.rmcomponentid and props.rmcomponentproperty = 105	inner join hsi.rmattribute attrs on props.value = attrs.attributeidwhere	fields.rmcomponenttype = 16

[Alejandro_Cont1]

Thanks this will be very helpfully.