Marketcircle    Forums  Hop To Forum Categories  Billings  Hop To Forums  Creating Estimates and Invoices    Expenses for Project
Go
New
Find
Notify
Tools
Reply
  
-star Rating Rate It!  Login/Join 
Apprentice
Posted
I am trying to create a report that shows the expense slips of a specific project. A bit like the existing one in TimeSlip>Expenses. I would use it to track my own expenses (for the tax declaration). I put my own expenses as slips into one project called EXPENSES in the "me" client (with the star).
I suppose it's just the matter of adding another "qualifyer" in the script that retrieves the slips for the table
Thanks for your help.
 
Posts: 9 | Registered: February 07, 2008Reply With QuoteEdit or Delete MessageReport This Post
Apprentice
Posted Hide Post
ok found out how:

start := userInput valueForKey:'startDate'.
end := userInput valueForKey:'endDate'.

start := start dateAsBeginningOfDay.
end := end dateAsEndOfDay.


qual1 := BDQualifier qualifierWhereValueOfKey:'type.typeCode' isEqualTo:104.
qual2 := BDKeyValueQualifier keyValueQualifierWithKey:'endDateTime' operatorSelector:#isGreaterThan: value:start.
qual3 := BDKeyValueQualifier keyValueQualifierWithKey:'endDateTime' operatorSelector:#isLessThan: value:end.
qual4 := BDQualifier qualifierWhereValueOfKey:'project.name' isEqualTo:'EXPENSES'.

qualifiers := {qual1, qual2, qual3, qual4}.

andQual := (((BDAndQualifier alloc) initWithQualifierArray:qualifiers) autorelease).

objectContext objectsForEntityNamed:'TimeSlip' matchingQualifier:andQual.
 
Posts: 9 | Registered: February 07, 2008Reply With QuoteEdit or Delete MessageReport This Post
 Previous Topic | Next Topic powered by eve community  
 

Marketcircle    Forums  Hop To Forum Categories  Billings  Hop To Forums  Creating Estimates and Invoices    Expenses for Project

© Copyright 2006 Marketcircle Inc. All rights reserved.