XQUERY missing fields?

Posted 4 days ago by Ben Perry

B
Ben Perry
Un Answered

0 Votes

Howdy,


I'm starting to look at using the SI.XQUERY function, but struggling to get the fields that I can access via SI.QUERY.


In this particular case I'm looking at the PROJECT object which is now "projects/project" according to the XML-to-REST object map.


Comparing the output of SI.OBJECTIONDEFINITION to SI.XOBJECTDEFINITION there is a massive discrepancy in the number of fields:


SI.OBJECTIONDEFINITION = 139 fields

SI.XOBJECTDEFINITION = 35 fields.


I was hoping to query various dimension values eg Department, Division/Class, Location, but none of those fields are available?


Looking at the REST API I can see /objects/projects/project/<key> has most of the missing fields.


How can I access these via Velixo?


Thanks

Ben


0 Votes


1 Comments

B

Ben Perry posted 3 days ago

Can't edit my post, but meant to say SI.OBJECTDEFINITION not SI.OBJECTIONDEFINITION.

0 Votes

Login or Sign up to post a comment