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

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