Hi,
Then for sure you need ColumnMap definition. Search for ColumnMap
files in share/html/Elements, open any and examine. It's pretty
straightforward how to modify these files, however code you need at
the end can be complex. Start from a basic experiments of adding new
column and using it in sear
i don't want the entirety of the time worked...only time worked based on
the month. IE Time worked this month 30mins, time worked last month 255
minutes. Hence the "Transactions.Created between
DATE_FORMAT(NOW(),"%Y-%m-01") - interval 0 month and
DATE_FORMAT(NOW(),"%Y-%m-01") - interval -1 mo
If everything works as expected then ticket's time worked field should hold
correct sum. This value you can display in search results without custom
code.
Regards, Ruslan. From phone.
08.08.2011 22:39 пользователь "Scott Benson"
написал:
> Thanks for the reply Gerard. Not sure what ColumnMap is,
Thanks for the reply Gerard. Not sure what ColumnMap is, but basically
what we're looking to do is only list tickets in a "custom search" that
have had time worked, within a certain time frame. Also showing the
Sum(Transactions.TimeWorked) as a field.
This can be accomplished via Mysql becau
I am not sure but you might be looking for ColumnMap
Gerard
On 2011-08-05 17:43, Scott Benson wrote:
No update on this?
--
Scott Benson
A1 Networks
(707)570-2021 x203
On 8/2/11 2:13 PM, Scott Benson wrote:
Is it possible to get custom information inside the "Query Builder"?
We are trying to
No update on this?
--
Scott Benson
A1 Networks
(707)570-2021 x203
On 8/2/11 2:13 PM, Scott Benson wrote:
Is it possible to get custom information inside the "Query Builder"?
We are trying to get "time worked" based on transactions between a
time frame to show in a custom search. Basically w
Is it possible to get custom information inside the "Query Builder"? We
are trying to get "time worked" based on transactions between a time
frame to show in a custom search. Basically we want to have a page for
clients to log in with their user/pass and see a page that shows,
tickets with t
