nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Query counting the number of values in a repeating property

mrgou

Hi,

I'm trying to identify all objects in my docbase which have more than 10 values in one of their repeating properties. I'm not aware of any function that returns the count of values for a repeating property, so I was wondering if anybody knows how to work around this?

Thanks!

Find more posts tagged with

Note:

If there are Accepted Answers, those will be shown by default. You can switch to 'All Replies' by selecting the tab below.

Button

Accepted answers

bacham2

select r_object_id,object_name,r_object_type from dm_sysobject where r_object_id in (select r_object_id from dm_sysobject where any (i_position < -9 and myrepeatingattr is not null))

All comments

bacham2

select r_object_id,object_name,r_object_type from dm_sysobject where r_object_id in (select r_object_id from dm_sysobject where any i_position < -9)

mrgou

Thanks! So how can I apply this for a specific repeating property? How can I specify which repeating property I'm trying to make a count on?

bacham2

select r_object_id,object_name,r_object_type from dm_sysobject where r_object_id in (select r_object_id from dm_sysobject where any (i_position < -9 and myrepeatingattr is not null))

mrgou

I have no idea how it works, but it does! Thanks!