Retrieving view data

In these examples, the name of the view for formulas that reference a project is V\PROJECT1. The first column, "VIEWCOL1", in the FsValidationField table, is the Formula Code. The version is fetched separately.

This syntax retrieves all of the formula codes.


fRaw = ObjProperty("VIEWCOL1.VIEWS.V\PROJECT1","","","*","")

This syntax only retrieves the formula codes for the formulas that have '0001' as the version. The last argument can be the name of the column in the database.


fRaw = ObjProperty("VIEWCOL1.VIEWS.V\PROJECT1", "", "", "0001","VERSION")

Or, it can be the validation field name or number.


fRaw = ObjProperty("VIEWCOL1.VIEWS.V\PROJECT1", "", "", "0001","VIEWCOL2")
fRaw = ObjProperty("VIEWCOL1.VIEWS.V\PROJECT1", "", "", "0001","2")