# To bring the dataset values under the instances created **URL:** \ **Category:** Ignition\ **Tags:** perspective\ **Created:** [May 23, 2023, 10:30am UTC](https://forum.inductiveautomation.com/t/to-bring-the-dataset-values-under-the-instances-created/74060 "2023-05-23T10:30:52Z")\ **Posts on this page:** 17\ **Page:** 2
**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 25, 2023, 10:12am UTC](https://forum.inductiveautomation.com/t/to-bring-the-dataset-values-under-the-instances-created/74060/21 "2023-05-25T10:12:47Z")
Yes, I've gone through it as well but its not about perspective there, only about vision is given.. ---
**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Post date:** [May 25, 2023, 10:14am UTC](https://forum.inductiveautomation.com/t/to-bring-the-dataset-values-under-the-instances-created/74060/23 "2023-05-25T10:14:41Z")
No. Have a read of the user manual regarding using parameters in named queries. The Inductive university has topics covering perspective, thus in particular is about named queries though ---
**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Post date:** [May 25, 2023, 10:15am UTC](https://forum.inductiveautomation.com/t/to-bring-the-dataset-values-under-the-instances-created/74060/24 "2023-05-25T10:15:10Z")
You're trying to pass a string into an int?? Before posting, read the error you're getting and try to work it out before asking for help. That error is pretty self-explanatory ---
**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 25, 2023, 10:23am UTC](https://forum.inductiveautomation.com/t/to-bring-the-dataset-values-under-the-instances-created/74060/25 "2023-05-25T10:23:08Z")
![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/2/f239c60cdc598a8bd73cd737d7163a75246c7902.png) My doubt is whether can I able to type the serial number in text field and search in a separate view and to get the tester status like(pass,fail,untested) in instances of each in another view? ---
**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Post date:** [May 25, 2023, 10:25am UTC](https://forum.inductiveautomation.com/t/to-bring-the-dataset-values-under-the-instances-created/74060/26 "2023-05-25T10:25:44Z")
Again, you're not using the query parameter in the query, and your parameter is an integer and you're passing in a string Read the user manual Go through the Inductive University Until then, I'm out ---
**Author:** ![nideyijuyidong](https://avatars.discourse-cdn.com/v4/letter/n/7cd45c/32.png) [@nideyijuyidong](https://forum.inductiveautomation.com/u/nideyijuyidong)\ **Post date:** [May 25, 2023, 10:27am UTC](https://forum.inductiveautomation.com/t/to-bring-the-dataset-values-under-the-instances-created/74060/27 "2023-05-25T10:27:58Z")
Yes, of course. But we can't help you each click. At least, search for relevant knowledge on the online manual. ---
**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 25, 2023, 10:30am UTC](https://forum.inductiveautomation.com/t/to-bring-the-dataset-values-under-the-instances-created/74060/28 "2023-05-25T10:30:14Z")
That's not how parameterized named queries work. But you'd know that if you had watched the IU video about it... or read the doc. Short and simple version: If the parameter name is `foo`, use `:foo` as a place holder in the query. Then pass a value to the parameter `foo` when calling that query. Make sure the types match. named queries doc: [https://docs.inductiveautomation.com/display/DOC81/Named+Queries](https://docs.inductiveautomation.com/display/DOC81/Named+Queries) IU video (the link is in the doc): > **[Named Query Introduction Video at Inductive University](https://inductiveuniversity.com/videos/named-query-introduction/8.1)** > > Take a quick tour of the Named Query workspace. There are 2 videos, one is an introduction, the other one is about parameters. The total length is 4:48. Less than 5 minutes. 5 minutes of videos, and you wouldn't have to ask such basic questions. ---
**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 26, 2023, 12:32pm UTC](https://forum.inductiveautomation.com/t/to-bring-the-dataset-values-under-the-instances-created/74060/29 "2023-05-26T12:32:21Z")
![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/c/9c1ea5eea0e10ed09af4158b7e658a0b4647c7ec.png) Here I'm getting the required data (TESTERNAME and PASSFAILSTATUS) in named query ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/e/9ecc325d6d7abd3e4c860d7719cb361a528c69d7.png) But I'm not getting it in the instances of flex repeater ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/b/0/b0b7ca82e5022ed032b9d6e756811a29cfc1d111.png) And also the dataset in instance is showing zero rows ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/8/0/80a7032f2991cba3306665db4045c73b675fe085.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 26, 2023, 12:35pm UTC](https://forum.inductiveautomation.com/t/to-bring-the-dataset-values-under-the-instances-created/74060/30 "2023-05-26T12:35:24Z")
Thanks, I've watched this video earlier but I didn't notice the mistake in my code..Now I've changed but how can I make it into instances that must bind in the buttons like this ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/a/e/ae84d1042866f63b00d9629308a2b24ba6eff61a.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 26, 2023, 1:57pm UTC](https://forum.inductiveautomation.com/t/to-bring-the-dataset-values-under-the-instances-created/74060/31 "2023-05-26T13:57:03Z")
Instead of making your project for you, I'll try and point you in the right direction, in the hope you see how easy it is to solve when you pay attention and make a little effort: 1. Look at the error you get: ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/c/4/c4434b6f8d59efcbb4569fabac41f6f33d15789e.png) 2. read the doc for template repeaters: [Perspective - Flex Repeater - Ignition User Manual 8.1 - Ignition Documentation](https://docs.inductiveautomation.com/display/DOC81/Perspective+-+Flex+Repeater) 3. find the part describing the `instances` property: 4. use a script transform to change your dataset into something the flex repeater can use. 5. realize that my very first post in this thread did exactly that ---
**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 26, 2023, 2:12pm UTC](https://forum.inductiveautomation.com/t/to-bring-the-dataset-values-under-the-instances-created/74060/32 "2023-05-26T14:12:29Z")
The array under instances are getting disappeared whenever I query bind the instances with named query (serialnumbersearch)... > [@pascal.fragnoud](#): > > use a script transform to change your dataset into something the flex repeater can use. I'm stuck with this point..please help me how can I do this ---
**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 26, 2023, 2:19pm UTC](https://forum.inductiveautomation.com/t/to-bring-the-dataset-values-under-the-instances-created/74060/33 "2023-05-26T14:19:10Z")
> [@pascal.fragnoud](#): > > Bind the `instances` property to the dataset, then add this script transform: How can I bind the instance property to dataset. Do I need to create new path for dataset ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/8/78c51d6a645a5236a89e9c7655612a603244a835.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 26, 2023, 2:43pm UTC](https://forum.inductiveautomation.com/t/to-bring-the-dataset-values-under-the-instances-created/74060/34 "2023-05-26T14:43:45Z")
Come on ! Here's your dataset: ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/4/f/4fbeb570afd27286a5b51311ede9c6da91fa977c.png) ---
**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Post date:** [May 27, 2023, 10:58am UTC](https://forum.inductiveautomation.com/t/to-bring-the-dataset-values-under-the-instances-created/74060/35 "2023-05-27T10:58:52Z")
"1st arg can't be coerced into a dataset" again, read the error, it's very self-explanatory. You're transforming a string not a dataset. Btw, you can change the 'return format' of a named query to json rather than a dataset, which may get you what you need ---
**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 28, 2023, 5:13am UTC](https://forum.inductiveautomation.com/t/to-bring-the-dataset-values-under-the-instances-created/74060/36 "2023-05-28T05:13:58Z")
That's done by my colleague, she told me to post and ask how only its coming like this....My requirement is not in the same view.. serial number search in one view and it should display in instances of 10 rows of respective testername and passfailstatus in another view .. ---
**Author:** ![nideyijuyidong](https://avatars.discourse-cdn.com/v4/letter/n/7cd45c/32.png) [@nideyijuyidong](https://forum.inductiveautomation.com/u/nideyijuyidong)\ **Post date:** [May 28, 2023, 5:53am UTC](https://forum.inductiveautomation.com/t/to-bring-the-dataset-values-under-the-instances-created/74060/37 "2023-05-28T05:53:35Z")
I suggest you wait a few months to fix this issue. Currently, it's beyond your comprehension. ignition is a powerful and feature-rich platform. In my opinion, you need more knowledge and experience to design your function. You fail to understand actions and processes that are obvious and natural. We spent a lot of time helping you with a problem that should have been solved in 5 minutes (and failed), because you didn't know the essence of the problem yourself. Sorry I have to criticize you, but I hope this helps you. Please try multiple times to understand the previous comment. ---
**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 28, 2023, 7:09am UTC](https://forum.inductiveautomation.com/t/to-bring-the-dataset-values-under-the-instances-created/74060/38 "2023-05-28T07:09:25Z")
A few things here: - You come asking for help and show us screenshots where everything is put together. Then, after 5 days and 35 messages, you tell us they're not in the same view. How are we supposed to help you if we don't have the basic information ? - So, how is everything set up ? If everything is in different views but still in the same page, you might still be able to access the table's data. - But in any case, no matter where things are: You have a table with data. You need that data for something else. If you can't access it directly... just use the same mechanism that's used to fill the table. If it's populated by a query... Use that query again. Though, as was already said multiple times: This is ignition basics. It's VERY simple. We can help and explain things you don't understand, but in order to do that you first need to learn the basics. If there are things you don't get, that's when you can ask for help. But you can't just do things randomly and come ask why they don't work every single time. We don't have time for that. And even if we did, I doubt anyone would have the patience required. [Previous page](https://forum.inductiveautomation.com/t/to-bring-the-dataset-values-under-the-instances-created/74060.md?page=1)