Forums - Thread Details
  • State Not Answered
  • Replies 9 replies
  • Subscribers 320 subscribers
  • Views 1397 views
  • Users 0 members are here
Related

Another Strange inconsistent (it seems) result.

Nick Gorham

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.

Parents
  • 0

    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? 

  • 0 in reply to Andre Serrazina

    Thanks

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

  • 0 in reply to Nick Gorham

    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? 

    Fullscreen response.json Download 
    {"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"}]}

  • 0 in reply to Andre Serrazina

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

  • 0 in reply to Andre Serrazina

    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

  • 0 in reply to Nick Gorham

    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. 

  • 0 in reply to Andre Serrazina

    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.

Reply Children
No Data