[BUDI-7355] Using a Formula column as the display column in SQL will cause the table not to load data after re-fetching #11423
Labels
bb-sql
bug
Something isn't working
env - production
Bug found in production
formula
Relating to Budibase formulas
High priority
Created by Linear-GitHub Sync
sql-server
Checklist
Hosting
Describe the bug
I have a SQL Server datasource and I fetch some tables. In one of the tables I create a new Formula column and set it as the display column. When I fetch tables again, that table will no longer return any data.
To Reproduce
Steps to reproduce the behavior:
Expected behavior
I should be able to set a formula column as the display column in a SQL table, and not have any issues when re-fetching my tables.
Screenshots
Now fetch tables and click on the table…
From SyncLinear.com | BUDI-7355
Also this option should be enabled in the Grid view:
![image](https://private-user-images.githubusercontent.com/101575380/257818850-cc355f59-2b92-4e10-8151-e627f50d59d2.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjE2NzkxODksIm5iZiI6MTcyMTY3ODg4OSwicGF0aCI6Ii8xMDE1NzUzODAvMjU3ODE4ODUwLWNjMzU1ZjU5LTJiOTItNGUxMC04MTUxLWU2MjdmNTBkNTlkMi5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjQwNzIyJTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI0MDcyMlQyMDA4MDlaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT1jYmEzZGRhMzU5YTY3MzBiOTE5Yzc2N2NkOTRmNDJkYzQ3MmJiMGJiMjFmZWM3YjExMTBlMjBhYTQ2M2Y3OTQ2JlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZhY3Rvcl9pZD0wJmtleV9pZD0wJnJlcG9faWQ9MCJ9.ObgYehWqJPWNRXs87FGu-LeGx4oqoN-icd8Qit5kpw4)
The text was updated successfully, but these errors were encountered: