• Retrieving Related Items

    I need to take a "Requirement Document" item_number, find all the related "Requirement Document Requirements" and their "Requirements". Looking at the solution for Unit 8 in the v12 Developing Solutions guide I got a pretty good idea how to do this…
  • using the SQL item type as a view

    Querying a SQL view I built in SSMS from an Aras server method: string SQL_View = "innovator.my_custom_sql_view"; string SQL = "select * from " + SQL_View; Item SQL_qry = inn.applySQL(SQL); This is quick for me because I do a lot in SQL, but I know…