on 2018 Sep 04 3:48 PM
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?
Request clarification before answering.
| User | Count |
|---|---|
| 4 | |
| 2 | |
| 1 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.