Using dynamicfield as restriction in statistics

Moderator: crythias

Locked
ecoop3r
Znuny newbie
Posts: 3
Joined: 15 May 2013, 23:20
Znuny Version: 3.3.x

Using dynamicfield as restriction in statistics

Post by ecoop3r »

I've created a dynamic field called TicketCloseDate. I've mapped it out to all the areas I want it to.

When I create a new statistic for TIcketList I would like to print out that field and a few others and use it as a restriction for a date range.

I've looked through all the options and searched for hours and have had no luck getting it to show up.

I can see other dynamic fields in the restrictions step for creating statistics. All of them are either textbox or multiselect. I cannot figure out how they are showing up.

Any advice on how to do this? Thank you.
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Using dynamicfield as restriction in statistics

Post by crythias »

make sure the field is added in sysconfig for stats?
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
ecoop3r
Znuny newbie
Posts: 3
Joined: 15 May 2013, 23:20
Znuny Version: 3.3.x

Re: Using dynamicfield as restriction in statistics

Post by ecoop3r »

crythias wrote:make sure the field is added in sysconfig for stats?
Can you elaborate? I've been through every sysconfig group and I haven't seen anything for fields for anything stats related.
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Using dynamicfield as restriction in statistics

Post by crythias »

ecoop3r wrote:I can see other dynamic fields in the restrictions step for creating statistics. All of them are either textbox or multiselect. I cannot figure out how they are showing up.
Make sure the new dynamic field is a ticket field and not an article field
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
ecoop3r
Znuny newbie
Posts: 3
Joined: 15 May 2013, 23:20
Znuny Version: 3.3.x

Re: Using dynamicfield as restriction in statistics

Post by ecoop3r »

It is for tickets. There just aren't any DateTime Dynamic fields in the restriction section for stats. I reviewed the code and it builds a restrictions list and checks some ACLs. I did a Dump on the hash object that it iterates to see what was in it. My dynamic field is in it from the start but gets filtered out and I cannot for the life of me figure out where or why.
Locked