Join 34,000+ subscribers and receive articles from our blog about software quality, testing, QA and security.

Select items as alias, alias can not be a number?


I try to implement my query and I found that I would get an error if I use “select items as id” when the id is a number.




Hi Alston,

Do you mean SQL query? We usually recommend accessing data via TestRail’s API and not via the database if possible. That said, databases usually have good error reporting and should be able to find what’s wrong with the query by reviewing the exact error message.