Welcome to the Axosoft Community, Sign in | Register | Help
in Search

Filter report for custom field

Last post 05-20-2008, 7:51 AM by Dan Suceava. 1 replies.
Sort Posts: Previous Next
  •  05-14-2008, 5:59 PM 15765

    Filter report for custom field

    Hello,

    We've created a Boolean field called "Billable" for features and I would like to write a report that only shows work log hours against billable tasks.

    Can someone point me in the right direction for putting filter criteria into a shortcut?

    Cheers!



    Daniel Green
    Explorer Technologies
    Support Powered by OnTime 2008
  •  05-20-2008, 7:51 AM 15789 in reply to 15765

    Re: Filter report for custom field

    You will probably need to create an 'Other' report and write your own stored procedure to return the data you need.  The features reports don't have the worklog data, and the worklog reports don't have the feature custom fields, so you cannot use those report types.

    If you write your own stored procedure you should be able to filter by that custom field.  So you will need to join the Features table with the FeatureCustomFields table and the WorkLog table


    Dan Suceava
    http://www.axosoft.com
View as RSS news feed in XML

© 2002 - 2007, Axosoft, LLC. All Rights Reserved. | Privacy
Bug Tracking | Defect Tracking Videos | Help Desk Software