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…
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…