Create a view of change type(cm3r) and use join query
Hi all, I have a problem with query when create a view: -How can we join 2 table (cm3r and another table eg. device, on condition cm3r.affected.item=device.logical.name) in the query area? You can see clearly in the picture I attached. Can any one help me with this query? Thank you so much. Quanhl.
Re: Create a view of change type(cm3r) and use join query
@Harn: thank you, I have a idea: I try to create calculations in format control of cm3r, (for example $file7, which get all device records that satisfy logical.name=affected.item). And I use $file7 in the basic query of that view. Now the basic query is: eg. department in $file7#"IT". But it can't work! Quanhl.