Skip to main content
Planview Customer Success Center

How to query for additional data in an Intelligent Forms drop down list

A form in Changepoint Intelligent Forms needs to access data that is not available by default. For example, the categories per request type are not available. But for a form that creates requests, this data is required.

Changepoint doesn't deliver data objects to all database tables out of the box. Access to additional Changepoint tables needs to be configured in Infiniti Manage:

Go to data sources - Changepoint DB Tables - Data Objects and create an object with the same name as the database table (like RequestCategory for the request categories).

The available columns will be retrieved automatically, then please configure which columns are available for filtering and for display. E.g. for the request categories, filtering by the column RequestType is required.

Note: This operation requires knowledge of the Changepoint data model. Also, the Changepoint data model can change through patches and upgrades, in which case custom data sources and custom forms might need to be changed.