Forum Discussion

Former_Member's avatar
Former_Member
Ideator I
8 years ago

How to query for the latest generation of items that the user has access to?

Hi, I would like to ignore the "is_current" property when querying for items, and instead return the latest generation of each item that the user has access to (i.e. permission to "get"). For instan...
Permissions
Former_Member's avatar
Former_Member
Ideator I
8 years ago
I guess it's possible to do something like: 
SELECT P1.*
 FROM [InnovatorSample].[innovator].[PART] AS P1
 WHERE GENERATION = (
 SELECT MAX(GENERATION) FROM [InnovatorSample].[innovator].[PART] AS P2
 WHERE PERMISSION_ID IN ('95475AE006E7415794BDC93808DC04D2', 'A43FE707C3C54C90AD660D27A81AC58D') AND P1.CONFIG_ID = P2.CONFIG_ID)
 ORDER BY P1.NAME