URGENT HELP req for a count
i need a way to count the number of related records, but set to a certain value
my situation is:
i have projects, each has related jobs, i need to count the number of jobs complete, and jobs pending payment
thus i need something like
count(jobs::status="complete") and count(jobs::status="pending payment")
is there any way that you can count through this requirement or do i need to create multiple portals?
thanks heaps, any ideas would help as this is mega urgent