need to write to database with dynamic cdt type


Scenario, We have a UI where Admin team selected the table from dropdown where they want to make changes . Now i have to send that CDT as an input to write to datastore from interface.

Can this is something we can do , entity remains same but input changes based on user selection .

What to select in type usually we select CDT for which we want change , but in my case it will come from UI. Any thoughts how to do it ? or any other solution basically based on table selection we need to update a value in one column,

  Discussion posts and replies are publicly visible

  • You'd probably have more luck with the "write to multiple DSE" node, where you can expressionize both the entity as well as the data you want to pass in.  Just note you still might need to do a lot of manual logic to pass in different data types - i'd start out trying to do a very small proof of concept and see if it scales too big when you try to add other types.

  • Hi Gaurav,

    Following are the 2 options i would try 

    a) a!writeToDataStoreEntity()  might help you. based on the user selection you can dynamically update the parameters,but only thing is you wont be able to validate the values using monitoring 

    b)Other option is to create lookup table which contains values for all the tables. Based on the user's table selection (assign the foreign-key id which refers-to the lookup-table), you can create entry in the reference table with some entries. Only challenge is anytime when you create new table ,you need to create entry in the lookup table.


    Lookup table

    id , tablename

    1       employeeinfo

    2      leaverequest

    3.     masterdata

    Reference-table (based on the user selection , populate the values here)

    refid lookupid(foreign-key), cdtvalue               status

    1        1                              employeeinfo      completed

    2        1                             employeeinfo     inprogress

    3        3                             masterdata           new

    Hope this helps.