Hi Jonna,
This is a column where we leverage bitwise operators to set multiple flags in the column. The following query will return legacy System Tasks only:
SELECT * FROM hsi.tasklist
WHERE
flags & 64 = 64
AND
flags & 67108864 <> 67108864
If you want to return Unity System Tasks only, this query will do the trick:
SELECT * FROM hsi.tasklist
WHERE
flags & 67108864 = 67108864
If you wanted to return Legacy and Unity System Tasks, this query should return all of them:
SELECT * FROM hsi.tasklist
WHERE
flags & 64 = 64
This is probably more than you wanted, but I am hopefully the additional queries will help other inquiring minds. One more detail is that the queries above are for SQL Server specifically. An Oracle query would need to leverage the bitwise AND operator. Here's an example of what that would look like:
SELECT * FROM hsi.tasklist
WHERE
bitand(flags, 64) = 64;
Hope this helps!
Best,
Joel
