Trouble with returning things created after a certain date

Here is the whole thing I'm sending to the API client: (Is it because I'm using the ResourceLink typename?)

$Fields = array(

                                'Resource.UserName',

                                'WorkItem.Name' ,

                                'WorkItem.CreatedOn',

                                'WorkItem.C_WorkStatus');

                

                $Paging = NULL;

                

                

                $createdOn = "2014-04-01";

                        $LeftDate = array (

                    "FieldName" => "CreatedOn");

            $RightDate = array (

                    "Value" => new SoapVar ($createdOn, XSD_DATETIME, "dateTime", "http://www.w3.org/2001/XMLSchema"));

            $DateCondition = array (

                    "LeftExpression" => new SoapVar ($LeftDate,SOAP_ENC_OBJECT, "FieldExpression", "http://clarizen.com/api/queries"),

                    "Operator" => "GreaterThanOrEqual",

                    "RightExpression" => new SoapVar ($RightDate,SOAP_ENC_OBJECT, "ConstantExpression","http://clarizen.com/api/queries"));

        $Where = new SoapVar ($DateCondition,SOAP_ENC_OBJECT, "Compare", "http://clarizen.com/api/queries");    

        

        $clarizenReturn = $clarizenAPI->getList('RegularResourceLink', $Fields , $Paging, $Where);

Hi Jeff.

To start with, you may note the condition refers to the CreatedOn of the RegularResourceLink (the resource link creation time) while the result field is WorkItem.CreatedOn (the work item creation time).

Obviously resource link's creation time can be later than the work item's, so you'll need to change the condition to refer to the work item's creation time, or add the resource link's creation time to the result.

Hope this helps,

Ophir

I get it, but I don't know how to make the condition refer to the WorkItem.CreatedOn instead of theResourceLinks's  CreatedOn.How do I do that? I think I tried WorkItem.CreatedOn and it yelled at me. :)

Jeff

Hi Jeff,

Please check out this post:

https://success.clarizen.com/entries/38249296-Query-ResourceLinks-for-All-WorkItems-of-type-Task

I think the scenario is very similar.

Hope this helps.

Ophir

Ophir,

Thanks to your help, I'm much closer. Now, I have two sets of conditions and I'd like to return items if the first set is true OR the second set is true. I'm having trouble figuring out how to nest the conditions. Basically, the conditions are:

set1(100 days ago > StartDate > today AND PlannedRevenue > 0)

OR 

set1(100 days ago > DueDate > today AND PlannedRevenue > 0)

$AndCondition = array (

"Conditions" => array ( new SoapVar ($Expression, SOAP_ENC_OBJECT, "Compare", "http://clarizen.com/api/queries" ),

new SoapVar ($Expression2,SOAP_ENC_OBJECT, "Compare", "http://clarizen.com/api/queries"),

new SoapVar ($Expression5,SOAP_ENC_OBJECT, "Compare", "http://clarizen.com/api/queries")

));

$AndCondition2 = array (

"Conditions" => array ( new SoapVar ($Expression3, SOAP_ENC_OBJECT, "Compare", "http://clarizen.com/api/queries" ),

new SoapVar ($Expression4, SOAP_ENC_OBJECT, "Compare", "http://clarizen.com/api/queries"),

new SoapVar ($Expression5, SOAP_ENC_OBJECT, "Compare", "http://clarizen.com/api/queries")

));

What I need is to return if AndCondition OR AndCondition2. Help!

Thanks!

Jeff

This is how I tried to construct the rest of hte query:

$OrCondition = array ( "Conditions" => array (

      new SoapVar ($AndCondition, SOAP_ENC_OBJECT, "And", "http://clarizen.com/api/queries"),

      new SoapVar ($AndCondition2, SOAP_ENC_OBJECT, "And", "http://clarizen.com/api/queries")));

$Where = new SoapVar ($OrCondition, SOAP_ENC_OBJECT, "Or", "http://clarizen.com/api/queries");

$clarizenReturn = $clarizenAPI->getList('GroupProjectLink', $Fields , $Paging, $Where);

Hi Jeff.

Just looking at your code, it seems to be the right way. Did it work or you had issues with it?

If you did, please send the full code and the error if any.

Hope this helps,

Ophir