Sample queries for items in a collaboration area

These sample queries search for items in a collaboration area.

Sample 1

This sample query searches for all items in the ca01 item collaboration area that are in step mod and that have a pk attribute value that is not empty.

		select item 
		from collaboration_area('ca01') 
		where item['spec01/pk'] is not null  and item.step.path = 'mod'

Sample 2

This sample query searches for all items in the ca01 item collaboration area that are in step mod and that are reserved by the user Admin.

		select item 
		from collaboration_area('ca01') 
		where item.step.reserved_by = 'Admin' and item.step.path = 'mod'

Sample 3

The description of all items in the collaboration area grocery store catalog ca for item catalog with a primary spec spec.

select item[‘spec/desc']
from collaboration_area (‘grocery store catalog ca')

Sample 4

Search for the description of all categories in the collaboration area grocery store hierarchy ca with a primary spec spec.

select category [‘spec/desc']
from collaboration_area (‘grocery store hierarchy ca')