Skip to content

UPDATE TRACKING and UPDATE VIEWSTAT optional clauses are not parsed #25

@ABenassi87

Description

@ABenassi87
  • Feature
  • Bug Request

Description

Example from: https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_select_update_tracking.htm

Query:

SELECT Title FROM FAQ__kav
WHERE Keyword='Apex' and
Language = 'en_US' and
KnowledgeArticleVersion = 'ka230000000PCiy'
UPDATE TRACKING

Parsed output:

{
    "fields": [
        {
            "text": "Title"
        }
    ],
    "subqueries": [],
    "sObject": "FAQ__kav",
    "whereClause": {
        "left": {
            "field": "Keyword",
            "operator": "=",
            "value": "'Apex'"
        },
        "operator": "AND",
        "right": {
            "left": {
                "field": "Language",
                "operator": "=",
                "value": "'en_US'"
            },
            "operator": "AND",
            "right": {
                "left": {
                    "field": "KnowledgeArticleVersion",
                    "operator": "=",
                    "value": "'ka230000000PCiy'"
                }
            }
        }
    }
}

Query 2:

SELECT Title FROM FAQ__kav
   WHERE PublishStatus='online' and
   Language = 'en_US' and
   KnowledgeArticleVersion = 'ka230000000PCiy'
   UPDATE VIEWSTAT

Parsed result:

{
    "fields": [
        {
            "text": "Title"
        }
    ],
    "subqueries": [],
    "sObject": "FAQ__kav",
    "whereClause": {
        "left": {
            "field": "PublishStatus",
            "operator": "=",
            "value": "'online'"
        },
        "operator": "AND",
        "right": {
            "left": {
                "field": "Language",
                "operator": "=",
                "value": "'en_US'"
            },
            "operator": "AND",
            "right": {
                "left": {
                    "field": "KnowledgeArticleVersion",
                    "operator": "=",
                    "value": "'ka230000000PCiy'"
                }
            }
        }
    }
}

The UPDATE TRACKING and UPDATE VIEWSTAT clauses are not parsed.

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions