Hi all, we have a record based on a view in an oracle database.
Some day ago we delete some data from the tables from which the view get the data and now the view has 253 rows, but if I open the record list we found 11583 rows. How is it possibile? With this scenario the record should execute the query every time we open it
Discussion posts and replies are publicly visible
Hi marcoc0005 could you perform a full sync and check in the record
Hi marcoc0005 Could you refresh the view once , and from Appian side could you disconnect the table and connect again into record type and check
I have deleted and reacreted the view with the same query and discconnected and recconected the table and now it works. The problem is that in test environment I can do it, in production no. Do you know why this wrong behaviorur from Appian?
I think this is a problem outside of Appian.
Hi marcoc0005 then it would be problem outside appian, I will go with Stefan Helzle option
Could you please share the DDL code of the view please?