32
Views
7
Comments
Data Grid

I encountered some problem in data grid. I have joined two tables to become a list but all the fields are shown. How can I perform below job, 

1. Select the column that i would like to show (I tried to edit the SQL, but it mentioned the output column is unmatched)

2. Reorder the column

3. Make some field become editable 


Kindly advise

Hello @Winnie Lam 

I am providing you an oml which has data grid implemented with basic operations like 

  • Fetch Data and show in data grid.
  • Make fields editable and save the changes to the database
  • Add/remove rows

Hope that it will help, if you need anything more specific you can share your oml with description.

Thanks

DataGrid_Task.oml

Hi, @Mohd Anees Mansoori 

I have few issues, 

1. How can I add link to the record and direct to another edit page?
-->I added link to "phase" to direct to another page but seems no click on UI 



2. I set some fields become "allow edit", but when I inputted the value and click save, below error is prompted. However, when i export it to the excel, i can see the value.


Kindly advise. Thanks.

Hi @Mohd Anees Mansoori , Please check, 

1. MainFlow>JobTestPopUp2
-->Added "Link" on Phase to direct the page JobTestPopUp



2. Save Changes on MainFlow>Screen3

-->Inputted Target Date and Press save changes, it shows "Success", but still nth after I refresh the data


3. I dunno Why "Filter by value" filter is missing on the header in screen3, and only "Filter by condition" now.


4. Can you help make a example of GetViewLayout and SetViewLayout cuz I can't make it.

https://outsystemsui.outsystems.com/OutSystemsDataGridSample/SaveGridView



Hi @Mohd Anees Mansoori , Please check, 

1. MainFlow>JobTestPopUp2
-->Added "Link" on Phase to direct the page JobTestPopUp



2. Save Changes on MainFlow>Screen3

-->Inputted Target Date and Press save changes, it shows "Success", but still nth after I refresh the data


3. I dunno Why "Filter by value" filter is missing on the header in screen3, and only "Filter by condition" now.


4. Can you help make a example of GetViewLayout and SetViewLayout cuz I can't make it.

https://outsystemsui.outsystems.com/OutSystemsDataGridSample/SaveGridView



Test_20230911.oml

Hello @Winnie Lam ,

I have attached an oml in which redirect to another page with input parameters through data grid's column.

Please find the oml.

Click on the highlighted text to check here.

Hope this helps.

Thanks & regards

Pawan Parmar


DataGridDemoNew.oml


- How can I make the action item direct to another page for edit ?, I wanna direct to JobTestPopUp according to the record Id.



- Also, would you mind to advise the GetViewLayout and SetViewLayout configuration on the grid list too ? 

Thank you so much!!

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.