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.
Discussion posts and replies are publicly visible
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.
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.
So which table your constant : METRICS_ORACLE_DATASTORE_PROCESS_MODELS points to,?Can you share the xsd of the same?
Might be a stupid suggestion, but are you sure that you have committed those changes?