Skip to main content
I
itsm6335
September 27, 2023
Question

Convert data store type value to table name

  • September 27, 2023
  • 6 replies
  • 0 views

I have a requirement where based on condition I need to fetch the table name so am storing it in Data Store Entity Type. Am able to fetch the value, but I need to convert this to table name.

Can some one help how to convert it. Do help with code or if we have any function

Eg:

Am getting value in Process Model in Pv!table: 473c45d0-5c99-4665-a335-f772838ccb37@2232 but I need to display exact table name.

Note: table is of type Data Store Entity

    6 replies

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    September 27, 2023

    I think there is no direct way to achieve this. As you probably do not have that many tables, did you consider a decision table to map UUIDs to names?

      I
      itsm6335Author
      September 27, 2023

      Thanks [mention:126a676c85024855948336691b0a7b92:e9ed411860ed4f2ba0265705b8793d05] for suggestion, will try that way

      stewart.burchell
      stewart.burchell
      September 27, 2023

      What is the purpose behind the requirement? (I've seen [mention:126a676c85024855948336691b0a7b92:e9ed411860ed4f2ba0265705b8793d05] proposal but that creates a maintenance overhead. Every time you add or remove or change an Entity in a DSE you'll have to change the lookup. Tables (and their names) are technical components so I'm curious as to why you need to display these and who to so that they can do what? (answering this question will provide better context and perhaps some alternate options)

      I
      itsm6335Author
      September 27, 2023

      [mention:7628077af4b9463e9533a897fad2351f:e9ed411860ed4f2ba0265705b8793d05] I have around 70 tables and based on condition am fetching the table name so am storing it in Data Store Entity Type and performing the task in Process Model. Everything is working fine.

      The requirement is :

      1) To display that table name in Process Display name(i know we need to display id here, but its client requirement)

      2) To display table name in interface, so that we know that which table was updated.

      stefanhelzle0001
      stefanhelzle0001
      Brainy
      September 28, 2023

      Can you go into more detail? What kind of application is this. In my 14 years with Appian I never had the need to display such a low level technical value to a user.

      mathieud0001
      mathieud0001
      Brainy
      September 27, 2023

      I'm not sure if this works anymore - but could be possible with this plugin; community.appian.com/.../appian-introspect-capability

      Terms & ConditionsAccessibility statement