Jump to content
JakubH

Find changesets where a specific attribute is not set

Recommended Posts

Is there a way how to find all changesets (branches, items, etc.) which has not set a specific attribute?

In SQL I can do something like:

SELECT * FROM changesets EXCEPT SELECT * FROM changesets WHERE attribute="xyz"

How to do it using find in Plastic?

 

Share this post


Link to post
Share on other sites

You can do something like:

cm find "branch where Attribute!='STATUS'"

But only the branches having attributes different then "STATUS" are going to be listed, the ones without an attribute not :(

Share this post


Link to post
Share on other sites

Hey, manu! That is not the most intuitive interpretation of [where attribute != 'myattribute'].

 

As I understand, it currently means [where count attributes > 0 AND the SPECIFIC attribute 'myattribute' is NOT applied].

 

I'm arguing in my support ticket 8642 that the meaning of that filter line [where attribute != "myattribute"] should be changed to mean simply [where the SPECIFIC attribute 'myattribute' is NOT applied].

 

Sure, that would change the meaning but i doubt that anyone finds the current interpretation very useful!

Share this post


Link to post
Share on other sites

Hey, my coworker just found out that writing :

cm find branch where not attribute = 'STATUS'

does exactly what's asked for here, namely find the branches that do NOT have that specific attribute "STATUS" regardless of whether there are other attributes or not.

 

I'm baffled that Codice staff could not provide us with this answer? Or was this silently added recently? (I'm running Plastic SCM 5.4.16.731.)

:P

  • Like 1

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...