I want to fetch each field label in a tabular form but I only get the current one how to retrieve the field name? I do not want the current thing here. Is their any alternative solution out there? Please let me know.
Hi Chetnya,
Thanks for posting your question. I am not totally sure what you are trying to do, but this sounds like a crosstab or pivot query.
Here are some links that might help
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns – SQLServerCentral
Using PIVOT and UNPIVOT - SQL Server | Microsoft Learn
Would you like to provide a little more explanation of what you want to do, and what is the end result you are trying to achieve? That might help us give you a better answer.
I hope this helps.
Kind regards,
Stuart
You said right, Inside the label attribute their fields are name, email, phone number, etc, I need to show them in a tabular form but in a table header place not as a field. Can you help me out with this and tell me how to do this in OutSystems? One more question do we write SQL queries to display data in OutSystems and can we implement it to display label fields as a table header?
Hi Chetna,
To also write the table header requires you writing the HTML for the table yourself using the HTML element widget. The OutSystems tables widget will not help you in this situation.
I assume you meant to ask how do we write SQL queries in OutSystems. Please review this documentation: SQL Queries - OutSystems 11 Documentation
This is quite an advanced scenario. If you're reasonably new to OutSystems, you might want to call for some help. Otherwise, all the best and I hope it works out for you.