Search found 19 matches

by mgeltser
Wed Jan 09, 2013 2:08 pm
Forum: Webservices API
Topic: query for timecards and times
Replies: 1
Views: 4285

query for timecards and times

Can i query timecard and reference timecardTime in the where clause, and if i can how do i reference it
for example:
query.where = "status = 'Approved' and timecardTime.payRate = 1234"
by mgeltser
Tue Aug 28, 2012 10:35 am
Forum: Webservices API
Topic: searching contacts by secondary owner
Replies: 1
Views: 3707

searching contacts by secondary owner

How can i query contacts by secondary owner? I tried this: dtoQuery.where = "secondaryOwners.id = 123" But get this error: -99999: org.hibernate.QueryException: illegal attempt to dereference collection [{synthetic-alias}{non-qualified-property-ref}secondaryOwners] with element property reference [i...
by mgeltser
Wed Aug 22, 2012 2:43 pm
Forum: Webservices API
Topic: searching JobOrder query error
Replies: 3
Views: 5382

Re: searching JobOrder query error

The query i am trying now is this:
isDeleted = 0 and employmentType in ('HR', 'LT', 'SME') and status in ('Lost-Potential Order', 'Lost-Order') and Len(reasonClosed) < 4

Below is the error message
-99999: org.hibernate.exception.GenericJDBCException: could not execute query
by mgeltser
Wed Aug 15, 2012 5:18 pm
Forum: Webservices API
Topic: searching JobOrder query error
Replies: 3
Views: 5382

searching JobOrder query error

The following where clause:
status in ('Lost-Potential Order', 'Lost-Order') and reasonClosed = 'N/A'
is failling while searching for JobOrder entity.

Can you please tell me what is wrong with it?

Thanks,
Mike