Convert this SQL code to adwords PHP

[ken...@blvnp.com]

    // Create selector.
    $selector = new Selector();
    $selector->setFields(['CampaignId', 'AdGroupId', 'Id', 'Criteria',
        'CriteriaType', 'Impressions', 'Clicks', 'Cost']);

    // Use a predicate to filter out paused criteria (this is optional).
    $selector->setPredicates([
        new Predicate('Status', PredicateOperator::NOT_IN, ['PAUSED'])]);

The PHP code above produces the SQL code below.

SELECT CampaignId, AdGroupId, Id, Criteria, CriteriaType, QualityScore
FROM CRITERIA_PERFORMANCE_REPORT
WHERE Status IN [ENABLED, PAUSED] and HasQualityScore='TRUE'

Here is the real question. What if I change the "and" to "or".

[Peter Oliquino]

Hi Ken,

As seen in this section of our AWQL guide, the OR condition is currently not supported in the AWQL used by the AdWords API in its reports and services. You will need to create a separate request for the records you wish to be included supposedly in the OR condition.

Best regards,

Peter

AdWords API Team

[ken...@blvnp.com]

Like for example how? 

 

Like this?

$selector->setPredicates([

        new Predicate('Status', PredicateOperator::NOT_IN, ['PAUSED']),

        new Predicate('Status', PredicateOperator::NOT_IN, ['PAUSED']),

[Peter Oliquino]

Hi Ken,

My recommendation would be that you provide a completely different query and use it on a separate request in order to mimic the query and the results that would be retrieved from your supposed OR condition.

Best regards,

Peter Laurence N. Oliquino

AdWords API Team