hello to all, im new in Mii and i have a sql statement to populate the table but i want to know if it is possible to create a grid like the image in this link :
- build a BLT that creates a XML output with three columns (Label, Quantity produced, Scrap)
- fill the rows with your values
- define a xacute query which calls your BLT
- define an iGrid in your web page that calls the xacute query
- try to set the column name of the leftmost column heading to space
If you want to fill the spaces in an html table using JavaScript, you may also call the xacute without a display template (to make it unvisible) and pick up the values from the query using the applet functions like getCellValue().
See also [iGrid component methods|http://help.sap.com/saphelp_xmii120/helpdata/en/44/d1e7a599f3409fe10000000a11466f/content.htm]
thanks all for your answers but just a little thing: the shift gonna be a parameter but i want to calculate at the same time the max yield and max scrap of all the 3 shifts...what i have to put in the transaction for the shift number passes of 1 to 2 and then 2 to 3...i know that i have to increment in somewhere...
If the data is from the Tag query(i.e TAGS Data), you can easily calculate the MAX,AVG,MIN etc from Statatics mode available there. But for sql query this option is not avaialble. But i SQL query itself you can achive this by using the MAX function. For example SELECT MAX(salary) as "Highest salary" FROM employees.
You can use For repeater action block for the shift increament if you have mutiple row data by configuring from 1 to 3. And in row expression use like this: "Shift"&ForNextRepeater_0.CurrentItem. If you have three rows of data then use repeater: "Shift"&Repeater_0.CurrentItem. Otherwise use Assignment action block, create Local property Shift and increament this shift property after each shift completion like this: Local.shift+1.
thanks a lot for the help...this is a way but i already solved, i build an sql instruction that makes solve this problem...im gonna test the two ways and then decide
Yes ,absoultely right you have got my points correctly. For getting the total quantity you have to do like this:
Create a local property with name Tot_Qty.Use a assignment block below the row action block, and assign this local property with the expression: Local.Tot_Qty+Repeater_0.Output{/Row/MAX_YIELDQTY_}. Map ths Local.Tot_Qty to the Total row's columns. And for Scrap is also same.
You can use Switch action blocks to get the data of the Shift1,2 and 3. You can configure with 2 inputs. Pass the Local.shift as input value.For MatchValue1 pass Shift1 and MatchValue2 pass shift2 and default will be Shift3.
hello, thanks for your efort to explain me this things...now my transaction is working but only calculates for shift 1...the shift it is a parameter of SQL Query.
i have one question : you said to me to create a local variable(shift)..ok...and then use the Switch action block..but where i going to put his action block, i think that is before the repeater...is right??...
another question is how to calculate total of all the Shifts for Quantity Produced and Scrap..i dont understand of another times
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.