Question

Data is still present even though It has been deleted from the Tables.

Forum|Forum|3 years ago
May 10, 2023
4 replies
0 views

Hi All,

I am new to Appian, during one of my solution development I have found that I have deleted the rows from the oracle table and when I am trying to test the expression rule where I used Query Generator to get the data from that table , it's stil returning the old data.

So can you please help me to know that how can I clear some cache or sync it with my tables ?

I am using query generator to generate that expression rule.

G

gauravs0010

Inspiring

Hi Sourabh,

Is your data sourced from sync enabled Record Type.?, If yes that may be because your record have the data in cache once you resync it you wont be getting any data.

You can also share your code here to look into further.

S

sourabhs2166Author

it's just simple expression rule which I created using query generator:

a!queryEntity(
entity: cons!METRICS_ORACLE_DATASTORE_PROCESS_MODELS,
query: a!query(
pagingInfo: a!pagingInfo(
startIndex: 1,
batchSize: 50
)
),
fetchTotalCount: false
)

constant is only reffering to the datastore that I created.