Menu

FinPlusRTDQuery

Anonymous Fin-Plus

Excel DNA RTD add-in, wraps the select functionality of FinPlusDBConn.

Function

As per spreadsheet cell

=FinPlusQry(QueryType, Group, DateTime, Where, ConType, DisplayFields, DisplayOrder)
Arguments Description
QueryType See FinPlusDBConn types.
Group Functions are related to groups.
DateTime SelectAsOf/SelectFrom query date time.
Where Where clause.
ConType None, Amend, All and New.
DisplayFields Fields to display in spreadsheet.
DisplayOrder Fields to order by.


Related

Wiki: ExcelNotes
Wiki: FinPlusBooker
Wiki: FinPlusDBConn
Wiki: Projects
Wiki: SideBar
Wiki: Where