AllAccepted answers
John Murray · Jul 30

Excellent article @Timothy Leavitt 

I'd like to offer an example from the coalface today. An issue was affecting my improved Testing Manager extension for VS Code. Coverage information from the Test Coverage Tool package assumes that a method signature only occupies one line, but an option in the ObjectScript extension can instruct the server to generate the UDL representation with multi-argument signatures split across consecutive lines.

I was pretty sure the necessary information was available in SQL tables on the server. I just needed to come up with the right query. I consider myself novice grade on SQL, so was glad that Copilot could use the GPT-4.1 model to improve the initial query I'd drafted in the SQLTools extension.

I started with this:

SELECT Name as Method,
  $LENGTH(FormalSpec, ',') AS ArgumentCount,
  CASE
    WHEN $LENGTH(FormalSpec, ',') > 1 THEN $LENGTH(FormalSpec, ',')
    ELSE 0
  END AS AddsLines
FROM %Dictionary.MethodDefinition
WHERE parent = '%IPM.Repo.Definition'
ORDER BY SequenceNumber

Copilot got me very close, and a small tweak by me yielded this:

SELECT Name as Method,
  $LENGTH(FormalSpec, ',') AS ArgumentCount,
  CASE
    WHEN $LENGTH(FormalSpec, ',') > 1 THEN $LENGTH(FormalSpec, ',')
    ELSE 0
  END AS AddsLines,
  SUM(
    CASE
      WHEN $LENGTH(FormalSpec, ',') > 1 THEN $LENGTH(FormalSpec, ',')
      ELSE 0
    END
  ) OVER (
    ORDER BY SequenceNumber ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW
  ) AS Offset
FROM %Dictionary.MethodDefinition
WHERE parent = '%IPM.Repo.Definition'
ORDER BY SequenceNumber
John Murray · Jul 4

I think the command to export from a project only exports the project's server-side classes / routines to individual client-side files.

Since your title mentions deployment I'm guessing you want all the project members exported into a single XML file.

An export of multiple server-side items to a single XML can already be done using the `ObjectScript: Export Documents to XML File...` command from Palette. But currently this can't auto-select only the members of a project.