dynamic field empty in search result

Moderator: crythias

Post Reply
xtheb
Znuny newbie
Posts: 20
Joined: 16 Jan 2015, 12:17
Znuny Version: 4.0.3

dynamic field empty in search result

Post by xtheb »

hello,

in sysconfig (Ticket -> Frontend::Agent::Ticket::ViewSearch) I have added my dynamic field (Price) in :
Ticket::Frontend::AgentTicketSearch###SearchCSVData
Ticket::Frontend::AgentTicketSearch###DynamicField
Ticket::Frontend::AgentTicketSearch###SearchCSVDynamicField
Ticket::Frontend::AgentTicketSearch###DefaultColumns

And in the search results the column appears but it is empty (see screenshot).

But if I export the result in Excel, I see the correct values in the Price column !!

any idea ?

thank you
You do not have the required permissions to view the files attached to this post.
RStraub
Znuny guru
Posts: 2210
Joined: 13 Mar 2014, 09:16
Znuny Version: 6.0.14
Real Name: Rolf Straub

Re: dynamic field empty in search result

Post by RStraub »

SysConfig entries ending in "#DynamicField" require you to NOT prepend DFs with "DynamicField_".

SearchCSVData, DefaultColumns etc. DO require you to prepend DFs with "DynamicField_".

Please make sure that Ticket::Frontend::AgentTicketSearch###DynamicField only holds the names and nothing else.
Currently using: OTRS 6.0.14 -- MariaDB -- Ubuntu 16 LTS
xtheb
Znuny newbie
Posts: 20
Joined: 16 Jan 2015, 12:17
Znuny Version: 4.0.3

Re: dynamic field empty in search result

Post by xtheb »

thank you !
gerald2545
Znuny newbie
Posts: 22
Joined: 19 Jul 2019, 16:31
Znuny Version: 6.0.14
Real Name: Gerald
Company: INRA

Re: dynamic field empty in search result

Post by gerald2545 »

...does not work for me..
I can see the correct value in the tcket, but noting is exported in csv....
a configuration I forgot to modify?
OTRS : 6.0.29, with FAQ extension, on centOS7
Agent auth against local database (postgresql 9)
gerald2545
Znuny newbie
Posts: 22
Joined: 19 Jul 2019, 16:31
Znuny Version: 6.0.14
Real Name: Gerald
Company: INRA

Re: dynamic field empty in search result

Post by gerald2545 »

I created a dynamic field named SitesGeT for ticket objects, it is a dropdown. The users select a value in the ticket for this DF.
I would like to export the tickets along with the values of this DF

In Ticket::Frontend::AgentTicketSearch###SearchCSVData, I added DynamicField_SitesGeT
In Ticket::Frontend::AgentTicketSearch###SearchCSVDynamicField I added DynamicField_SitesGeT and enabled it
In Ticket::Frontend::AgentTicketSearch###DynamicField I added SitesGeT and enabled it


When I run a search and export the results (in CSV or Excel), the column DynamicFiled_SitesGeT is present but no values fot it

Are there other sysconfig to modify?

Thank you

Gérald
OTRS : 6.0.29, with FAQ extension, on centOS7
Agent auth against local database (postgresql 9)
zzz
Znuny superhero
Posts: 889
Joined: 15 Dec 2016, 15:13
Znuny Version: All
Real Name: Emin
Company: Efflux GmbH
Contact:

Re: dynamic field empty in search result

Post by zzz »

Hello Gérald,

Try to change "DynamicField_SitesGeT" to "SitesGeT" in Ticket::Frontend::AgentTicketSearch###SearchCSVDynamicField

— Emin
Professional OTRS, Znuny & OTOBO services: efflux.de | efflux.de/en/

Free and premium add-ons: German | English
Post Reply