-
Goal: It should execute the only query once
-
Steps: I removed every element from the app and left only the query, its still executed twice
-
Details: Even leaving the query nearly empty with a simple SELECT * FROM doesn't work
EDIT: That occurs in another app, in the example when the like with theWHEREcondition where theurlparamsare read, the query is executed only once -
Screenshots:
It doesn't allow me to upload a JSON, so here it is (also in Pastebin)
{"uuid":"7755d2be-b605-11ee-8817-1b5b0887dcaf","page":{"id":24245,"data":{"appState":"[\"~#iR\",[\"^ \",\"n\",\"appTemplate\",\"v\",[\"^ \",\"isFetching\",false,\"plugins\",[\"~#iOM\",[\"$main\",[\"^0\",[\"^ \",\"n\",\"pluginTemplate\",\"v\",[\"^ \",\"id\",\"$main\",\"uuid\",null,\"type\",\"frame\",\"subtype\",\"Frame\",\"namespace\",null,\"resourceName\",null,\"resourceDisplayName\",null,\"template\",[\"^3\",[\"type\",\"main\",\"sticky\",null,\"paddingType\",\"normal\",\"enableFullBleed\",false,\"isHiddenOnDesktop\",false,\"isHiddenOnMobile\",false]],\"style\",[\"^3\",[]],\"position2\",null,\"mobilePosition2\",null,\"mobileAppPosition\",null,\"tabIndex\",null,\"container\",\"\",\"createdAt\",\"~m1705584523525\",\"updatedAt\",\"~m1705933874639\",\"folder\",\"\",\"screen\",null]]],\"salvage\",[\"^0\",[\"^ \",\"n\",\"pluginTemplate\",\"v\",[\"^ \",\"id\",\"salvage\",\"^4\",null,\"^5\",\"datasource\",\"^6\",\"SqlQueryUnified\",\"^7\",null,\"^8\",\"c1a64e95-4d9d-49ef-aed6-c015d78ce249\",\"^9\",\"aurora-claims\",\"^:\",[\"^3\",[\"queryRefreshTime\",\"\",\"allowedGroupIds\",[\"~#iL\",[]],\"streamResponse\",false,\"records\",\"\",\"lastReceivedFromResourceAt\",null,\"databasePasswordOverride\",\"\",\"queryDisabledMessage\",\"\",\"servedFromCache\",false,\"offlineUserQueryInputs\",\"\",\"successMessage\",\"\",\"queryDisabled\",\"\",\"playgroundQuerySaveId\",\"latest\",\"workflowParams\",null,\"resourceNameOverride\",\"\",\"runWhenModelUpdates\",true,\"workflowRunId\",null,\"showFailureToaster\",true,\"query\",\"SELECT s.*, c.number as claim_number\\nFROM salvage s\\nINNER JOIN claim c ON c.uuid = s.claim_uuid\\nWHERE s.uuid = {{ urlparams.salvage_uuid || urlparams.hash.salvage_uuid }}\\nLIMIT 1\",\"playgroundQueryUuid\",\"\",\"playgroundQueryId\",null,\"error\",null,\"workflowRunBodyType\",\"raw\",\"privateParams\",[\"^E\",[]],\"workflowBlockUuid\",null,\"runWhenPageLoadsDelay\",\"\",\"warningCodes\",[\"^E\",[]],\"data\",null,\"recordId\",\"\",\"importedQueryInputs\",[\"^3\",[]],\"isImported\",false,\"showSuccessToaster\",true,\"dataArray\",[\"^E\",[]],\"cacheKeyTtl\",\"\",\"filterBy\",\"\",\"requestSentTimestamp\",null,\"databaseHostOverride\",\"\",\"metadata\",null,\"workflowActionType\",null,\"editorMode\",\"sql\",\"queryRunTime\",null,\"actionType\",\"\",\"changesetObject\",\"\",\"shouldUseLegacySql\",false,\"errorTransformer\",\"// The variable 'data' allows you to reference the request's data in the transformer. \\n// example: return data.find(element => element.isError)\\nreturn data.error\",\"finished\",null,\"databaseNameOverride\",\"\",\"confirmationMessage\",null,\"isFetching\",false,\"changeset\",\"\",\"rawData\",null,\"queryTriggerDelay\",\"0\",\"resourceTypeOverride\",\"\",\"watchedParams\",[\"^E\",[]],\"enableErrorTransformer\",false,\"databaseWarehouseOverride\",\"\",\"enableBulkUpdates\",false,\"showLatestVersionUpdatedWarning\",false,\"timestamp\",0,\"importedQueryDefaults\",[\"^3\",[]],\"enableTransformer\",true,\"showUpdateSetValueDynamicallyToggle\",true,\"overrideOrgCacheForUserCache\",false,\"bulkUpdatePrimaryKey\",\"\",\"runWhenPageLoads\",false,\"transformer\",\"// Query results are available as the `data` variable\\nreturn formatDataAsArray(data)[0]\",\"events\",[\"^E\",[]],\"tableName\",\"\",\"queryTimeout\",\"10000\",\"workflowId\",null,\"requireConfirmation\",false,\"queryFailureConditions\",\"\",\"changesetIsObject\",false,\"enableCaching\",false,\"allowedGroups\",[\"^E\",[]],\"databaseUsernameOverride\",\"\",\"databaseRoleOverride\",\"\",\"shouldEnableBatchQuerying\",false,\"doNotThrowOnNoOp\",false,\"offlineQueryType\",\"None\",\"queryThrottleTime\",\"750\",\"updateSetValueDynamically\",false,\"notificationDuration\",\"\"]],\"^;\",null,\"^<\",null,\"^=\",null,\"^>\",null,\"^?\",null,\"^@\",\"\",\"^A\",\"~m1705592523520\",\"^B\",\"~m1706125365596\",\"^C\",\"\",\"^D\",null]]],\"$urlFragments\",[\"^0\",[\"^ \",\"n\",\"pluginTemplate\",\"v\",[\"^ \",\"id\",\"$urlFragments\",\"^4\",null,\"^5\",\"setting\",\"^6\",\"UrlFragments\",\"^7\",null,\"^8\",null,\"^9\",null,\"^:\",[\"^3\",[\"value\",[\"^3\",[]]]],\"^;\",null,\"^<\",null,\"^=\",null,\"^>\",null,\"^?\",null,\"^@\",\"\",\"^A\",\"~m1705935509786\",\"^B\",\"~m1706122976574\",\"^C\",\"\",\"^D\",null]]],\"$customDocumentTitle\",[\"^0\",[\"^ \",\"n\",\"pluginTemplate\",\"v\",[\"^ \",\"id\",\"$customDocumentTitle\",\"^4\",null,\"^5\",\"setting\",\"^6\",\"DocumentTitle\",\"^7\",null,\"^8\",null,\"^9\",null,\"^:\",[\"^3\",[\"value\",\"Deltalhes do salvado\"]],\"^;\",null,\"^<\",null,\"^=\",null,\"^>\",null,\"^?\",null,\"^@\",\"\",\"^A\",\"~m1706123075335\",\"^B\",\"~m1706123078017\",\"^C\",\"\",\"^D\",null]]]]],\"^A\",null,\"version\",\"3.24.4\",\"appThemeId\",1,\"appThemeName\",\"Justos\",\"appMaxWidth\",\"100%\",\"preloadedAppJavaScript\",null,\"preloadedAppJSLinks\",[],\"testEntities\",[],\"tests\",[],\"appStyles\",\"\",\"responsiveLayoutDisabled\",false,\"loadingIndicatorsDisabled\",false,\"urlFragmentDefinitions\",[\"^E\",[]],\"pageLoadValueOverrides\",[\"^E\",[]],\"customDocumentTitle\",\"\",\"customDocumentTitleEnabled\",true,\"customShortcuts\",[],\"isGlobalWidget\",false,\"isMobileApp\",false,\"isFormApp\",false,\"shortlink\",false,\"multiScreenMobileApp\",false,\"mobileAppSettings\",[\"^ \",\"mobileOfflineModeEnabled\",false,\"mobileOfflineModeDelaySync\",false,\"mobileOfflineModeBannerMode\",\"default\",\"displaySetting\",[\"^ \",\"landscapeMode\",false,\"tabletMode\",false]],\"folders\",[\"^E\",[]],\"queryStatusVisibility\",false,\"markdownLinkBehavior\",\"auto\",\"inAppRetoolPillAppearance\",\"NO_OVERRIDE\",\"rootScreen\",null,\"instrumentationEnabled\",false,\"experimentalFeatures\",[\"^ \",\"sourceControlTemplateDehydration\",false,\"multiplayerEditingEnabled\",false,\"disableMultiplayerEditing\",false],\"experimentalDataTabEnabled\",true,\"customComponentCollections\",[],\"savePlatform\",\"web\"]]]"},"changesRecord":[{"type":"MIGRATIONS_UP_TO_DATE","payload":{"migratedAppTemplate":{"tests":[],"folders":[],"plugins":{"$main":{"id":"$main","type":"frame","uuid":null,"style":{},"folder":"","screen":null,"subtype":"Frame","tabIndex":null,"template":{"type":"main","sticky":null,"paddingType":"normal","enableFullBleed":false,"isHiddenOnMobile":false,"isHiddenOnDesktop":false},"container":"","createdAt":"2024-01-18T13:28:43.525Z","namespace":null,"position2":null,"updatedAt":"2024-01-22T14:31:14.639Z","resourceName":null,"mobilePosition2":null,"mobileAppPosition":null,"resourceDisplayName":null},"salvage":{"id":"salvage","type":"datasource","uuid":null,"style":null,"folder":"","screen":null,"subtype":"SqlQueryUnified","tabIndex":null,"template":{"data":null,"error":null,"query":"SELECT s.*, c.number as claim_number\nFROM salvage s\nINNER JOIN claim c ON c.uuid = s.claim_uuid\nWHERE s.uuid = {{ urlparams.salvage_uuid || urlparams.hash.salvage_uuid }}\nLIMIT 1","events":[],"rawData":null,"records":"","filterBy":"","finished":null,"metadata":null,"recordId":"","changeset":"","dataArray":[],"tableName":"","timestamp":0,"actionType":"","editorMode":"sql","isFetching":false,"isImported":false,"workflowId":null,"cacheKeyTtl":"","transformer":"// Query results are available as the `data` variable\nreturn formatDataAsArray(data)[0]","queryRunTime":null,"queryTimeout":"10000","warningCodes":[],"allowedGroups":[],"enableCaching":false,"privateParams":[],"queryDisabled":"","watchedParams":[],"workflowRunId":null,"streamResponse":false,"successMessage":"","workflowParams":null,"allowedGroupIds":[],"changesetObject":"","servedFromCache":false,"doNotThrowOnNoOp":false,"errorTransformer":"// The variable 'data' allows you to reference the request's data in the transformer. \n// example: return data.find(element => element.isError)\nreturn data.error","offlineQueryType":"None","queryRefreshTime":"","runWhenPageLoads":false,"changesetIsObject":false,"enableBulkUpdates":false,"enableTransformer":true,"playgroundQueryId":null,"queryThrottleTime":"750","queryTriggerDelay":"0","workflowBlockUuid":null,"shouldUseLegacySql":false,"showFailureToaster":true,"showSuccessToaster":true,"workflowActionType":null,"confirmationMessage":null,"importedQueryInputs":{},"playgroundQueryUuid":"","requireConfirmation":false,"runWhenModelUpdates":true,"workflowRunBodyType":"raw","bulkUpdatePrimaryKey":"","databaseHostOverride":"","databaseNameOverride":"","databaseRoleOverride":"","notificationDuration":"","queryDisabledMessage":"","requestSentTimestamp":null,"resourceNameOverride":"","resourceTypeOverride":"","importedQueryDefaults":{},"playgroundQuerySaveId":"latest","runWhenPageLoadsDelay":"","enableErrorTransformer":false,"offlineUserQueryInputs":"","queryFailureConditions":"","databasePasswordOverride":"","databaseUsernameOverride":"","databaseWarehouseOverride":"","shouldEnableBatchQuerying":false,"updateSetValueDynamically":false,"lastReceivedFromResourceAt":null,"overrideOrgCacheForUserCache":false,"showLatestVersionUpdatedWarning":false,"showUpdateSetValueDynamicallyToggle":true},"container":"","createdAt":"2024-01-18T15:42:03.520Z","namespace":null,"position2":null,"updatedAt":"2024-01-24T19:42:45.596Z","resourceName":"c1a64e95-4d9d-49ef-aed6-c015d78ce249","mobilePosition2":null,"mobileAppPosition":null,"resourceDisplayName":null},"$urlFragments":{"id":"$urlFragments","type":"setting","uuid":null,"style":null,"folder":"","screen":null,"subtype":"UrlFragments","tabIndex":null,"template":{"value":{}},"container":"","createdAt":"2024-01-22T14:58:29.786Z","namespace":null,"position2":null,"updatedAt":"2024-01-24T19:02:56.574Z","resourceName":null,"mobilePosition2":null,"mobileAppPosition":null,"resourceDisplayName":null},"salvageDocuments":{"id":"salvageDocuments","type":"datasource","uuid":null,"style":null,"folder":"","screen":null,"subtype":"SqlQueryUnified","tabIndex":null,"template":{"data":null,"error":null,"query":"SELECT *\nFROM document\nWHERE type = 'SALVAGE_DOCUMENT'\nAND salvage_uuid = {{ salvage.data?.uuid }}\nAND deleted_at IS NULL","events":[],"rawData":null,"records":"","filterBy":"","finished":null,"metadata":null,"recordId":"","changeset":"","dataArray":[],"tableName":"","timestamp":0,"actionType":"","editorMode":"sql","isFetching":false,"isImported":false,"workflowId":null,"cacheKeyTtl":"","transformer":"// Query results are available as the `data` variable\nreturn formatDataAsArray(data)","queryRunTime":null,"queryTimeout":"10000","warningCodes":[],"allowedGroups":[],"enableCaching":false,"privateParams":[],"queryDisabled":"","watchedParams":[],"workflowRunId":null,"streamResponse":false,"successMessage":"","workflowParams":null,"allowedGroupIds":[],"changesetObject":"","servedFromCache":false,"doNotThrowOnNoOp":false,"errorTransformer":"// The variable 'data' allows you to reference the request's data in the transformer. \n// example: return data.find(element => element.isError)\nreturn data.error","offlineQueryType":"None","queryRefreshTime":"","runWhenPageLoads":false,"changesetIsObject":false,"enableBulkUpdates":false,"enableTransformer":true,"playgroundQueryId":null,"queryThrottleTime":"750","queryTriggerDelay":"0","workflowBlockUuid":null,"shouldUseLegacySql":false,"showFailureToaster":true,"showSuccessToaster":true,"workflowActionType":null,"confirmationMessage":null,"importedQueryInputs":{},"playgroundQueryUuid":"","requireConfirmation":false,"runWhenModelUpdates":true,"workflowRunBodyType":"raw","bulkUpdatePrimaryKey":"","databaseHostOverride":"","databaseNameOverride":"","databaseRoleOverride":"","notificationDuration":"","queryDisabledMessage":"","requestSentTimestamp":null,"resourceNameOverride":"","resourceTypeOverride":null,"importedQueryDefaults":{},"playgroundQuerySaveId":"latest","runWhenPageLoadsDelay":"","enableErrorTransformer":false,"offlineUserQueryInputs":"","queryFailureConditions":"","databasePasswordOverride":"","databaseUsernameOverride":"","databaseWarehouseOverride":"","shouldEnableBatchQuerying":false,"updateSetValueDynamically":false,"lastReceivedFromResourceAt":null,"overrideOrgCacheForUserCache":false,"showLatestVersionUpdatedWarning":false,"showUpdateSetValueDynamicallyToggle":true},"container":"","createdAt":"2024-01-23T09:28:23.460Z","namespace":null,"position2":null,"updatedAt":"2024-01-24T17:53:44.127Z","resourceName":"c1a64e95-4d9d-49ef-aed6-c015d78ce249","mobilePosition2":null,"mobileAppPosition":null,"resourceDisplayName":null},"$customDocumentTitle":{"id":"$customDocumentTitle","type":"setting","uuid":null,"style":null,"folder":"","screen":null,"subtype":"DocumentTitle","tabIndex":null,"template":{"value":"Deltalhes do salvado"},"container":"","createdAt":"2024-01-24T19:04:35.335Z","namespace":null,"position2":null,"updatedAt":"2024-01-24T19:04:38.017Z","resourceName":null,"mobilePosition2":null,"mobileAppPosition":null,"resourceDisplayName":null}},"version":"3.24.4","appStyles":"","createdAt":null,"isFormApp":false,"shortlink":false,"appThemeId":1,"isFetching":false,"rootScreen":null,"appMaxWidth":"100%","isMobileApp":false,"appThemeName":"Justos","savePlatform":"web","testEntities":[],"isGlobalWidget":false,"customShortcuts":[],"mobileAppSettings":{"displaySetting":{"tabletMode":false,"landscapeMode":false},"mobileOfflineModeEnabled":false,"mobileOfflineModeDelaySync":false,"mobileOfflineModeBannerMode":"default"},"customDocumentTitle":"","preloadedAppJSLinks":[],"experimentalFeatures":{"disableMultiplayerEditing":false,"multiplayerEditingEnabled":false,"sourceControlTemplateDehydration":false},"markdownLinkBehavior":"auto","multiScreenMobileApp":false,"queryStatusVisibility":false,"instrumentationEnabled":false,"pageLoadValueOverrides":[],"preloadedAppJavaScript":null,"urlFragmentDefinitions":[],"responsiveLayoutDisabled":false,"inAppRetoolPillAppearance":"NO_OVERRIDE","loadingIndicatorsDisabled":false,"customComponentCollections":[],"customDocumentTitleEnabled":true,"experimentalDataTabEnabled":true}}},{"type":"WIDGET_REPOSITION2","payload":{"moves":[{"move":{},"widgetIds":[]}],"largeScreen":true},"hideChangelogEntry":false},{"type":"PLUGIN_DELETE","payload":["salvageDocuments"],"hideChangelogEntry":false}],"gitSha":null,"checksum":null,"createdAt":"2024-01-24T19:43:09.600Z","updatedAt":"2024-01-24T19:43:09.600Z","pageId":85,"userId":1,"branchId":null,"page":{"name":"SalvageDetails"}},"modules":{}}
