2. PHPRunner General questions
  3. lookuptable; total type TOTAL
This topic is locked

lookuptable; total type TOTAL

 		8/12/2006 8:18:49 AM
PHPRunner General questions
S
 specpa author

Hi,
when using lookup tables the first column from the lookup is used,

when a calculation is done,
example.
Ive created a lookup table with lookup values of hours (from 0.25 to 24.0),

I want to use this lookup table to fill in the hours I've worked on a project.

when using the supplied "fields order and totals" and using the totals

type :TOTAL", not the total of the hours is taken for counting but the

total of the index value belonging to the lookup table of hours.
(A similar thing happens when referencing to a lookup value filled in

in a table,

and reference this value in another table. Then also the value from

first culumn in the lookup table is used and not the referenced lookup

value column).
how to get this working?
best regards
paul speckens

specpA
Alexey admin 8/14/2006

Paul,
some functions - totals, searching etc work with original field values, not those selected from lookup table.

To make your totals working properly modify SQL query for your table on Edit SQL query tab in PHPRunner and add joined fields from the lookup table there.

Here is the article describing this:

http://www.xlinesoft.com/phprunner/docs/us...sql_queries.htm
Then count totals for joined field, not for the field in original table.

Also you'll need to modify GetFullFieldName function as described in the article.
S
 		specpa author 10/24/2009



Paul,
some functions - totals, searching etc work with original field values, not those selected from lookup table.

To make your totals working properly modify SQL query for your table on Edit SQL query tab in PHPRunner and add joined fields from the lookup table there.

Here is the article describing this:

http://www.xlinesoft.com/phprunner/docs/us...sql_queries.htm
Then count totals for joined field, not for the field in original table.

Also you'll need to modify GetFullFieldName function as described in the article.



the correct link is

http://www.xlinesoft.com/articles/search_sort_lookup_values.htm