During the report design phase, comments hide the special Talent Management query syntax for domain filtering, search filtering, and ordering. The comment characters prevent BIRT from reading the Talent Management query syntax so that you can test the reports. When you import, Talent Management removes the comment characters so that the query runs properly.
The comment characters include the double asterisk at the front of a SQL comment:
/** AND a.stud_id in [UserSearch]
AND [security:pa_student a]
ORDER BY [order_by_parameter OrderBy "FNAME=a.fname;LNAME=a.lname"]
Characters in brackets ([]) are read by Talent Management but not by either the BIRT Report Engine or any SQL DBMS. You can call, for example, a the run-time value of parameter from the Plateau.rptlibrary called UserSearch by writing:
a.stud_id in [UserSearch]
At run time, Talent Management takes the user's entry into the UserSearch parameter and includes it in the SQL statement. For example, if at run time, the user passed values jdoe, bsmith, and rmiller into the UserSearch parameter, the SQL above matches the a.stud_id to those values: jdoe, bsmith, and rmiller. You can read more about the uses of bracket syntax in filtering, ordering, administrator security, and user security.