1 id with multiple data?

 
1
0
-1

Hai all, I Have one question about the multiple data in 1 id? Do in Joget workflow can do this ?

For example : 

Id 1 = the property name ( ABC company)  with a Tenant (MKTrading) with unit no (floor 21). After the tenant expirate, we want to keep the data of the tenant as history part and maintain the property name and also the unit no. how can we solve this problem?

 

 

    CommentAdd your comment...

    1 answer

    1.  
      1
      0
      -1

      Hi there Abdul Fattah,

      I am unsure what you meant by "1 id". Do you mean 2 records having the same primary key in the same table? Or separate table? Or a foreign key that identifies a relationship between tables?

      Anyway, this is possible with the use of foreign keys. Joget is certainly capable of doing this. This question is related more about database design. You may have 2 tables where one stores the property information, while the other table will store information about tenants that references the Property table. Perhaps you can gain some inspiration about form designs by having a look at Multirow Form Binder and JDBC Form Binder. Or you can also have 2 forms with different tables and then perform join/aggregation in the datalist with the Advanced Form Data Binder.

      Hope this helps!

        CommentAdd your comment...