Add a dynamic field in the search result (CSV)

[girishmungra]

How can I add a dynamic field in the search result (CSV) for an Agent Ticket Search?

In sysconfig i went there:
Ticket -> Frontend::Agent::Ticket::ViewSearch
Ticket::Frontend::AgentTicketSearch###SearchCSVData
and added

DynamicField_field12 in the list.

didn't work..
thanks for help

[crythias]

look a little lower on the page.

The appropriate code (Kernel/Modules/AgentTicketSearch.pm) :

Code: Select all

                    # include the selected dynamic fields on CVS resutls
                    DYNAMICFIELD:
                    for my $DynamicFieldConfig ( @{ $Self->{CSVDynamicField} } ) {
                        next DYNAMICFIELD if !IsHashRefWithData($DynamicFieldConfig);
                        next DYNAMICFIELD if !$DynamicFieldConfig->{Name};
                        next DYNAMICFIELD if $DynamicFieldConfig->{Name} eq '';

                        push @CSVHead, 'DynamicField_' . $DynamicFieldConfig->{Name};
                    }
                }

That seems interesting ... there must be a CSVDynamicField config...
Sure enough, it's the last entry on the page.

[girishmungra]

hi

from the code i deduce that field I should add in the config should start with 'DynamicField_ '. And this exactly what I did at first but doesn't work

Code: Select all

 my @Data;
                for (@CSVHead) {

                    # check if header is a dynamic field and get the value from dynamic field
                    # backend
                    if ( $_ =~ m{\A DynamicField_ ( [a-zA-Z\d]+ ) \z}xms ) {

                        # loop over the dynamic fields configured for CSV output
                        DYNAMICFIELD:
                        for my $DynamicFieldConfig ( @{ $Self->{CSVDynamicField} } ) {
                            next DYNAMICFIELD if !IsHashRefWithData($DynamicFieldConfig);
                            next DYNAMICFIELD if !$DynamicFieldConfig->{Name};

                            # skip all fields that does not match with current field name ($1)
                            # with out the 'DynamicField_' prefix
                            next DYNAMICFIELD if $DynamicFieldConfig->{Name} ne $1;

                            # get the value as for print (to corretly display)
                            my $ValueStrg = $Self->{BackendObject}->DisplayValueRender(
                                DynamicFieldConfig => $DynamicFieldConfig,
                                Value              => $Info{$_},
                                HTMLOutput         => 0,
                                LayoutObject       => $Self->{LayoutObject},
                            );

[crythias]

from the code i deduce that field I should add in the config should start with 'DynamicField_ '

How did you deduce that? The code push @CSVHead, 'DynamicField_' . $DynamicFieldConfig->{Name}; adds DynamicField_ to the entries in the CSV section at the bottom of the Config page.

[girishmungra]

Looks like I still haven't seen how to add my dynamic field in Ticket::Frontend::AgentTicketSearch###SearchCSVData

[crythias]

Click the (+).
Type your field name in key. (This should be the name without DynamicField_)
add 1 to "content"

this will make it export.

To search on it, do the same thing for
Ticket::Frontend::AgentTicketSearch###DynamicField

[girishmungra]

But there is no 'content' column in Ticket::Frontend::AgentTicketSearch###SearchCSVData
Its just a list of data to export in CSV format.
I tried without the DynamicFiled_ but doesn't work.

[crythias]

Ticket - FrontendAgentTicketViewSearch - SysConfig - Admin - OTRS - Googl_2012-09-06_08-08-50.png

What do you see on your screen?

[girishmungra]

I am a plum! didn't notice that config.
Many thanks - was able to export my dynamic fields

[serwert]

Hi,
I have similar problem but only with non-text type dynamic fields.
In csv I always get the empty columny (for e.g. drop down list).
Do you know some resolution for this problem?
Thanks for help!
Best regards