Dynamic access to database table

Hi,


I am working on an application that will be used for different functionalities with same environment and database, so I need to segment data depending on functionality.


Regrettably, data segmentation on tables is not enought for security requirements, I need to query data from different entities depending on functionality dinamically (on run time).
I am trying to use a variable, of type dataStoreEntity, to set entity which query on in each case. I know that dataStoreEntity type has an ID to represents the entity, but i don't know how get it.

Is there any way to define the value to set on variable on run time? It's possible to get the ID of an entity, for example, by entity's name?

 

  Discussion posts and replies are publicly visible

Parents
  • Hi Sergio,

    AS of now Appian did not provide to function or way to see the UUID of data store entity.

    As i understand on your query, create "Veiw" while making the data segment for multiple entity/table as per my understating and do whatever query you want to do.

    after that create query entity put filter as per requirement. probably this will help you.

    if i did not , please elaborate more.
Reply
  • Hi Sergio,

    AS of now Appian did not provide to function or way to see the UUID of data store entity.

    As i understand on your query, create "Veiw" while making the data segment for multiple entity/table as per my understating and do whatever query you want to do.

    after that create query entity put filter as per requirement. probably this will help you.

    if i did not , please elaborate more.
Children
No Data