topic Re: Status change in App Development

Status change

Sra1bandi — Mon, 23 May 2022 13:41:47 GMT

Hi team,

I have a field which is having field values status= closed, open , ready , complete

The file is daily updating then the status will also change according to the change

For example previously i have status= Ready now it's changed to Status= Complete

In table status both are displaying when it's updated

I want only the status when it's updates to Status=Complete show only complete don't require status=Ready

How to do that

Thank and regards

Sra1

saranyadurai — Mon, 23 May 2022 14:32:07 GMT

I hope you have a Key field in the file. Based on that, you can use the Not Exists script function in your model.

Example:

Load

Keyfield,

Status,

Keyfield&Status as LinkKey <- Used to fetch the new updated value

FROM XXX; < - Newly updated file

Concatenate

Load

Keyfield,

Status,

LinkKey

FROM YYY where not exists (LinkKey ,LinkKey) ;

I hope it helps you !!!

Thanks !