# How to make dataset connected to the table component **URL:** \ **Category:** Ignition\ **Tags:** perspective\ **Created:** [May 31, 2023, 6:28am UTC](https://forum.inductiveautomation.com/t/how-to-make-dataset-connected-to-the-table-component/74333 "2023-05-31T06:28:23Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![Chowmya\_C](https://avatars.discourse-cdn.com/v4/letter/c/d78d45/32.png) [@Chowmya\_C](https://forum.inductiveautomation.com/u/Chowmya_C)\ **Post date:** [May 31, 2023, 6:28am UTC](https://forum.inductiveautomation.com/t/how-to-make-dataset-connected-to-the-table-component/74333/1 "2023-05-31T06:28:23Z")
![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/3/f3f39909dfa219ee417e84c4bd9842eacdc6bc1a.png) Hi, How will the table display all the rows and columns as in dataset? Is that possible to do with the query binding the table and does it require script transform, if it's so then what can be done.. Errors in table props: ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/4/2/42759d24b51c36ca5ff4f996cfb14ee85eb9bede.png) ---
**Author:** ![pascal.fragnoud](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pascal.fragnoud/32/24728_2.png) [@pascal.fragnoud](https://forum.inductiveautomation.com/u/pascal.fragnoud)\ **Post date:** [May 31, 2023, 6:44am UTC](https://forum.inductiveautomation.com/t/how-to-make-dataset-connected-to-the-table-component/74333/2 "2023-05-31T06:44:56Z")
You can see from the binding popup that there's an error in the evaluation of that binding. Since there's only a query, and it's a configuration error, I suspect that either the named query path or the parameter path is wrong. Make sure those are the proper paths/names. ---
**Author:** ![Chowmya\_C](https://avatars.discourse-cdn.com/v4/letter/c/d78d45/32.png) [@Chowmya\_C](https://forum.inductiveautomation.com/u/Chowmya_C)\ **Post date:** [May 31, 2023, 7:07am UTC](https://forum.inductiveautomation.com/t/how-to-make-dataset-connected-to-the-table-component/74333/3 "2023-05-31T07:07:46Z")
![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/4/946009f7857de37378d6c3636c726a2d2f8d8463.png) Thank you, I got the solution by your guidance. ---
**Author:** ![Priyanka.Khandge](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/priyanka.khandge/32/35989_2.png) [@Priyanka.Khandge](https://forum.inductiveautomation.com/u/Priyanka.Khandge)\ **Post date:** [May 31, 2023, 7:10am UTC](https://forum.inductiveautomation.com/t/how-to-make-dataset-connected-to-the-table-component/74333/4 "2023-05-31T07:10:43Z")
@Chowmya_C can you check your parameter direction? If it is only input or output please select both Input/Output (for bidirectional). For more details, I see the below screenshot. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/6/f677a37acb338a2c65440a03d6c1b131f48e891c.png) ---
**Author:** ![pascal.fragnoud](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pascal.fragnoud/32/24728_2.png) [@pascal.fragnoud](https://forum.inductiveautomation.com/u/pascal.fragnoud)\ **Post date:** [May 31, 2023, 7:55am UTC](https://forum.inductiveautomation.com/t/how-to-make-dataset-connected-to-the-table-component/74333/5 "2023-05-31T07:55:22Z")
Why do you think it should be bidirectional ? ---
**Author:** ![Chowmya\_C](https://avatars.discourse-cdn.com/v4/letter/c/d78d45/32.png) [@Chowmya\_C](https://forum.inductiveautomation.com/u/Chowmya_C)\ **Post date:** [May 31, 2023, 9:02am UTC](https://forum.inductiveautomation.com/t/how-to-make-dataset-connected-to-the-table-component/74333/6 "2023-05-31T09:02:01Z")
Since I've 10 TESTERNAMES how can I add them to the named query so that it will reflect in my table. ---
**Author:** ![pascal.fragnoud](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pascal.fragnoud/32/24728_2.png) [@pascal.fragnoud](https://forum.inductiveautomation.com/u/pascal.fragnoud)\ **Post date:** [May 31, 2023, 9:06am UTC](https://forum.inductiveautomation.com/t/how-to-make-dataset-connected-to-the-table-component/74333/7 "2023-05-31T09:06:20Z")
If that named query is used elsewhere, don't change it or you'll break things. Make a new named query, that's just like this one, but with the appropriate filter (that's the `WHERE` clause). We don't know anything about your tables and the data that's in there, so we can't do much more than that. Also, it's basic SQL, you can find a thousand tutorials on google on how to filter data from a table. ---
**Author:** ![Chowmya\_C](https://avatars.discourse-cdn.com/v4/letter/c/d78d45/32.png) [@Chowmya\_C](https://forum.inductiveautomation.com/u/Chowmya_C)\ **Post date:** [May 31, 2023, 9:29am UTC](https://forum.inductiveautomation.com/t/how-to-make-dataset-connected-to-the-table-component/74333/8 "2023-05-31T09:29:35Z")
> [@pascal.fragnoud](#): > > Make a new named query, that's just like this one, but with the appropriate filter (that's the `WHERE` clause). Thanks, I've got the answer. ---
**Author:** ![Chowmya\_C](https://avatars.discourse-cdn.com/v4/letter/c/d78d45/32.png) [@Chowmya\_C](https://forum.inductiveautomation.com/u/Chowmya_C)\ **Post date:** [May 31, 2023, 9:47am UTC](https://forum.inductiveautomation.com/t/how-to-make-dataset-connected-to-the-table-component/74333/9 "2023-05-31T09:47:29Z")
This πŸ‘‡is DB's start time and end time ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/5/5/5590f56b8aa470004d45d77e701d64f1fc525659.png) whereas in table component why its automatically changing like this πŸ‘‡, is there any way to change this as same as in DB? ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/a/b/ab0934e89a4c9732450fc6476f17184da904aef8.png) ---
**Author:** ![pascal.fragnoud](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pascal.fragnoud/32/24728_2.png) [@pascal.fragnoud](https://forum.inductiveautomation.com/u/pascal.fragnoud)\ **Post date:** [May 31, 2023, 9:51am UTC](https://forum.inductiveautomation.com/t/how-to-make-dataset-connected-to-the-table-component/74333/10 "2023-05-31T09:51:02Z")
Check the `columns` property in the table's doc: [https://docs.inductiveautomation.com/display/DOC81/Perspective+-+Table#PerspectiveTable-Properties](https://docs.inductiveautomation.com/display/DOC81/Perspective+-+Table#PerspectiveTable-Properties) ---
**Author:** ![Chowmya\_C](https://avatars.discourse-cdn.com/v4/letter/c/d78d45/32.png) [@Chowmya\_C](https://forum.inductiveautomation.com/u/Chowmya_C)\ **Post date:** [May 31, 2023, 10:23am UTC](https://forum.inductiveautomation.com/t/how-to-make-dataset-connected-to-the-table-component/74333/11 "2023-05-31T10:23:38Z")
Thank you! That's helpful. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/4/2/423f90194054e29574bbe3de5a40bbd5a4cebe77.png) ---
**Author:** ![Chowmya\_C](https://avatars.discourse-cdn.com/v4/letter/c/d78d45/32.png) [@Chowmya\_C](https://forum.inductiveautomation.com/u/Chowmya_C)\ **Post date:** [May 31, 2023, 4:27pm UTC](https://forum.inductiveautomation.com/t/how-to-make-dataset-connected-to-the-table-component/74333/12 "2023-05-31T16:27:46Z")
Is it possible to change the filter table part into dropdown option in table component ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/c/6/c6f187a1b228cec749ae340fd877e034617b466b.png) ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/f/7fba9a9e543d480cc8756211c8476d8e9b1672fa.png) ---
**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Post date:** [May 31, 2023, 5:13pm UTC](https://forum.inductiveautomation.com/t/how-to-make-dataset-connected-to-the-table-component/74333/13 "2023-05-31T17:13:00Z")
> Is it possible to change the filter table part into dropdown option in table component? No. It is a text search only. You can, of course, create a dropdown filter outside of the table and feed the dropdown selection into your query. ---
**Author:** ![Chowmya\_C](https://avatars.discourse-cdn.com/v4/letter/c/d78d45/32.png) [@Chowmya\_C](https://forum.inductiveautomation.com/u/Chowmya_C)\ **Post date:** [May 31, 2023, 5:29pm UTC](https://forum.inductiveautomation.com/t/how-to-make-dataset-connected-to-the-table-component/74333/14 "2023-05-31T17:29:51Z")
Will that dropdown be able to pick and show in its options -as things from one of the columns in table. And on selecting one of the option will that sort out in table as well? ---
**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Post date:** [May 31, 2023, 5:38pm UTC](https://forum.inductiveautomation.com/t/how-to-make-dataset-connected-to-the-table-component/74333/15 "2023-05-31T17:38:18Z")
> [@Chowmya\_C](#): > > Will that dropdown be able to pick and show in its options -as things from one of the columns in table. Think about it. If you first populate the dropdown from the table and then select an item from the dropdown and feed the result into the table binding query then the dropdown options list could only have one item after it updates based on the new table contents. Create a new named query to populate the dropdown options.