Dumb Question - Trying to get set of all objects

[wikitect]

I'm trying to do some operations on all the objects in the project.

GetElementSet (string IDList, long Options) looks to be the thing to use (to avoid having to recurse). The words say if no value is specified for IDList then all objects are returned.

What, exactly is the form to use? Have tried empty brackets and an empty pair of string quotes but this clearly isn't right!

Any clues gratefully received!

[Geert Bellekens]

have you tried null?

On another note, are you sure you want ALL objects this way?
That is going to take ages I'm afraid.

Geert

[wikitect]

Null as in nill entry?  Yes.

I want the set of all objects - if there is another way I'm open to suggestions. The alternative is recursion.

I want to remove old tagged values that are no longer needed but which add to the size of the repository. This is essential house-cleaning and not something that I hope to do very often!

[beginner]

You might consider to use SQLQuery.

b.

[wikitect]

The problem - certainly using JET - is that it won't support update queries so you can't change values wholesale using SQL.

Given that I know that the delete method in the JScript does the job needed and I only need the form of this 1 instruction to get it to work on the whole project it's probably easier solving this problem rather than a new set caused by the SQL and consistent deletion of tagged value entries.

[Geert Bellekens]

Yes, in that case you better use an SQL query to only select those with the offending tagged values. (saves you a lot of time having to weed through all objects to find those with the tagged values you are after)
The GetElementSet can also be used with a sql query as input that selects the id's of the elements you are after.

Geert

[wikitect]

I can see how to execute a query

Code: [Select]

Repository.SQLQuery()
but it wraps everything in XML which isn't what I want. Is there some way to just return the element IDs without the XML?

[Geert Bellekens]

Read up on the GetElementSet operation.
You can do something like:

Code: [Select]

GetElementSet ("select o.ObjectID from t_object o join t_objectproperties tag where tag.property like 'old_tag_name'", 2)

That should give you a collection of objects with a tag of the given name.

Geert

[wikitect]

That should do very nicely!  

Thanks.

[wikitect]

Looking at the official description:

Code: [Select]

2 - Use IDList string as an SQL query to populate this collection.
I didn't get the meaning i.e. that you can use a SQL query to provide the IDList.

The wording could definitely be improved.

[Geert Bellekens]

Read up on the GetElementSet operation.
You can do something like:

Code: [Select]

GetElementSet ("select o.ObjectID from t_object o join t_objectproperties tag where tag.property like 'old_tag_name'", 2)

That should give you a collection of objects with a tag of the given name.

Geert