2 Replies Latest reply on Jan 17, 2018 12:10 PM by rkandasamy-2 RSS
    rkandasamy-2 Newbie

    Challenges faced in writing queries while using external DB to store data

    Hi Team,


    I hope many of you might be using external DB to store project data as it is huge in size. But you might have faced challenges like writing required queries AddorUpdateDataTableEntries, queryDatatableEntries,PurgeDataTableEntries.


    1. You had some generic AddOrUpdateDataTableEntries like in thingworx or you have been writing queries specific to each data table operations.

    2. QueryDataTableEntries - In Where condition some queries might use a single column and in some other queries there might use many columns. Otherwise please confirm if you are using specific queries for each Query of DataTables that contain different fields.


    As we are in the initial phase of setting that up, it would be helpful for people like us to understand and be prepared for the same.