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

paulc919 over 9 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

0 jackm829
A Score Level 3
over 9 years ago

I've seen functionality where table data is displayed dynamically on the front end. The queryEntity call would run off of the data store entity constant that corresponds to the table (not data store) that the user chooses. BTW, when you mention "column names on the data store" - I think you may mean data store entity?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 paulc919 over 9 years ago

Yep - sorry I do indeed mean the Data Store Entity - it the table itself
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Tom Ryan
Appian Employee
over 9 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