Another Strange inconsistent (it seems) result.

So I do a query with this URI and body

GET /sugarcrm2/rest/v11_4/Schedulers

{"filter": [{"created_by": {"$equals": "1"}}], "fields": "id,created_by", "max_num": 1000}

And get the following record in amongst others

{"id":"c97bd87e-3f8c-11eb-be7f-080027566605","date_modified":"2020-12-16T10:52:12+00:00","created_by":"1","locked_fields":[],"_acl":{"fields":{}},"_module":"Schedulers"}

That all looks fine. If I then do

GET /sugarcrm2/rest/v11_4/Schedulers

{"filter": [{"created_by": {"$equals": "1"}}], "max_num": 1000}

The record for the previous id now contains only

{"id":"c97bd87e-3f8c-11eb-be7f-080027566605","date_modified":"2020-12-16T10:52:12+00:00","_module":"Schedulers"}

This is against a local instance, so we can provide database backups or whatever else is needed to create the problem.

  • Hi Nick, 

    Against a 10.3 instance with the admin user, I could not reproduce this behavior. 

    Can you specify the version that you are using and if the user is admin? 

  • It was admin, yes. How do I find the version?

  • Thanks

    SugarCRM Version 10.0.2 (Build 182 E) (Q2 2020)

  • Hi Nick, 

    On my tests against a stock 10.0.2 PRO, I get the expected response with all the fields. 


    Is the Scheduler id='c97bd87e-3f8c-11eb-be7f-080027566605' custom?
    Do you have access to a stock instance to confirm if it happens there as well? 

    response.json
    {"next_offset":-1,"records":[{"id":"a7483692-6c48-11eb-8027-0242ac120004","name":"Elasticsearch Queue Scheduler","date_entered":"2021-02-11T09:05:02+00:00","date_modified":"2021-02-11T09:05:02+00:00","modified_user_id":"1","modified_by_name":"Andre Serrazina","modified_user_link":{"full_name":"Andre Serrazina","id":"1","_acl":{"fields":{"pwd_last_changed":{"write":"no","create":"no"},"last_login":{"write":"no","create":"no"}},"_hash":"6d408abe1708e7afd72eaecf780699c2"}},"created_by":"1","created_by_name":"Andre Serrazina","created_by_link":{"full_name":"Andre Serrazina","id":"1","_acl":{"fields":{"pwd_last_changed":{"write":"no","create":"no"},"last_login":{"write":"no","create":"no"}},"_hash":"6d408abe1708e7afd72eaecf780699c2"}},"description":"","deleted":false,"job":"class::\\Sugarcrm\\Sugarcrm\\Elasticsearch\\Queue\\Scheduler","job_url":"","job_function":"","date_time_start":"2001-01-01T00:00:01+00:00","date_time_end":"2037-12-31T23:59:59+00:00","job_interval":"*\/1::*::*::*::*","adv_interval":"","time_from":"","time_to":"","last_run":"2021-02-11T10:08:41+00:00","status":"Active","catch_up":false,"system_job":false,"following":false,"my_favorite":false,"_acl":{"fields":{}},"_module":"Schedulers"},{"id":"450a6dba-6c48-11eb-ba21-0242ac120004","date_modified":"2021-02-11T09:05:02+00:00","_module":"Schedulers"},{"id":"450961b8-6c48-11eb-b44b-0242ac120004","name":"Activity Stream Purger","date_entered":"2021-02-11T09:05:02+00:00","date_modified":"2021-02-11T09:05:02+00:00","modified_user_id":"1","modified_by_name":"Andre Serrazina","modified_user_link":{"full_name":"Andre Serrazina","id":"1","_acl":{"fields":{"pwd_last_changed":{"write":"no","create":"no"},"last_login":{"write":"no","create":"no"}},"_hash":"6d408abe1708e7afd72eaecf780699c2"}},"created_by":"1","created_by_name":"Andre Serrazina","created_by_link":{"full_name":"Andre Serrazina","id":"1","_acl":{"fields":{"pwd_last_changed":{"write":"no","create":"no"},"last_login":{"write":"no","create":"no"}},"_hash":"6d408abe1708e7afd72eaecf780699c2"}},"description":"","deleted":false,"job":"class::SugarJobActivityStreamPurger","job_url":"","job_function":"","date_time_start":"2019-04-01T08:45:01+00:00","date_time_end":"2030-12-31T23:59:59+00:00","job_interval":"0::*\/1::*::*::*","adv_interval":"","time_from":"","time_to":"","last_run":"","status":"Inactive","catch_up":true,"system_job":false,"following":false,"my_favorite":false,"_acl":{"fields":{}},"_module":"Schedulers"},{"id":"4506ac5c-6c48-11eb-875d-0242ac120004","name":"Rebuild Denormalized Team Security Data","date_entered":"2021-02-11T09:05:02+00:00","date_modified":"2021-02-11T09:05:02+00:00","modified_user_id":"1","modified_by_name":"Andre Serrazina","modified_user_link":{"full_name":"Andre Serrazina","id":"1","_acl":{"fields":{"pwd_last_changed":{"write":"no","create":"no"},"last_login":{"write":"no","create":"no"}},"_hash":"6d408abe1708e7afd72eaecf780699c2"}},"created_by":"1","created_by_name":"Andre Serrazina","created_by_link":{"full_name":"Andre Serrazina","id":"1","_acl":{"fields":{"pwd_last_changed":{"write":"no","create":"no"},"last_login":{"write":"no","create":"no"}},"_hash":"6d408abe1708e7afd72eaecf780699c2"}},"description":"","deleted":false,"job":"class::Sugarcrm\\Sugarcrm\\Denormalization\\TeamSecurity\\Job\\RebuildJob","job_url":"","job_function":"","date_time_start":"2005-01-01T14:45:01+00:00","date_time_end":"2030-12-31T23:59:59+00:00","job_interval":"*\/15::*::*::*::*","adv_interval":"","time_from":"","time_to":"","last_run":"","status":"Inactive","catch_up":false,"system_job":false,"following":false,"my_favorite":false,"_acl":{"fields":{}},"_module":"Schedulers"},{"id":"4505d6ba-6c48-11eb-b7ca-0242ac120004","name":"Publish approved articles \u0026 Expired KB Articles.","date_entered":"2021-02-11T09:05:02+00:00","date_modified":"2021-02-11T09:05:02+00:00","modified_user_id":"1","modified_by_name":"Andre Serrazina","modified_user_link":{"full_name":"Andre Serrazina","id":"1","_acl":{"fields":{"pwd_last_changed":{"write":"no","create":"no"},"last_login":{"write":"no","create":"no"}},"_hash":"6d408abe1708e7afd72eaecf780699c2"}},"created_by":"1","created_by_name":"Andre Serrazina","created_by_link":{"full_name":"Andre Serrazina","id":"1","_acl":{"fields":{"pwd_last_changed":{"write":"no","create":"no"},"last_login":{"write":"no","create":"no"}},"_hash":"6d408abe1708e7afd72eaecf780699c2"}},"description":"","deleted":false,"job":"class::SugarJobKBContentUpdateArticles","job_url":"","job_function":"","date_time_start":"2005-01-01T11:15:01+00:00","date_time_end":"2030-12-31T23:59:59+00:00","job_interval":"0::5::*::*::*","adv_interval":"","time_from":"","time_to":"","last_run":"2021-02-11T09:05:35+00:00","status":"Active","catch_up":true,"system_job":false,"following":false,"my_favorite":false,"_acl":{"fields":{}},"_module":"Schedulers"},{"id":"4504c748-6c48-11eb-b016-0242ac120004","name":"Remove temporary PDF files","date_entered":"2021-02-11T09:05:02+00:00","date_modified":"2021-02-11T09:05:02+00:00","modified_user_id":"1","modified_by_name":"Andre Serrazina","modified_user_link":{"full_name":"Andre Serrazina","id":"1","_acl":{"fields":{"pwd_last_changed":{"write":"no","create":"no"},"last_login":{"write":"no","create":"no"}},"_hash":"6d408abe1708e7afd72eaecf780699c2"}},"created_by":"1","created_by_name":"Andre Serrazina","created_by_link":{"full_name":"Andre Serrazina","id":"1","_acl":{"fields":{"pwd_last_changed":{"write":"no","create":"no"},"last_login":{"write":"no","create":"no"}},"_hash":"6d408abe1708e7afd72eaecf780699c2"}},"description":"","deleted":false,"job":"class::SugarJobRemovePdfFiles","job_url":"","job_function":"","date_time_start":"2005-01-01T07:45:01+00:00","date_time_end":"2030-12-31T23:59:59+00:00","job_interval":"0::4::*::*::*","adv_interval":"","time_from":"","time_to":"","last_run":"2021-02-11T09:05:35+00:00","status":"Active","catch_up":true,"system_job":false,"following":false,"my_favorite":false,"_acl":{"fields":{}},"_module":"Schedulers"},{"id":"4503c0e6-6c48-11eb-a5c6-0242ac120004","name":"Remove diagnostic tool files","date_entered":"2021-02-11T09:05:02+00:00","date_modified":"2021-02-11T09:05:02+00:00","modified_user_id":"1","modified_by_name":"Andre Serrazina","modified_user_link":{"full_name":"Andre Serrazina","id":"1","_acl":{"fields":{"pwd_last_changed":{"write":"no","create":"no"},"last_login":{"write":"no","create":"no"}},"_hash":"6d408abe1708e7afd72eaecf780699c2"}},"created_by":"1","created_by_name":"Andre Serrazina","created_by_link":{"full_name":"Andre Serrazina","id":"1","_acl":{"fields":{"pwd_last_changed":{"write":"no","create":"no"},"last_login":{"write":"no","create":"no"}},"_hash":"6d408abe1708e7afd72eaecf780699c2"}},"description":"","deleted":false,"job":"class::SugarJobRemoveDiagnosticFiles","job_url":"","job_function":"","date_time_start":"2005-01-01T09:15:01+00:00","date_time_end":"2030-12-31T23:59:59+00:00","job_interval":"0::4::*::*::0","adv_interval":"","time_from":"","time_to":"","last_run":"","status":"Active","catch_up":true,"system_job":false,"following":false,"my_favorite":false,"_acl":{"fields":{}},"_module":"Schedulers"},{"id":"45030912-6c48-11eb-913c-0242ac120004","name":"Remove temporary files","date_entered":"2021-02-11T09:05:02+00:00","date_modified":"2021-02-11T09:05:02+00:00","modified_user_id":"1","modified_by_name":"Andre Serrazina","modified_user_link":{"full_name":"Andre Serrazina","id":"1","_acl":{"fields":{"pwd_last_changed":{"write":"no","create":"no"},"last_login":{"write":"no","create":"no"}},"_hash":"6d408abe1708e7afd72eaecf780699c2"}},"created_by":"1","created_by_name":"Andre Serrazina","created_by_link":{"full_name":"Andre Serrazina","id":"1","_acl":{"fields":{"pwd_last_changed":{"write":"no","create":"no"},"last_login":{"write":"no","create":"no"}},"_hash":"6d408abe1708e7afd72eaecf780699c2"}},"description":"","deleted":false,"job":"class::SugarJobRemoveTmpFiles","job_url":"","job_function":"","date_time_start":"2005-01-01T14:30:01+00:00","date_time_end":"2030-12-31T23:59:59+00:00","job_interval":"0::4::*::*::*","adv_interval":"","time_from":"","time_to":"","last_run":"2021-02-11T09:05:35+00:00","status":"Active","catch_up":true,"system_job":false,"following":false,"my_favorite":false,"_acl":{"fields":{}},"_module":"Schedulers"},{"id":"450237f8-6c48-11eb-b4cd-0242ac120004","name":"Sugar Heartbeat","date_entered":"2021-02-11T09:05:02+00:00","date_modified":"2021-02-11T09:05:02+00:00","modified_user_id":"1","modified_by_name":"Andre Serrazina","modified_user_link":{"full_name":"Andre Serrazina","id":"1","_acl":{"fields":{"pwd_last_changed":{"write":"no","create":"no"},"last_login":{"write":"no","create":"no"}},"_hash":"6d408abe1708e7afd72eaecf780699c2"}},"created_by":"1","created_by_name":"Andre Serrazina","created_by_link":{"full_name":"Andre Serrazina","id":"1","_acl":{"fields":{"pwd_last_changed":{"write":"no","create":"no"},"last_login":{"write":"no","create":"no"}},"_hash":"6d408abe1708e7afd72eaecf780699c2"}},"description":"","deleted":false,"job":"class::SugarJobHeartbeat","job_url":"","job_function":"","date_time_start":"2005-01-01T15:30:01+00:00","date_time_end":"2030-12-31T23:59:59+00:00","job_interval":"0::4::*::*::*","adv_interval":"","time_from":"","time_to":"","last_run":"","status":"Active","catch_up":false,"system_job":false,"following":false,"my_favorite":false,"_acl":{"fields":{}},"_module":"Schedulers"},{"id":"45012eee-6c48-11eb-8a18-0242ac120004","name":"Prune Old Record Lists","date_entered":"2021-02-11T09:05:02+00:00","date_modified":"2021-02-11T09:05:02+00:00","modified_user_id":"1","modified_by_name":"Andre Serrazina","modified_user_link":{"full_name":"Andre Serrazina","id":"1","_acl":{"fields":{"pwd_last_changed":{"write":"no","create":"no"},"last_login":{"write":"no","create":"no"}},"_hash":"6d408abe1708e7afd72eaecf780699c2"}},"created_by":"1","created_by_name":"Andre Serrazina","created_by_link":{"full_name":"Andre Serrazina","id":"1","_acl":{"fields":{"pwd_last_changed":{"write":"no","create":"no"},"last_login":{"write":"no","create":"no"}},"_hash":"6d408abe1708e7afd72eaecf780699c2"}},"description":"","deleted":false,"job":"function::cleanOldRecordLists","job_url":"","job_function":"","date_time_start":"2005-01-01T06:15:01+00:00","date_time_end":"2020-12-31T23:59:59+00:00","job_interval":"*::*::*::*::*","adv_interval":"","time_from":"","time_to":"","last_run":"2021-02-11T09:05:35+00:00","status":"Active","catch_up":true,"system_job":false,"following":false,"my_favorite":false,"_acl":{"fields":{}},"_module":"Schedulers"},{"id":"4500753a-6c48-11eb-b806-0242ac120004","name":"Create Future TimePeriods","date_entered":"2021-02-11T09:05:02+00:00","date_modified":"2021-02-11T09:05:02+00:00","modified_user_id":"1","modified_by_name":"Andre Serrazina","modified_user_link":{"full_name":"Andre Serrazina","id":"1","_acl":{"fields":{"pwd_last_changed":{"write":"no","create":"no"},"last_login":{"write":"no","create":"no"}},"_hash":"6d408abe1708e7afd72eaecf780699c2"}},"created_by":"1","created_by_name":"Andre Serrazina","created_by_link":{"full_name":"Andre Serrazina","id":"1","_acl":{"fields":{"pwd_last_changed":{"write":"no","create":"no"},"last_login":{"write":"no","create":"no"}},"_hash":"6d408abe1708e7afd72eaecf780699c2"}},"description":"","deleted":false,"job":"class::SugarJobCreateNextTimePeriod","job_url":"","job_function":"","date_time_start":"2012-01-01T14:45:01+00:00","date_time_end":"2030-12-31T23:59:59+00:00","job_interval":"0::23::*::*::*","adv_interval":"","time_from":"","time_to":"","last_run":"","status":"Active","catch_up":false,"system_job":false,"following":false,"my_favorite":false,"_acl":{"fields":{}},"_module":"Schedulers"},{"id":"44ff6b9a-6c48-11eb-a6e2-0242ac120004","name":"Clean Jobs Queue","date_entered":"2021-02-11T09:05:02+00:00","date_modified":"2021-02-11T09:05:02+00:00","modified_user_id":"1","modified_by_name":"Andre Serrazina","modified_user_link":{"full_name":"Andre Serrazina","id":"1","_acl":{"fields":{"pwd_last_changed":{"write":"no","create":"no"},"last_login":{"write":"no","create":"no"}},"_hash":"6d408abe1708e7afd72eaecf780699c2"}},"created_by":"1","created_by_name":"Andre Serrazina","created_by_link":{"full_name":"Andre Serrazina","id":"1","_acl":{"fields":{"pwd_last_changed":{"write":"no","create":"no"},"last_login":{"write":"no","create":"no"}},"_hash":"6d408abe1708e7afd72eaecf780699c2"}},"description":"","deleted":false,"job":"function::cleanJobQueue","job_url":"","job_function":"","date_time_start":"2012-01-01T07:45:01+00:00","date_time_end":"2030-12-31T23:59:59+00:00","job_interval":"0::5::*::*::*","adv_interval":"","time_from":"","time_to":"","last_run":"","status":"Active","catch_up":false,"system_job":false,"following":false,"my_favorite":false,"_acl":{"fields":{}},"_module":"Schedulers"},{"id":"44fe7a0a-6c48-11eb-8fc0-0242ac120004","name":"Run Email Reminder Notifications","date_entered":"2021-02-11T09:05:02+00:00","date_modified":"2021-02-11T09:05:02+00:00","modified_user_id":"1","modified_by_name":"Andre Serrazina","modified_user_link":{"full_name":"Andre Serrazina","id":"1","_acl":{"fields":{"pwd_last_changed":{"write":"no","create":"no"},"last_login":{"write":"no","create":"no"}},"_hash":"6d408abe1708e7afd72eaecf780699c2"}},"created_by":"1","created_by_name":"Andre Serrazina","created_by_link":{"full_name":"Andre Serrazina","id":"1","_acl":{"fields":{"pwd_last_changed":{"write":"no","create":"no"},"last_login":{"write":"no","create":"no"}},"_hash":"6d408abe1708e7afd72eaecf780699c2"}},"description":"","deleted":false,"job":"function::sendEmailReminders","job_url":"","job_function":"","date_time_start":"2008-01-01T16:00:01+00:00","date_time_end":"2020-12-31T23:59:59+00:00","job_interval":"*::*::*::*::*","adv_interval":"","time_from":"","time_to":"","last_run":"","status":"Active","catch_up":false,"system_job":false,"following":false,"my_favorite":false,"_acl":{"fields":{}},"_module":"Schedulers"},{"id":"44fdd258-6c48-11eb-99fc-0242ac120004","name":"Update tracker_sessions Table","date_entered":"2021-02-11T09:05:02+00:00","date_modified":"2021-02-11T09:05:02+00:00","modified_user_id":"1","modified_by_name":"Andre Serrazina","modified_user_link":{"full_name":"Andre Serrazina","id":"1","_acl":{"fields":{"pwd_last_changed":{"write":"no","create":"no"},"last_login":{"write":"no","create":"no"}},"_hash":"6d408abe1708e7afd72eaecf780699c2"}},"created_by":"1","created_by_name":"Andre Serrazina","created_by_link":{"full_name":"Andre Serrazina","id":"1","_acl":{"fields":{"pwd_last_changed":{"write":"no","create":"no"},"last_login":{"write":"no","create":"no"}},"_hash":"6d408abe1708e7afd72eaecf780699c2"}},"description":"","deleted":false,"job":"function::updateTrackerSessions","job_url":"","job_function":"","date_time_start":"2005-01-01T11:45:01+00:00","date_time_end":"2020-12-31T23:59:59+00:00","job_interval":"*::*::*::*::*","adv_interval":"","time_from":"","time_to":"","last_run":"2021-02-11T09:05:35+00:00","status":"Active","catch_up":true,"system_job":false,"following":false,"my_favorite":false,"_acl":{"fields":{}},"_module":"Schedulers"},{"id":"44fcd90c-6c48-11eb-be42-0242ac120004","name":"Prune Database on 1st of Month","date_entered":"2021-02-11T09:05:02+00:00","date_modified":"2021-02-11T09:05:02+00:00","modified_user_id":"1","modified_by_name":"Andre Serrazina","modified_user_link":{"full_name":"Andre Serrazina","id":"1","_acl":{"fields":{"pwd_last_changed":{"write":"no","create":"no"},"last_login":{"write":"no","create":"no"}},"_hash":"6d408abe1708e7afd72eaecf780699c2"}},"created_by":"1","created_by_name":"Andre Serrazina","created_by_link":{"full_name":"Andre Serrazina","id":"1","_acl":{"fields":{"pwd_last_changed":{"write":"no","create":"no"},"last_login":{"write":"no","create":"no"}},"_hash":"6d408abe1708e7afd72eaecf780699c2"}},"description":"","deleted":false,"job":"function::pruneDatabase","job_url":"","job_function":"","date_time_start":"2005-01-01T15:00:01+00:00","date_time_end":"2020-12-31T23:59:59+00:00","job_interval":"0::1::1::*::*","adv_interval":"","time_from":"","time_to":"","last_run":"","status":"Inactive","catch_up":false,"system_job":false,"following":false,"my_favorite":false,"_acl":{"fields":{}},"_module":"Schedulers"},{"id":"44fbf014-6c48-11eb-8228-0242ac120004","name":"Run Nightly Mass Email Campaigns","date_entered":"2021-02-11T09:05:02+00:00","date_modified":"2021-02-11T09:05:02+00:00","modified_user_id":"1","modified_by_name":"Andre Serrazina","modified_user_link":{"full_name":"Andre Serrazina","id":"1","_acl":{"fields":{"pwd_last_changed":{"write":"no","create":"no"},"last_login":{"write":"no","create":"no"}},"_hash":"6d408abe1708e7afd72eaecf780699c2"}},"created_by":"1","created_by_name":"Andre Serrazina","created_by_link":{"full_name":"Andre Serrazina","id":"1","_acl":{"fields":{"pwd_last_changed":{"write":"no","create":"no"},"last_login":{"write":"no","create":"no"}},"_hash":"6d408abe1708e7afd72eaecf780699c2"}},"description":"","deleted":false,"job":"function::runMassEmailCampaign","job_url":"","job_function":"","date_time_start":"2005-01-01T18:00:01+00:00","date_time_end":"2020-12-31T23:59:59+00:00","job_interval":"0::2-6::*::*::*","adv_interval":"","time_from":"","time_to":"","last_run":"2021-02-11T09:05:35+00:00","status":"Active","catch_up":true,"system_job":false,"following":false,"my_favorite":false,"_acl":{"fields":{}},"_module":"Schedulers"},{"id":"44fad2a6-6c48-11eb-87a4-0242ac120004","name":"Run Nightly Process Bounced Campaign Emails","date_entered":"2021-02-11T09:05:02+00:00","date_modified":"2021-02-11T09:05:02+00:00","modified_user_id":"1","modified_by_name":"Andre Serrazina","modified_user_link":{"full_name":"Andre Serrazina","id":"1","_acl":{"fields":{"pwd_last_changed":{"write":"no","create":"no"},"last_login":{"write":"no","create":"no"}},"_hash":"6d408abe1708e7afd72eaecf780699c2"}},"created_by":"1","created_by_name":"Andre Serrazina","created_by_link":{"full_name":"Andre Serrazina","id":"1","_acl":{"fields":{"pwd_last_changed":{"write":"no","create":"no"},"last_login":{"write":"no","create":"no"}},"_hash":"6d408abe1708e7afd72eaecf780699c2"}},"description":"","deleted":false,"job":"function::pollMonitoredInboxesForBouncedCampaignEmails","job_url":"","job_function":"","date_time_start":"2005-01-01T13:45:01+00:00","date_time_end":"2020-12-31T23:59:59+00:00","job_interval":"0::2-6::*::*::*","adv_interval":"","time_from":"","time_to":"","last_run":"2021-02-11T09:05:35+00:00","status":"Active","catch_up":true,"system_job":false,"following":false,"my_favorite":false,"_acl":{"fields":{}},"_module":"Schedulers"},{"id":"44f9035e-6c48-11eb-b4c7-0242ac120004","name":"Check Inbound Mailboxes","date_entered":"2021-02-11T09:05:02+00:00","date_modified":"2021-02-11T09:05:02+00:00","modified_user_id":"1","modified_by_name":"Andre Serrazina","modified_user_link":{"full_name":"Andre Serrazina","id":"1","_acl":{"fields":{"pwd_last_changed":{"write":"no","create":"no"},"last_login":{"write":"no","create":"no"}},"_hash":"6d408abe1708e7afd72eaecf780699c2"}},"created_by":"1","created_by_name":"Andre Serrazina","created_by_link":{"full_name":"Andre Serrazina","id":"1","_acl":{"fields":{"pwd_last_changed":{"write":"no","create":"no"},"last_login":{"write":"no","create":"no"}},"_hash":"6d408abe1708e7afd72eaecf780699c2"}},"description":"","deleted":false,"job":"function::pollMonitoredInboxes","job_url":"","job_function":"","date_time_start":"2005-01-01T16:00:01+00:00","date_time_end":"2020-12-31T23:59:59+00:00","job_interval":"*::*::*::*::*","adv_interval":"","time_from":"","time_to":"","last_run":"","status":"Active","catch_up":false,"system_job":false,"following":false,"my_favorite":false,"_acl":{"fields":{}},"_module":"Schedulers"},{"id":"44f81638-6c48-11eb-b8ab-0242ac120004","name":"Prune Tracker Tables","date_entered":"2021-02-11T09:05:02+00:00","date_modified":"2021-02-11T09:05:02+00:00","modified_user_id":"1","modified_by_name":"Andre Serrazina","modified_user_link":{"full_name":"Andre Serrazina","id":"1","_acl":{"fields":{"pwd_last_changed":{"write":"no","create":"no"},"last_login":{"write":"no","create":"no"}},"_hash":"6d408abe1708e7afd72eaecf780699c2"}},"created_by":"1","created_by_name":"Andre Serrazina","created_by_link":{"full_name":"Andre Serrazina","id":"1","_acl":{"fields":{"pwd_last_changed":{"write":"no","create":"no"},"last_login":{"write":"no","create":"no"}},"_hash":"6d408abe1708e7afd72eaecf780699c2"}},"description":"","deleted":false,"job":"function::trimTracker","job_url":"","job_function":"","date_time_start":"2005-01-01T06:30:01+00:00","date_time_end":"2020-12-31T23:59:59+00:00","job_interval":"0::2::1::*::*","adv_interval":"","time_from":"","time_to":"","last_run":"","status":"Active","catch_up":true,"system_job":false,"following":false,"my_favorite":false,"_acl":{"fields":{}},"_module":"Schedulers"},{"id":"44f5bc76-6c48-11eb-8f43-0242ac120004","name":"Run Report Generation Scheduled Tasks","date_entered":"2021-02-11T09:05:02+00:00","date_modified":"2021-02-11T09:05:02+00:00","modified_user_id":"1","modified_by_name":"Andre Serrazina","modified_user_link":{"full_name":"Andre Serrazina","id":"1","_acl":{"fields":{"pwd_last_changed":{"write":"no","create":"no"},"last_login":{"write":"no","create":"no"}},"_hash":"6d408abe1708e7afd72eaecf780699c2"}},"created_by":"1","created_by_name":"Andre Serrazina","created_by_link":{"full_name":"Andre Serrazina","id":"1","_acl":{"fields":{"pwd_last_changed":{"write":"no","create":"no"},"last_login":{"write":"no","create":"no"}},"_hash":"6d408abe1708e7afd72eaecf780699c2"}},"description":"","deleted":false,"job":"function::processQueue","job_url":"","job_function":"","date_time_start":"2005-01-01T06:45:01+00:00","date_time_end":"2020-12-31T23:59:59+00:00","job_interval":"0::6::*::*::*","adv_interval":"","time_from":"","time_to":"","last_run":"","status":"Inactive","catch_up":true,"system_job":false,"following":false,"my_favorite":false,"_acl":{"fields":{}},"_module":"Schedulers"},{"id":"44f51a46-6c48-11eb-8a8a-0242ac120004","name":"Process Workflow Tasks","date_entered":"2021-02-11T09:05:02+00:00","date_modified":"2021-02-11T09:05:02+00:00","modified_user_id":"1","modified_by_name":"Andre Serrazina","modified_user_link":{"full_name":"Andre Serrazina","id":"1","_acl":{"fields":{"pwd_last_changed":{"write":"no","create":"no"},"last_login":{"write":"no","create":"no"}},"_hash":"6d408abe1708e7afd72eaecf780699c2"}},"created_by":"1","created_by_name":"Andre Serrazina","created_by_link":{"full_name":"Andre Serrazina","id":"1","_acl":{"fields":{"pwd_last_changed":{"write":"no","create":"no"},"last_login":{"write":"no","create":"no"}},"_hash":"6d408abe1708e7afd72eaecf780699c2"}},"description":"","deleted":false,"job":"function::processWorkflow","job_url":"","job_function":"","date_time_start":"2005-01-01T09:00:01+00:00","date_time_end":"2020-12-31T23:59:59+00:00","job_interval":"*::*::*::*::*","adv_interval":"","time_from":"","time_to":"","last_run":"","status":"Active","catch_up":false,"system_job":false,"following":false,"my_favorite":false,"_acl":{"fields":{}},"_module":"Schedulers"}]}

  • Let me check. It may well be something we have broken.

  • Looking at your data I can see what looks like the same problem with the second record

    {"id":"450a6dba-6c48-11eb-ba21-0242ac120004","date_modified":"2021-02-11T09:05:02+00:00","_module":"Schedulers"}

    And our is a stock instance I have been told

  • Thanks for deep diving on the json.response, nice catch! 

    The scheduler behind it is the 'Update product definition' and it's a system scheduler that is not exposed in the GUI.

    This explains why the fields are also hidden from the REST call. 

    This can be changed by setting the field to system_job='0 in the schedulers table. 

     

    I hope this helps. 

  • Ok, cool all we needed was a explanation of what was happening. Sounds like we have that now. All good. My worry was it was something that could bite us, or be a result on a failure of understanding on our side.

    I guess by explicitly adding the fields explicitly to the request its bypassing the code that prevents the fields being seen.