queryWorkItems() with custom field

[scottyseus]

Hi all,

I have not been able to figure out how to use the queryWorkItems() method with a custom field.

Here is what I have for the method so far:

Code: Select all

private String[] fields = {"workRecords", "project"};
WorkItem[] items;
items = trackerService.queryWorkItems("project.id:sandbox AND workRecords.user.id:" + user.getId(), "project", fields);

This works fine. However, we have a custom field with ID 'billing_code' that I am trying to query for, but this does not work:

Code: Select all

private String[] fields = {"workRecords", "project", "billing_code"};

and the variations that I have tried do not work either. Does anyone know how to do this?

also, the billing_code custom field is only available in the 'sandbox' project, which I specify in the query.

Thanks,
Scott

[scottyseus]

So I have fixed this particular issue.

instead of

Code: Select all

private String[] fields = {"workRecords", "project", "billing_code"};

I used

Code: Select all

private String[] fields = {"workRecords", "project", "customFields"};

However, the method WorkItem.getCustomFields() keeps returning null despite the fact that I know I have populated work items with our custom fields.

Any tips?

[NickEntin]

Hi,

first of all, please be more specific - I guess you're speaking about WebServices access to Polarion.

For this case, I think what you're looking for is
trackerService.getCustomField(workitemURI, customFieldID)

and

trackerService.getCustomFieldKeys(workitemURI)

Best regards,
Nick

[mosaad]

This is how you could get the query to return custom fields in a workitem add to the fields list

Code: Select all

private String[] fields = {"workRecords", "project", "customFields.idoftheCustomFieldYouNeed"};