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; } } }

one script in beforeFactory need to be restricted for sorting the table columns

Maroju

Hi,
 
<div> </div>
<div>I have a code in 'beforeFactory' to shuffle the table columns in the order which user gives as parameter, which should execute only when first time table is rendered. Next time i.e., while sorting this code execution need to be stopped. I tried by declaring one global boolean variable in initialize and making it true inside the column shuffling code. But it didnt worked. I guess after clicking sort, report is getting reloaded. Will anybody help me in restricting this code for sorting table.</div>
<div> </div>
<div>Thanks in advance.</div>
<div> </div>
<div>Maroju</div>

Find more posts tagged with

Comments

jfranken

I'm not sure what the issue is, but here are a couple of suggestions:
 
Make sure you are using setPersistentGlobalVariable and getPersistentGlobalVariable (include the "Persistent" part)
Also, sometimes checking boolean values can be trickier than it seems: 
 
<a data-ipb='nomediaparse' href='https://javascriptweblog.wordpress.com/2011/02/07/truth-equality-and-javascript/'>https://javascriptweblog.wordpress.com/2011/02/07/truth-equality-and-javascript/</a>
 
Regards,
Jeff

Maroju

Hi Jeff,
 
Thanks for reply. I want to make one variable 'true' on click of sort on the report table column. How to capture the sort event on the report. I am not using group sorting. I am using the default sort provided by the birt.
 
Regards,
Maroju

Maroju

Hi Jeff,
 
Will you please help me in putting one string vale in application context scope and how to retrieve it in beforeFactory. I used persistence global variable but didn't worked.

Maroju

Hi Jeff, 
 
Please find mentioned url . Please explain me how i can do the "Setting application context objects from script is also possible". How is it possible. Can you please provide me script to do this.
 
"<a data-ipb='nomediaparse' href='http://developer.actuate.com/community/forum/index.php?/topic/38916-one-script-in-beforefactory-need-to-be-restricted-for-sorting-the-table-columns/#entry142427'>http://developer.actuate.com/community/forum/index.php?/topic/38916-one-script-in-beforefactory-need-to-be-restricted-for-sorting-the-table-columns/#entry142427"</a>

Maroju

"Setting application context objects from script is also possible" is mentioned in the document but setting value to the AppContext was given in java. Can anyone please explain me how to set attribute to appContext from script.

Clement Wong

You want to perform a check before you run a report, but you don't know where to set a flag that would not be reset after a run?
 
If you're using the BIRT Engine, then you can set session variables in your BIRT report design. For example, if you added this to your beforeFactory:
 
reportContext.getHttpServletRequest().getSession().setAttribute("sorted", "true");
 
 
You can access this session variable in your JSPs, and from your report, you can retrieve the value:
 
reportContext.getHttpServletRequest().getSession().getAttribute("sorted");

Maroju

Hi Clement,
 
 Thank you for the reply. 
 
<div>1) Whatever you told is correct. But if i will be able to set "reportContext.getHttpServletRequest().getSession().setAttribute("sorted", "true");"</div>
<div>on click of Sorting then only i will be able to achieve this. Please let me know the way to set this onClick of sorting. I didn't find any event such as onClick of sorting in designer. Is it possible through script anywhere? </div>
<div> </div>
<div>2) I need one more help. I have below code in beforeFactory</div>
<div> </div>
<div>var col = reportContext.getDesignHandle().getElementByID("1873");</div>
<div>col.setProperty("allowExport","true");</div>
<div> </div>
<div>id: 1873 represents column in a table. I would like to set property "allowExport = true" on column i.e., I would like to dynamically export the column through script. I wrote above script but it is giving error. Will you please help me in setting this property.</div>

Clement Wong

1. You would have to provide more information. It is not clear how you design your report and in what context you have defined Sorting. Maybe you can provide a sample design?
 
2. Report Items (such as Tables, Labels, Images, etc...) have the property allowExport. A column of a table does not.

Maroju

Hi Clement, 
 
Thank you for replying. 
 
I am attaching the sample report based on Classic Model database. In this report i have a report parameter in which user will give which table columns he want to see. So dynamically i need to show the user selected columns and some default columns. If i run the report first time all the columns i.e., user selected columns and default columns are coming properly. I have not written any sorting logic. I am using default sorting. But i wrote script in beforeFactory to shuffle the columns of the table and to show them on the screen. the code is as below 
 
if(tH!=null){ 
 
for(i = 0; i < columns.length; i++){ 
logToDebugWindow(columns.length); 
var r = columns.length - i - 1 ; 
var index = r; 
logToDebugWindow(columns[index]); 
var position = getColumnIndexFor(tH, columns[index]); 
var src = position + 1; 
var dest = index + 1; 
logToDebugWindow(src + " for " + columns[index] + " to position " + dest ); 
//logToDebugWindow(tH.canShiftColumn(src, dest)); 
if (tH.canShiftColumn(src, dest) == true) { 
tH.shiftColumn(src,dest); 
} 
} 
} 
 
If i click sort, first column is getting replaced with the first column of the table. Default columns to show on the screen in the attached sample report are CUSTOMERNAME,CONTACTLASTNAME and CONTACTFIRSTNAME. For example if i give two column names in the report parameter as CITY and STATE, and if i run the report resulted report table is coming with "CUSTOMERNAME,CONTACTLASTNAME ,CONTACTFIRSTNAME,CITY and STATE ". After this, if i click sorting on any of the columns then the first column i.e., CUSTOMERNAME is getting replaced with CUSTOMERNUMBER which is the first column of the default table in the report. When i am continuously sorting, CUSTOMERNUMBER column is getting shifted one place forward and after two times or three times i am unable to sort. 
 
This is all happening because of the above mentioned shuffling code. I need this shuffling logic to be executed when first time report loads. I want to restrict execution of this logic when sorting is clicked. Please help me to achieve this.

Maroju

Hi Clement,
 
 Thank you and sorry for the trouble. The issue is with "var dest = index + 1;" this part of the above code. If i give simply index without increment, column shifting has stopped. But one issue is i am unable to see sorting symbols i.e., up arrow key or down arrow key after sorting two or three times. Will you please check the rpt attached in the previous comment and let me know. 
 
Thanks in advance.

Clement Wong

I was able to replicate your issue after updating the line "var dest = index + 1;" to "var dest = index;" I'm not sure why the icons disappear from the top of the column. The right click menu option for IV options still work (Header, Group, Column, Aggregation, Filter, Sort, Alignment, Format, Export Content). You should log a Support ticket to see if they can provide further assistance.
 
TIP Since you are using commercial BIRT, instead of outputting debug statements to a new window, you can use the following code snippet that outputs directly out to Eclipse's Error Log in the lower right pane. Only 1 line of code for setup and you won't get multiple windows.
<pre class="_prettyXprint">
logger = java.util.logging.Logger.getLogger("birt.report.logger");
logger.warning ("Your message here.");</pre>

Maroju

Hi Clement,
 
 Thanks for the reply. I will log the Support ticket for icon invisible issue and also thanks for the code for error logging.