Execute SQL Server built in function within a Query Class query

(0) Share

Report

Posted on by Jim Richardson

Is it possible to execute SQL Server built in functions within a Query class built query. For example our implementation has projects and sub-projects. The report needs to display only the "Project Id" but include information from the sub-projects table. I tried to the following to no avail:

"ds.addrange (fieldNum (myTable, myField).value (strfmt ('(%1.projectId == substring (%2.subProjectId, 1, 6))', dsProjectTable.name (), dsSubProjectTable.name ()));"

Jim Richardson

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Martin Dráb 235,928 Most Valuable Professional on at

Like (0)

Report

RE: Execute SQL Server built in function within a Query Class query

It's not possible, as far as I know.

Regarding projects, you might be able to use ProjTable.ParentId. If you're looking for the root project (not just the nearest parent), it's probably worth maintaining it as a separate field. Filtering will be trivial (and fast) then.

Was this reply helpful? Yes No