How to querry revision number of Work Item

[ncont]

Hey pylero team,

I would like to query the actual revision number of a work item. I am able to get it for a linked work item.

The idea is: I would like to check a linked work items, which is fixed by revision, if there is a newer revision.
Example:

• Item ABC-123
• Item ABC-234

Item ABC-123 is linked in Item ABC-234 with revision 10. Now Item ABC-123 is updated and has revision 15.
Goal of my script is: Detect missmatch between linked revision and the actual one.

Or in Code:
Have this attribute: revision

for [ Attributes]

pylero/src/pylero/work_item.py

Line 61 in a43658f

Attributes:

)

Does anyone have an idea to query this value?

[leelavg]

hi @ncont

• I'm not an avid user of polarion however by your description maybe you are looking for linked_revisions on a work_item?
  

  pylero/src/pylero/work_item.py

  Lines 76 to 77 in a43658f

  	linked_revisions (ArrayOfRevision)
  	linked_revisions_derived (ArrayOfRevision)

[dkal-synertec]

Piggybacking off this question does anyone know how to get the latest revision of a document?

[leelavg]

- In my sample project I don't have any linked revisions
- Maybe if you have a testcase with linked revisions, you can try invoking linked_revisions on testacase object
- You can see from above that'll be a list, so need to invoke dir/var on the items to see the attrs on on linked_revisions object

• Oh, you meant document, need to check.

[leelavg]

• If it's possible via UI, maybe you can create a query using

  pylero/src/pylero/document.py

  Lines 239 to 242 in a43658f

  	@classmethod
  	def query(cls, query, is_sql=False, fields=["document_id"],
  	sort="document_id", limit=-1, baseline_revision=None,
  	query_uris=False):

  on a document object

[ncont]

Thanks for the reply. i am actually not searching for the linked_revision but for the revision of a workitem. This can be different.

Inside Polarion, i can get the revision of a workitem with getRevision()

-> https://almdemo.polarion.com/polarion/sdk/doc/javadoc/com/polarion/platform/persistence/model/IPObject.html#getRevision()

Or with the UI, i go to a work item and then to the history of a workitem. For each change, there is a date and a revision.

The question: How can i get the latest revision of a work item.

Hope that helps and thank you for you replay!

[dkal-synertec]

• If it's possible via UI, maybe you can create a query using

  pylero/src/pylero/document.py

  Lines 239 to 242 in a43658f

  	@classmethod
  	def query(cls, query, is_sql=False, fields=["document_id"],
  	sort="document_id", limit=-1, baseline_revision=None,
  	query_uris=False):

  
  on a document object

Unfortunately, I wasn't able to do this using the query but I wrote a webscraper that pulls that information from the UI based on the document id. It's a bit slow but it works for my purposes. Thanks anyways for your help with this @leelavg