Support Questions
Find answers, ask questions, and share your expertise

QueryDatabaseTable Processor -option : Maximum-value Columns is not working for two columns

QueryDatabaseTable Processor -option : Maximum-value Columns is not working for two columns

New Contributor

Hi,

Scenario:

I have two columns create_date and update_date

When a record is created, the create_date is set to current timestamp, update_date to null.

If an update occurs, update_date is set to current timestamp. create_date not changed.

============================================================================

I'm using QueryDatabaseTable Processor : "Maximum-value Columns" option and keep the two columns as comma separated.

I inserted one new row with high timestamp and updated existing record with high timestamp (not as the same ) . So I am expecting two records should retrieve . But it is not working when i keep two columns.

It is working when i keep one column either create_date or update.

As per my understanding .. it is working like WHERE MAX(create_date) AND MAX(update_date) , that's why it is not extracting both changes. if it uses like this WHERE MAX(create_date) OR MAX(update_date) , it will work.

Can you please anyone help me on this.