v 6.1 v 7.0 v 8.0 Third Party 387
Download for v 8.0
Technical Name chricar_view_id
LicenseAGPL-3
Websitehttp://www.chricar.at/ChriCar/index.html
Also available in version v 6.1 v 7.0
You bought this module and need support? Click here!

This module is funded by

ChriCar Beteiligungs- und Beratungs- GmbH
http://www.chricar.at/ChriCar/index.html

Developed by

Network Gulf IT - India
http://www.networkgulf.com/

usage: get_id('your_view_name',param1,param2,param3,param4)

This function will always return the SAME unique id for a certain combination of parameters for a view.

Hint 1: you do not need this function if the unique id can easily be calculated during the grouping. Example:

  • easy: group by product_id
  • more complex: group by account_id, period_id
  • very complex: group by account_id, period_id, currency_id

Hint 2: for large tables (100000 rec) performance gain of factor 10x and more split the grouping operation and the get_id into 2 views

slow:

select get_id(tablename,param1,param2,...), param1, param2, ... sum(field1), ...
from
group by get_id(tablename,param1,param2,...) ,param1,param2,...

fast:

  1. view1:
select ....
from
group by param1,param2,...
  1. view2:
select get_id('view1',param1,param2,...),* from view1;
(no group by here)

Please log in to comment on this module

  • The author can leave a single reply to each comment.
  • This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
  • If you want to start a discussion with the author, please use the developer contact information. They can usually be found in the description.
Please choose a rating from 1 to 5 for this module.