nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Issue with Global Variable

ghaniik

I have an issue while getting global variable.
 
I have two datasets, dataset1 and dataset2.
 
dataset1 is associated to table1, dataset2 is associated to table2. 
table2 is inside table1 in UI.
I am setting the global variable in dataset2 fetch method and trying to display it on table1.
but I am not getting any value in UI after running the report.
I have attached sample layout for reference.
 
did anyone faced this issue earlier.
 
Thanks

Find more posts tagged with

Comments

Matthew L.

I believe I know whats happening, assuming you are using the following commands to Set/Get the global variable:
<pre class="_prettyXprint _lang-js">
reportContext.setPersistentGlobalVariable("MyGlobalVar", "MyStringValue"); //Set global variable called MyGlobalVar
var value = reportContext.getPersistentGlobalVariable("MyGlobalVar"); //Get global variable called MyGlobalVar
</pre>
If you move the "Global variable" element from the last column and place it under "Table1" element in the first column, does it display a value?
If so, then its an order of operations issue (I've seen tables built by the report engine from right to left).
This can be fixed by changing the method used to set the "Global variable" element's (example: onRender).
If it doesn't show a value after moving it, try placing the element after the entire table to verify that it's getting a value.
 
If you have a sample report to post, I could take a look for you.

ghaniik

<div>Hi Matthew,</div>
<div> </div>
<div>Thanks a lot for your response on my issue. As you have suggested I have added the field under table1 column but it didnt work, however it worked when I placed the column outside table1. I have also tried onrender,afterFactor,onPageEnd method, but didnt had much luck. I am attaching the report for your reference. Request you to take a look.</div>
<div> </div>
<div>Once again thanks for the response. </div>

Matthew L.

Looking at the report design, I see that Maximo is being used.
I have very little knowledge of Maximo, however from my current understanding of Maximo, the report is generated one element at a time from top to bottom and tables/grids are generated right to left.
Because of how it generates reports, I believe this is the reason that onRender,afterFactory,onPageEnd methods didn't have an effect.
 
In your example, how many rows does the main table generate (1 row, 3 rows, etc)?
How many rows does each little table generate (1 row per main table row, 3 rows per main table row, etc)?
If the main table generates more than 1 row, does the second row "Days [Data]" show a value (perhaps the value from the first row)?
 
Also, what is the final output that you are wanting to accomplish?
Do you have a mock-up with fake data and what the output of the fake data should look like?
 
Attached is my modified version of your design that I think replicates the behavior you are seeing, but from within the designer instead of Maximo.

ghaniik

Main Table values are based on the query so depends on input criteria(date range is the criteria).
table 2 generates values based on the Main Table, i.e. for each value of Main table, table 2 generates data, this also may vary based on the data.
 
I am attaching the mock up with highlighted columns.
I want to add the columns A1 through A5 and display it in A6.
A2 value is from table 2(Highlighted in Maroon), while all other values are from Main table.
 
 
Thanks,

ghaniik

Hi,
 
I tried setting Excel Emitter user properties, it is not working, is there any other work around for this?
 
Thanks,