AppGini Community Forums

I have 2 table :

table 1 : property
- ID
- Property Name
- LandLot
- Latest Comment ( function column, this will pull onnly 1 latest comment in table 2 )

Table 2 : property_comment
- id
- comment
- property => look up to table 1 - ID

How do i show Latest Comment ( function column, this will pull onnly 1 latest comment in table 2 )

thanks

Hi,

what is the identifier to retrieve the latest comment?

Hi tmih,

I do not really understand what you are trying to do. I suppose to have a "latest" comment, you would also need a date/time identifier. If you have a field with that timestamp, you can so something like (code not tested) Olaf

Hi,

There is no need for an additional column in this scenario. You can use the existing auto-increment id-column. The greater the id, the newer the record. So you'll have so sort DESCENDING.
But if you need for example the last modified comment, you should add a column "modified_on" (datetime), for example as Olaf has suggested. You can use the AppGini built-in default value "<%%editingDateTime%%>" for example

Best,
Jan

Hi Jan,

I agree, but using a timestamp would enable to edit old records (and make an existing comment "newer").
Olaf

tks you i'm trying

thank you, i know sql code but how do i add it to table view ?? thanks,can you give me an example

table 1 : property
- ID
- Property Name
- LandLot
- Latest Comment ( function column, this will pull onnly 1 latest comment in table 2 ) <<<<

table_view.php table_dml.php

Hi,

in the hooks/property_comment.php (Assuming, property_comment is the table you are using for the comments)

add to the function property_comment_after_insert
and also to the function property_comment_after_update
This shall put the latest comment, or the latest edited comment to your poperty table.