Softa 中文
首页文档OpenAPI
关于
首页文档OpenAPI
关于
Github
    • Model APIs
      • copyById
      • copyByIdAndFetch
      • copyByIds
      • copyByIdsAndFetch
      • count
      • createList
      • createListAndFetch
      • createOne
      • createOneAndFetch
      • deleteById
      • deleteByIds
      • deleteBySliceId
      • getById
      • getByIds
      • getCopyableFields
      • getDefaultValues
      • getRowFiles
      • getUnmaskedField
      • getUnmaskedFields
      • searchList
      • searchName
      • searchPage
      • searchPivot
      • searchSimpleAgg
      • updateByFilter
      • updateList
      • updateListAndFetch
      • updateOne
      • updateOneAndFetch
      • uploadFile
      • uploadFileToRow
      • onChange
    • Toolkit
      • fixUnencryptedData
      • recompute
      • validateExpression
    • ChangeLog
      • getChangeLog
      • getSliceChangeLog
      • searchPage_1
      • searchPageByModel
    • Export Template
      • listByModel
    • File Record
      • getByFileId
    • Import Template
      • getTemplateFile
      • listByModel
    • SysPreData
      • loadPreSystemData
      • loadPreTenantData
      • loadSystemDataByUpload
    • SysView
      • getModelViews
      • setDefaultView
    • Data Export
      • dynamicExport
      • exportByFileTemplate
      • exportByTemplate
    • Import
      • dynamicImport
      • importByTemplate
      • validateImport
    • Metadata Upgrade API
    • DeptInfo
      • readCustomize
    • DocumentTemplate
      • generateDocument
    • SysModel
      • getMetaModel
    • SysOptionSet
      • getOptionItems
      • getOptionSetItems
    • AiRobot
      • Chat API
      • Persist Chat Message
      • Stream Chat
    • FlowConfig
      • getByModel
      • getFlowById
    • SysCron
      • Execute multiple for once now
      • Execute once now
    • Flow Automation
      • API Event
      • Onchange Event
      • Simulate Event Message
    • DesignAppEnv
      • getNotVersionedChanges
      • mergeBetweenEnv
      • previewBetweenEnv
      • compareDesignWithRuntime
    • DesignAppVersion
      • createOne_1
      • publish
      • reloadAppVersion
      • addWorkItem
      • freezeVersion
      • previewDDL_3
      • previewVersion
      • removeWorkItem
      • sealVersion
      • unsealVersion
    • DesignModel
      • downloadCode
      • downloadZip
      • previewCode
      • downloadAllZip
      • previewDDL_1
      • previewAllCode
    • RPC
      • RPC
    • File
      • getByFileId
      • getRowFiles
      • uploadFileToField
      • uploadFileToRow
    • UserAccount Controller
      • changeMyPassword
      • getMyAccount
      • Lock User Account
      • logout
      • saveMyAccount
      • Unlock User Account
      • Batch Unlock User Accounts
    • UserProfile Controller
      • Get Current User Profile
      • Get Current User Info
      • Update or Create Current User Profile
    • Login
      • forgotPassword
      • loginByApple
      • loginByEmail
      • loginByMobileCode
      • loginByOAuth2
      • loginByPassword
      • registerByPassword
      • resetPassword
      • sendEmailCode
      • sendMobileCode
    • Metadata API
      • getMetaModel
      • reload
      • upgrade
      • exportRuntimeMetadata
    • DesignApp
      • transitionStatus_1
    • DesignDeployment
      • deployToEnv
      • previewDDL_2
      • previewDeployment
      • retry
    • DesignPortfolio
      • transitionStatus
    • DesignWorkItem
      • cancelWorkItem
      • deferWorkItem
      • doneWorkItem
      • mergeToLatestVersion
      • previewChanges
      • previewDDL
      • readyWorkItem
      • reopenWorkItem
    • Export History
      • myExportHistory
    • Import History
      • myImportHistory
    • SigningDocument
      • Sign a signing document
    • 数据模型
      • Schemas
        • AI Chat Message
        • FlowEventVO
        • ModelViewVO
        • DesignAppVersionVO
        • SimpleQueryParams
        • FileInfo
        • SubQueries
        • UserInfo
        • UserPermission
      • AI Stream Request
      • API Response Body
      • AI User Message
      • Filters
      • AggFunctions
      • ImportWizard
      • AppleLoginDTO
      • ExportParams
      • BulkUpdateParams
      • DesignAppVersionDTO
      • ChangePasswordDTO
      • QueryParams
      • MetadataUpgradePackage
      • FlowEventDTO
      • EmailCodeDTO
      • CountParams
      • EmailPasswordDTO
      • Orders
      • SubQuery
      • ModelViewDTO
      • ForgotPasswordDTO
      • ImportFieldDTO
      • Simple ModelFields
      • JsonNode
      • Simple ModelField
      • GetByIdParams
      • MobileCodeDTO
      • GetByIdsParams
      • SearchListParams
      • Name
      • OnChangeParams
      • SearchNameParams
      • OAuthCredential
      • SseEmitter
      • Trigger Event Params
      • ResetPasswordDTO
      • SimpleAggParams
      • SignRenderOptionsDto
      • SignatureEvidenceDto
      • SignaturePlacementDto
      • SigningDocumentSignRequest
      • User
      • UserAccountDTO
      • UnlockAccountDTO
      • UserProfileDTO
      • UnlockAccountsDTO

    SubQuery

    {
        "count": true,
        "fields": [
            "id",
            "name"
        ],
        "filters": [
            "name",
            "=",
            "PM"
        ],
        "orders": [
            "name",
            "ASC"
        ],
        "subQueries": {},
        "topN": 3
    }
    Built with