How to pull grid data into a eazybi report

Question

Hi,

Query1:

I tried the code suggested earlier for a grid data to be imported in  eazy bi report.

[jira.customfield_tbl_site]
name = "Tbl site"
dimension = true
data_type = "string"
multiple_values = true
split_by = ","
javascript_code = '''
getDocument("/rest/idalko-igrid/1.0/grid/11490/issue/" + issue.id, {ignoreErrors: [404,400]},
function(result){
resultArray = [];
if (result && result.values) {
    result.values.forEach(function(valuesItem){ 
resultArray.push(
valuesItem.isite
);
   })
}

issue.fields.customfield_tbl_site = resultArray.toString();
});
'''

But this is not working. Please let me know what changes need to be made.

I have placed a screenshot of the way isite is defined.

Query2:

For grid column with data type as interger/number i m not able to import the column even though i mention measure as true:

One such code is below:

[jira.customfield_DAO]
name = "Tbl DAO"
data_type = "integer"
measure = true
multiple_values = true
split_by = ","
javascript_code = '''
getDocument("/rest/idalko-igrid/1.0/grid/11075/issue/" + issue.id, {ignoreErrors: [404,400,406]},
function(result){
resultArray = [];
if (result && result.values) {
    result.values.forEach(function(valuesItem){ 
resultArray.push(
valuesItem.idao
);
   })
}

});
'''

Please let me know how i can changes this code to make it work.

Thanks in advance

Devashree

devashree ma · Answer

Hi Gerda,

Query1:

I tried the code suggested earlier for a grid data to be imported in  eazy bi report.

[jira.customfield_tbl_site]
name = "Tbl site"
dimension = true
data_type = "string"
multiple_values = true
split_by = ","
javascript_code = '''
getDocument("/rest/idalko-igrid/1.0/grid/11490/issue/" + issue.id, {ignoreErrors: [404,400]},
function(result){
resultArray = [];
if (result && result.values) {
    result.values.forEach(function(valuesItem){ 
resultArray.push(
valuesItem.isite
);
   })
}

issue.fields.customfield_tbl_site = resultArray.toString();
});
'''

In this , the configuration for this grid data in jira shows that site is of type list.

col.isite=Site
col.isite.type=list
col.isite.query=SELECT DISTINCT GOQFactory as isite, GOQFactoryID as id FROM qim.RLOBGOQFactory WHERE GOQFactory IS NOT NULL AND IsActive = 1 AND IsDeleted = 0
col.isite.query.ds = C*****DB
#col.isite.required = true
#col.isite.required=true
col.isite.width=150

How do i change to code if the type is list?

Gerda Grantiņa _ eazyBI · Answer

Hi @devashree ma ,

Can you confirm that after adding this JavaScript in eazyBI advanced settings you have selected this field in data import?

If that is done and there are still problems, it would be better if you could please send a reference to this conversation and additional questions to support@eazybi.com (best together with PrintScreen and JS codes) as this is not the integration that eazyBI supports by default and some more information is needed.

best,
Gerda

devashree ma · Answer

Hi Gerda,

I tried removing ,

multiple_values = true
split_by = ","

but still , i m not able to get the data in the report.

And what is the syntax for returning the result.

Thanks,

Devashree