[SOLVED] VIP User Database Field
Moderator: crythias
-
flippertom
- Znuny advanced
- Posts: 120
- Joined: 16 Apr 2015, 08:42
- Znuny Version: 3.2.16
[SOLVED] VIP User Database Field
Where does OTRS store the VIP user status. In which database table->column?
Last edited by flippertom on 24 Aug 2015, 06:27, edited 2 times in total.
Re: VIP User Database Field
Hi,
OTRS does not have a VIP User Database in standard tables.
Flo
OTRS does not have a VIP User Database in standard tables.
Flo
OTRS 2025 SILVER (Prod)
OTRS 2025 auf Debian 12 (Test)
Znuny 7.x latest version testing auf Debian 12
-- Ich beantworte keine Forums-Fragen PN - No PN please
I won't answer to unfriendly users any more. A greeting and regards are just polite.
OTRS 2025 auf Debian 12 (Test)
Znuny 7.x latest version testing auf Debian 12
-- Ich beantworte keine Forums-Fragen PN - No PN please
I won't answer to unfriendly users any more. A greeting and regards are just polite.
-
flippertom
- Znuny advanced
- Posts: 120
- Joined: 16 Apr 2015, 08:42
- Znuny Version: 3.2.16
Re: VIP User Database Field
I'm not able to find some fields displayed on the edit customer page in the database.(for e.g. VIP User field)
Does it mean that OTRS does not store these values in the database, but displayed directly from LDAP?
Does it mean that OTRS does not store these values in the database, but displayed directly from LDAP?
-
crythias
- Moderator
- Posts: 10170
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: VIP User Database Field
VIP is not a concept in stock OTRS. Screenshots?
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
-
flippertom
- Znuny advanced
- Posts: 120
- Joined: 16 Apr 2015, 08:42
- Znuny Version: 3.2.16
Re: VIP User Database Field
It is just a plaintext field that holds the value -True or false.
It turns out that the field is not stored in the database anywhere and it populated directly from the LDAP.
However, it is not clear how this functionality is handled.
It turns out that the field is not stored in the database anywhere and it populated directly from the LDAP.
However, it is not clear how this functionality is handled.
You do not have the required permissions to view the files attached to this post.
-
reneeb
- Znuny guru
- Posts: 5018
- Joined: 13 Mar 2011, 09:54
- Znuny Version: 6.0.x
- Real Name: Renée Bäcker
- Company: Perl-Services.de
- Contact:
Re: VIP User Database Field
Have a look at the Mapping in the Kernel/Config.pm
Perl / Znuny development: http://perl-services.de
Free Znuny add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de
Free Znuny add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de
-
flippertom
- Znuny advanced
- Posts: 120
- Joined: 16 Apr 2015, 08:42
- Znuny Version: 3.2.16
Re: VIP User Database Field
Saw the mapping in the config.pm
But how does it get displayed on the front end?
But how does it get displayed on the front end?
-
crythias
- Moderator
- Posts: 10170
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: VIP User Database Field
flippertom wrote:Where does OTRS store the VIP user status. In which database table->column?
Given this, what comprises the ability to answer this topic's question?flippertom wrote:It turns out that the field is not stored in the database anywhere and it populated directly from the LDAP.
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
-
flippertom
- Znuny advanced
- Posts: 120
- Joined: 16 Apr 2015, 08:42
- Znuny Version: 3.2.16
Re: VIP User Database Field
Didn't get you...can you rephrase the question please?crythias wrote:flippertom wrote:Where does OTRS store the VIP user status. In which database table->column?Given this, what comprises the ability to answer this topic's question?flippertom wrote:It turns out that the field is not stored in the database anywhere and it populated directly from the LDAP.
-
crythias
- Moderator
- Posts: 10170
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: VIP User Database Field
You answered your own question related to the topic of this thread. (ie, Where does VIP store? It doesn't. it's sourced from LDAP.)
Then you asked how does it get displayed on the front end?
If it's in the map, it displays, unless it doesn't display and you're trying to find out why it doesn't and then we're not understanding the bigger question:
What are you trying to accomplish with the answers you're getting from this thread?
Then you asked how does it get displayed on the front end?
If it's in the map, it displays, unless it doesn't display and you're trying to find out why it doesn't and then we're not understanding the bigger question:
What are you trying to accomplish with the answers you're getting from this thread?
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
-
flippertom
- Znuny advanced
- Posts: 120
- Joined: 16 Apr 2015, 08:42
- Znuny Version: 3.2.16
Re: VIP User Database Field
Ah..ok!That is what you meant!
What I wish to understand is if it does not store the value in the database and directly displays it from the LDAP, how is this functionality achieved?
There must be a code somewhere to display this on the front end, right?
That would just complete the understanding of this functionality.
But you are right, my primary question has been answered and I'll leave the complete understanding for some other day.
What I wish to understand is if it does not store the value in the database and directly displays it from the LDAP, how is this functionality achieved?
There must be a code somewhere to display this on the front end, right?
That would just complete the understanding of this functionality.
But you are right, my primary question has been answered and I'll leave the complete understanding for some other day.