2
.. i18n: .. module:: chricar_view_id
3
.. i18n: :synopsis: ChriCar unique View ID
8
.. module:: chricar_view_id
9
:synopsis: ChriCar unique View ID
13
.. i18n: .. raw:: html
16
.. i18n: <link rel="stylesheet" href="../_static/hide_objects_in_sidebar.css" type="text/css" />
22
<link rel="stylesheet" href="../_static/hide_objects_in_sidebar.css" type="text/css" />
24
.. i18n: .. tip:: This module is part of the OpenERP software, the leading Open Source
25
.. i18n: enterprise management system. If you want to discover OpenERP, check our
26
.. i18n: `screencasts <http://openerp.tv>`_ or download
27
.. i18n: `OpenERP <http://openerp.com>`_ directly.
30
.. tip:: This module is part of the OpenERP software, the leading Open Source
31
enterprise management system. If you want to discover OpenERP, check our
32
`screencasts <http://openerp.tv>`_ or download
33
`OpenERP <http://openerp.com>`_ directly.
35
.. i18n: .. raw:: html
37
.. i18n: <div class="js-kit-rating" title="" permalink="" standalone="yes" path="/chricar_view_id"></div>
38
.. i18n: <script src="http://js-kit.com/ratings.js"></script>
43
<div class="js-kit-rating" title="" permalink="" standalone="yes" path="/chricar_view_id"></div>
44
<script src="http://js-kit.com/ratings.js"></script>
46
.. i18n: ChriCar unique View ID (*chricar_view_id*)
47
.. i18n: ==========================================
48
.. i18n: :Module: chricar_view_id
49
.. i18n: :Name: ChriCar unique View ID
50
.. i18n: :Version: 5.0.0.2
51
.. i18n: :Author: Network Gulf IT - India
52
.. i18n: :Directory: chricar_view_id
53
.. i18n: :Web: http://www.chricar.at/ChriCar/index.html
54
.. i18n: :Official module: no
55
.. i18n: :Quality certified: no
58
ChriCar unique View ID (*chricar_view_id*)
59
==========================================
60
:Module: chricar_view_id
61
:Name: ChriCar unique View ID
63
:Author: Network Gulf IT - India
64
:Directory: chricar_view_id
65
:Web: http://www.chricar.at/ChriCar/index.html
67
:Quality certified: no
78
.. i18n: This module is funded by
79
.. i18n: ChriCar Beteiligungs- und Beratungs- GmbH
80
.. i18n: http://www.chricar.at/ChriCar/index.html
83
.. i18n: Network Gulf IT - India
84
.. i18n: http://www.networkgulf.com/
86
.. i18n: usage: get_id('your_view_name',param1,param2,param3,param4)
87
.. i18n: this function will always return the SAME unique id for a
88
.. i18n: certain combination of parameters for a view.
90
.. i18n: Hint 1: you do not need this function if the unique id can easily be
91
.. i18n: calculated during the grouping. Example
92
.. i18n: - easy: group by product_id
93
.. i18n: - more complex: group by account_id, period_id
94
.. i18n: - very complex: group by account_id, period_id, currency_id
96
.. i18n: Hint 2: for large tables (100000 rec)
97
.. i18n: performance gain of factor 10x and more
98
.. i18n: split the grouping operation and the get_id into 2 views
101
.. i18n: select get_id(tablename,param1,param2,...), param1, param2, ... sum(field1), ...
103
.. i18n: group by get_id(tablename,param1,param2,...) ,param1,param2,...
109
.. i18n: group by param1,param2,...
111
.. i18n: select get_id('view1',param1,param2,...),* from view1;
112
.. i18n: (no group by here)
117
This module is funded by
118
ChriCar Beteiligungs- und Beratungs- GmbH
119
http://www.chricar.at/ChriCar/index.html
122
Network Gulf IT - India
123
http://www.networkgulf.com/
125
usage: get_id('your_view_name',param1,param2,param3,param4)
126
this function will always return the SAME unique id for a
127
certain combination of parameters for a view.
129
Hint 1: you do not need this function if the unique id can easily be
130
calculated during the grouping. Example
131
- easy: group by product_id
132
- more complex: group by account_id, period_id
133
- very complex: group by account_id, period_id, currency_id
135
Hint 2: for large tables (100000 rec)
136
performance gain of factor 10x and more
137
split the grouping operation and the get_id into 2 views
140
select get_id(tablename,param1,param2,...), param1, param2, ... sum(field1), ...
142
group by get_id(tablename,param1,param2,...) ,param1,param2,...
148
group by param1,param2,...
150
select get_id('view1',param1,param2,...),* from view1;
153
.. i18n: Download links
154
.. i18n: --------------
160
.. i18n: You can download this module as a zip file in the following version:
163
You can download this module as a zip file in the following version:
165
.. i18n: (No download links available)
168
(No download links available)
170
.. i18n: Dependencies
171
.. i18n: ------------
177
.. i18n: * :mod:`base`
225
.. i18n: Object: chricar_view_id (chricar_view_id)
226
.. i18n: #########################################
229
Object: chricar_view_id (chricar_view_id)
230
#########################################
232
.. i18n: :name: Name, char