Hello Community,
I am using a SQL query for my Interactive Grid. Here is the query:
SELECT DISTINCT
main.RATE_TYPE,
comp.COMP_DESC AS RATE_TYPE_DESC,
main.INCO_TERM,
terms.TERM_DESC AS INCO_TERM_DESC,
main.CREATE_DATETIME,
main.CREATED_BY,
main.UPDATE_DATETIME,
main.UPDATED_BY
FROM TABLE1 main
JOIN TABLE2 comp
ON TRIM(main.RATE_TYPE) = TRIM(comp.COMP_ID)
JOIN TABLE3_TL terms
ON TRIM(main.INCO_TERM) = TRIM(terms.FREIGHT_TERMS)
So, here when I am adding a new row or doing any edit activity on the interactive grid, it is not allowing me to do so. And whenever the rate type or Inco term is edited the update datetime is also not being updated. Please help me out with this.