on 12-08-2009 9:38 PM
Hi all,
Suppose I've a following scenario:
Show in a page, a list of materials and in this same page to show a line with informations based on agregated functions (Count, Average and other calculations).
Initially I thought in declare a OutputMaterialsXML parameter that contains the material list and others OutputConsolidationXML parameters that contains the average, count based on material list, so using XPath I can populate all output on once.
If I want to use XAcuteQuery I need to decide what the output I will show, so I will need to create tow XAcuteQuery, but it will impact on performance, because I'll need to execute the same transaction two times.
Does anybody has a good approach to this case?
Best regards
If your Material list document is not excessively long it probably wouldn't be too much overhead to add a few extra columns using the CalculatedColumn action block. These extra columns, even though the number would be the same for all rows could contain a column for each of your aggregated functions.
Then in your iGrid just set the Column Width for these addtional fields to zero and upon UpdateEvent of the grid you could javascript them from Row number 1 to your desired html elements, etc.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You could try having one transaction do the calculations and put the data in a Queue or Queues and have the second just read from the Queue/s
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
9 | |
7 | |
3 | |
2 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.