Duplicate data in collection

[lad.s...@gmail.com]

Hello Team,

As per client requirement we are using external database(sql server) to save and load the data into RMP web interfaces. In one Web interface we have to display data in table format. The rows are dynamic and rows count depends on data present in database tables. To implement this functionality first we tried with JavaScript report. By using JavaScript report we are able to load data from sql server(using Capi) to Web interface in table format but paging and filtering is not working with JavaScript report. Due to this issue later we have replaced JavaScript repot with collection. First of all we created Composite API to load all the data from sql database and then we are saving these data into collection using col_License.saveCallback(object,add_ok,add_ko); method and the we have used this collection in report widget to display data in table format. Data is loaded successfully and paging, filtering is also working fine but when we refresh web interface url it is adding another set of same data into collection and it causes duplication of data.Also we are opening popup window(custom widget) on each row of data to update the specific row using (update process). Data is successfully updated into sql database but collection is not updating.
I have attached JavaScript code to load data from CAPI to collection and output of report.
Please let us know what changes need to do in code so that it will work fine
Any help on this would be much appreciated.

Thanks,
Satish Lad

[lad.s...@gmail.com]

PFA for code and report output

[Muralikrishna Kummaragunta]

Hi Satish,

Once the data added/updated into collection, collection report needs to be refreshed, with below statement. Attached the code template for the similar operation for your reference.
    //id_report.refresh();

Related the duplicate data, we need to review and debug complete resource configurations and can proceed with a support contract to resolve the Project specific requirements.

Awaiting for your feedback.

Regards,

Murali

Fujitsu RunMyProcess Support

On Thu, Apr 6, 2017 at 2:39 PM, <lad.s...@gmail.com> wrote:

PFA for code and report output

--
Fujitsu - RunMyProcess
---
You received this message because you are subscribed to the Google Groups "Fujitsu RunMyProcess Developer Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to supportforum+unsubscribe@runmyprocess.com.
To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at https://groups.google.com/a/runmyprocess.com/group/supportforum/.
To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/103d022a-55d1-4759-a45d-2c036391be01%40runmyprocess.com.

For more options, visit https://groups.google.com/a/runmyprocess.com/d/optout.