Hi - not sure if what I'd like to achieve is possible in Appian or not ? (I&

paulc919 over 8 years ago

Hi - not sure if what I'd like to achieve is possible in Appian or not ? (I've used similar function in Java before so am hoping it is possibly)

I'd like to build a User Interface that has the ability to add / edit data store content dynamically based on the data store selected. This could range from displaying 4 fields for edit up to maybe 20 fields.

Is there an equivalent Appian function that will give access to the datastore meta data ? (Column names on the data store)

If anyone has done this before any hints / tips would be appreciated.

Thank you in advance

Paul

Discussion posts and replies are publicly visible

Parents

0 Tom Ryan
Appian Employee
over 8 years ago

Apart from building a custom plugin to expose the table metadata, one option could be to create a query/view that returns the column names as part of the result set, eg:

SELECT 'ID' AS id, 'Name' AS name
UNION ALL
SELECT id, name
FROM People
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Tom Ryan
Appian Employee
over 8 years ago

Apart from building a custom plugin to expose the table metadata, one option could be to create a query/view that returns the column names as part of the result set, eg:

SELECT 'ID' AS id, 'Name' AS name
UNION ALL
SELECT id, name
FROM People
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data