(SOLVED) Loosing data using multiple joins in checkboxes

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
jannes
Posts: 100
Joined: Tue Jul 02, 2019 12:22 pm

(SOLVED) Loosing data using multiple joins in checkboxes

Post by jannes »

Hi,

There are 3 tables :
• Customer
• Company
• Manufacturer

Customer can have multiple Company
Customer can have multiple Manufacturer
Manufacturer can have multiple Customer
Manufacturer can have multiple Company
Company can have multiple Manufacturer
Company can have multiple Customer

All relations are Peer / multiple allowed

Checkbox Widgets are used so the user can easily define relations.

But entering data in one screen, data is lost in other tables.
Records are simply deleted in other tables.
For instance : entering Customer-Manufactur relations will delete data in Customer-Company..

Is it a known issue / bug ?
Or do I have to store the relations in tables like CustomerCompany, ManufacturerCustomer etc.. ?

= Jannes
Last edited by jannes on Tue May 19, 2020 9:45 am, edited 1 time in total.
BLOMASKY
Posts: 1470
Joined: Wed Sep 30, 2015 10:08 pm
Location: Ocala FL

Re: Loosing data when using multiple joins in checkbox-scree

Post by BLOMASKY »

You have Many to Many relationships. To handle that, Aware will create a 3rd table which is used to relate the two tables. This new table ends in "_REF". So you can examine that table and see if rows are being deleted. I use them with pick lists to select the "related" records and have not had any problem.

Bruce
jannes
Posts: 100
Joined: Tue Jul 02, 2019 12:22 pm

Re: Loosing data when using multiple joins in checkbox-scree

Post by jannes »

Yes, the records are physically deleted in the REF-tables.

= Jannes
BLOMASKY
Posts: 1470
Joined: Wed Sep 30, 2015 10:08 pm
Location: Ocala FL

Re: Loosing data when using multiple joins in checkbox-scree

Post by BLOMASKY »

I would love to see a sample BSV that causes this. I have not had this issue and if it is because of the aware engine, would be nice to know sooner rather than later.

Bruce
aware_support
Posts: 7523
Joined: Sun Apr 24, 2005 12:36 am
Contact:

Re: Loosing data when using multiple joins in checkbox-scree

Post by aware_support »

There were a couple of bugs related to checkbox lists. Use the latest build 2722 that fixes some of them
Aware IM Support Team
jannes
Posts: 100
Joined: Tue Jul 02, 2019 12:22 pm

Re: Loosing data using multiple joins in checkboxes (SOLVED)

Post by jannes »

The issue is solved by (thnx to Vlad) :

1. Update to the latest Aware IM build 2722 (if not done already)
2. Download the file
https://awareim84.s3.amazonaws.com/awareim.jar
3. Put this file into the following directories
a) AwareIM/lib
b) AwareIM/Tomcat/webapps/AwareIM/WEB-INF/lib
overwriting the original files (keep the originals somewhere just in case)
4. Download the file
https://awareim84.s3.amazonaws.com/aware.js
5, Put this file in AwareIM/Tomcat/webapps/AwareIM/aware-kendo directory overriding the original
Restart Aware IM
6. Clear browser cache and refresh the browser

= Jannes
Post Reply