0

Querying owner__v in VQL

Hi,

I'm going back to the question I asked previously here:

https://support.veeva.com/hc/en-us/community/posts/360015286513-Make-owner-v-a-queryable-property

Is there still no way of retrieving the value of owner__v in VQL? If not, is there any workaround (like some custom, queryable property that would maintain a copy of the owner__v value)?

This limitation is now causing serious concerns for us.

Thanks!

Raph

 

2 comments

  • Avatar
    Igor Tsives Official comment

    Hello Raphael,

    Ability to use VQL to query for roles is on our roadmap and being considered for one of our future releases. Currently, the only way to fetch roles is by calling individual Roles API (https://developer.veevavault.com/api/19.1/#retrieve-roles). 

    Thank you,

    Igor Tsives

  • Avatar
    Raphael Goubet

    Just to add some clarification to justify the need: I appreciate that the information can be obtained in the API using the /objects/documents endpoint. However, the point of using VQL is to standardize information retrieval from a single endpoint and for any number of document. With VQL, a single endpoint needs to be set up to retrieve documents, objects, workflows, users, etc., and multiple records can be obtained in one query. With the API, a different endpoint must be set up for each, and an API call must be made of each record, which is very inefficient in the context of information retrieval.

Please sign in to leave a comment.