Solved

Data on UI

Forum|Forum|2 years ago
February 1, 2024
23 replies
0 views

Hi Team,

Sometimes, the data was not available on UI and it is available on DB.

What could be the scenarios, would this be a performance issue?

Best answer by harshitb6843

You don't have access to the DataStore
You don't have access to the recordType
You are not in the record level security configuration
You have some default filters working
The record type is not synced
The connection to DB is broken
The mapping between your CDT and table in the DB in invalid

harshitb6843

Tell us more about the problem. The objects involved, the data size, screenshots, code, and anything that adds more light to the issue.

P

purvajab0002Author

We are quering data from DB and showing on the UI that table has around 5L records.

harshitb6843

I still don't have a very good idea. Can you post some screenshots of the interface, and result you are getting from the queryEntity/queryRecordType and the DB?

mathieud0001

Definitely looks like a data sync issue.

Likely, you have something writing directly to the database that doesn't subsequently sync.

Are you using the Stored Procedure or Query Database Smart Service by any chance?

https://docs.appian.com/suite/help/23.4/Query_Database_Smart_Service.html

P

purvajab0002Author

No, we are using Write to data store entity smart service.

But, if this is a sync issue how the already available data could be disappeared?

mathieud0001

Because only data persisted with the 3 smart services above are synced back to the Record.

Any other changes to the DB (either via a SQL Script on the backend or the 2 Smart Services I listed above) won't be synched at the time the data is changed, they will be picked up in the next scheduled sync.

Sign up

Login with SSO

Login to the community

Login with SSO