cancel
Showing results for 
Search instead for 
Did you mean: 

Exclude Items in Impex batchmode

Former Member
0 Kudos

Is it possible to update all items of a Type but one?
There is a new Category that should be the parent category of all "sub-categories" (Categories that already have a parent).
When I run the following impex, I (obviously) get the error cannot assign subcategory <code>(pk-xxx) as super category of [<code>(pk-xxx)] - cycle detected:

 UPDATE Category[batchmode=true];itemtype(code)[unique=true];$catalogVersion;supercategories(code, $catalogVersion);
 ;Category;$catalog_version;category-code:$catalog_version

Basically, talking in SQL, it would be something like this: UPDATE table SET column=value WHERE another_column <> 'some value'

What is the correct syntax to achieve this, if possible?

Accepted Solutions (0)

Answers (0)