TeamDesk.Select

TeamDesk.Select(url as text,optional table as nullable text,optional columns as any,optional filter as nullable text,optional orderBy as any) as table

Retrieves the data from select columns in provided table. You can also apply an additional filter for results as well as change the order in which records are retrieved.

示例:

Selects text and date columns

使用情况:

TeamDesk.Select("https://www.teamdesk.net/secure/db/57692", "Meeting", { "Starter", "Start Date", "Participants" })

输出:

#table(
    { "Starter", "Start Date", "Participants" },
    {
        { ""Joe"", #date(2018, 10, 12), 10 },
        // ...
    }
)