Extra Comma in SoQL

  • Resolved jesodoth

    (@jesodoth)


    4 years, 10 months ago

    I’ve created a field map for the Content Version object in Salesforce. I successfully created this map before, but on recreating it now, the query (below, from debug logs) keeps failing due to an extra comma being inserted before “FROM”, almost like it was expecting another field. Strangely, whether the field map includes just the Id field or fields additional to those in the query, it’s always running the query below. It’s almost like it’s cached, though I have tried clearing the cache multiple times. Any ideas on troubleshooting this?

    SELECT Id, Certificate__c, File_Type__c, Section__c, Year__c, Public_URL__c, FROM ContentVersion WHERE > 2020-01-10T03:05:02Z AND LastModifiedDate > 2020-01-10T03:05:02Z AND SystemModstamp > 2020-01-10T03:05:02Z ORDER BY ASC LIMIT 350 OFFSET 1050

Viewing 1 replies (of 1 total)
  • Plugin Author Jonathan Stegall

    (@jonathanstegall)

    I’m not sure, honestly. It does indeed seem like it’s expecting another field. But it does seem like if you’ve changed the query, it should be logging a different query.

    Some things I can think of to try:

    1. Go to the plugin’s Scheduling tab and clear the queues.
    2. Change the schedule frequency, just in case it’s not clearing like it should be.
    3. Back up your fieldmap settings and delete the fieldmap, then recreate it.

    See if any of those things change the query that is being logged. If it does, it seems like the query is being stored when it should be being cleared, although I’m not sure why that would be happening.

Viewing 1 replies (of 1 total)
  • The topic ‘Extra Comma in SoQL’ is closed to new replies.