# Show tester stations for particular serial number in flex repeater from memory tag **URL:** \ **Category:** Ignition\ **Tags:** perspective\ **Created:** [May 9, 2023, 10:35am UTC](https://forum.inductiveautomation.com/t/show-tester-stations-for-particular-serial-number-in-flex-repeater-from-memory-tag/73459 "2023-05-09T10:35:47Z")\ **Posts on this page:** 20\ **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 10, 2023, 12:45pm UTC](https://forum.inductiveautomation.com/t/show-tester-stations-for-particular-serial-number-in-flex-repeater-from-memory-tag/73459/21 "2023-05-10T12:45:26Z")
No, it doesn't have access to the DB So am I not able to make the tags work when I type serial number and to show the tester status for that serial number alone ---
**Author:** ![lrose](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lrose/32/62724_2.png) [@lrose](https://forum.inductiveautomation.com/u/lrose)\ **Post date:** [May 10, 2023, 12:50pm UTC](https://forum.inductiveautomation.com/t/show-tester-stations-for-particular-serial-number-in-flex-repeater-from-memory-tag/73459/22 "2023-05-10T12:50:36Z")
> [@Chowmya\_C](#): > > So am I not able to make the tags work when I type serial number and to show the tester status for that serial number alone Memory tags have no external connection, so without a connection to the source (DB as stated by you), how do you expect to get a status? Memory tags hold a value in memory, they can only be changed by something inside of Ignition. You can use memory tags, but there has to be something that goes out and gets the information from the DB, otherwise the value of the tags will only ever be what you have placed in the tags as the value. ---
**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 10, 2023, 12:54pm UTC](https://forum.inductiveautomation.com/t/show-tester-stations-for-particular-serial-number-in-flex-repeater-from-memory-tag/73459/23 "2023-05-10T12:54:02Z")
Ok, so the only chance to get the solution is through DB, am I correct? ---
**Author:** ![lrose](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lrose/32/62724_2.png) [@lrose](https://forum.inductiveautomation.com/u/lrose)\ **Post date:** [May 10, 2023, 12:57pm UTC](https://forum.inductiveautomation.com/t/show-tester-stations-for-particular-serial-number-in-flex-repeater-from-memory-tag/73459/24 "2023-05-10T12:57:28Z")
> [@Chowmya\_C](#): > > the only chance to get the solution is through DB If that is the only source of the data, then yes at some point you will need a connection to the DB. ---
**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 10, 2023, 12:59pm UTC](https://forum.inductiveautomation.com/t/show-tester-stations-for-particular-serial-number-in-flex-repeater-from-memory-tag/73459/25 "2023-05-10T12:59:41Z")
ok, thanks for your explanation in detail.. ---
**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 10, 2023, 3:29pm UTC](https://forum.inductiveautomation.com/t/show-tester-stations-for-particular-serial-number-in-flex-repeater-from-memory-tag/73459/26 "2023-05-10T15:29:56Z")
Is there any other possible way to make dummy serial number and under that to create tester status other than connecting it from DB and memory tags ---
**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 10, 2023, 4:42pm UTC](https://forum.inductiveautomation.com/t/show-tester-stations-for-particular-serial-number-in-flex-repeater-from-memory-tag/73459/27 "2023-05-10T16:42:58Z")
If it's gonna be using a database in prod, don't develop it using tags. The simplest thing to do is to set up a dev database, insert dummy data in it, and use that. ---
**Author:** ![zacharyw.larson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/zacharyw.larson/32/23749_2.png) [@zacharyw.larson](https://forum.inductiveautomation.com/u/zacharyw.larson)\ **Post date:** [May 10, 2023, 6:06pm UTC](https://forum.inductiveautomation.com/t/show-tester-stations-for-particular-serial-number-in-flex-repeater-from-memory-tag/73459/28 "2023-05-10T18:06:40Z")
What is your goal of the dummy data or dummy tags? * * * If you are just making dummy tags and dummy data, you can do that in memory tags. Can make your own tags and run scripts on those dummy tags. Can install the an sql server on your computer for testing. [Connecting to Microsoft SQL Server Express Video at Inductive University](https://www.inductiveuniversity.com/video/connecting-to-microsoft-sql-server-express/8.1)] Alternatively, you could write a script that set a tag based on the current minute of the gateway time. ---
**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 17, 2023, 11:16am UTC](https://forum.inductiveautomation.com/t/show-tester-stations-for-particular-serial-number-in-flex-repeater-from-memory-tag/73459/29 "2023-05-17T11:16:08Z")
Now I got connected to the DB, how can I get EOL and IN line tester status from DB by typing the serial number in the text field. ---
**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 17, 2023, 11:18am UTC](https://forum.inductiveautomation.com/t/show-tester-stations-for-particular-serial-number-in-flex-repeater-from-memory-tag/73459/31 "2023-05-17T11:18:58Z")
How can I bring this from DB ---
**Author:** ![lrose](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lrose/32/62724_2.png) [@lrose](https://forum.inductiveautomation.com/u/lrose)\ **Post date:** [May 17, 2023, 12:38pm UTC](https://forum.inductiveautomation.com/t/show-tester-stations-for-particular-serial-number-in-flex-repeater-from-memory-tag/73459/32 "2023-05-17T12:38:22Z")
You will need to create a named query with a parameter to accept the serial number. Then bind your indicators to the result of that query. To help more, I really need to have a better understanding of how you have your view set up. ---
**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 18, 2023, 5:15am UTC](https://forum.inductiveautomation.com/t/show-tester-stations-for-particular-serial-number-in-flex-repeater-from-memory-tag/73459/33 "2023-05-18T05:15:34Z")
![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/0/308376d69ea43bc35dfab4f0c0250450a2183888.png) Here I need to type serial number in the text box and if I click the search icon button or press enter then it should display tester names with their pass, null status like this in below pic .. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/c/2/c21904bdd5c5171d5ae3802f26fbbe5190ddff41.png) Here it should display the pass,null status of the testers from DB tags (left bottom) for that serial number like this... @lrose ---
**Author:** ![lrose](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lrose/32/62724_2.png) [@lrose](https://forum.inductiveautomation.com/u/lrose)\ **Post date:** [May 18, 2023, 3:14pm UTC](https://forum.inductiveautomation.com/t/show-tester-stations-for-particular-serial-number-in-flex-repeater-from-memory-tag/73459/34 "2023-05-18T15:14:15Z")
Since these are on two different views, you will need to use a message handler on your components. I suggest that you use a project script to call the named query and then you can use `system.perspective.sendMessage()` can be used to trigger a message handler on the components with then needed information. See: [https://docs.inductiveautomation.com/display/DOC81/Component+Message+Handlers](https://docs.inductiveautomation.com/display/DOC81/Component+Message+Handlers) and [https://docs.inductiveautomation.com/display/DOC81/system.perspective.sendMessage](https://docs.inductiveautomation.com/display/DOC81/system.perspective.sendMessage) for more information. ---
**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 18, 2023, 4:03pm UTC](https://forum.inductiveautomation.com/t/show-tester-stations-for-particular-serial-number-in-flex-repeater-from-memory-tag/73459/35 "2023-05-18T16:03:11Z")
SELECT TESTERNAME, PASSFAILSTATUS FROM UT\_INTELLIPAK.FPYDPUVIEW WHERE dbid IN (SELECT DISTINCT dbid FROM UT\_INTELLIPAK.uutinfo WHERE value = 'C18L08684') Can this select statement helps us in making it easier? ---
**Author:** ![lrose](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lrose/32/62724_2.png) [@lrose](https://forum.inductiveautomation.com/u/lrose)\ **Post date:** [May 18, 2023, 4:05pm UTC](https://forum.inductiveautomation.com/t/show-tester-stations-for-particular-serial-number-in-flex-repeater-from-memory-tag/73459/36 "2023-05-18T16:05:45Z")
You will need to run that query to get the information from the DB. Construct a named query with that, and then call it to have the data returned. [https://docs.inductiveautomation.com/display/DOC81/Named+Queries](https://docs.inductiveautomation.com/display/DOC81/Named+Queries) ---
**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 21, 2023, 6:53am UTC](https://forum.inductiveautomation.com/t/show-tester-stations-for-particular-serial-number-in-flex-repeater-from-memory-tag/73459/37 "2023-05-21T06:53:49Z")
I've created named query.. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/d/6/d6802ddd8de613f86d395f7532f8de0bc383897c.png) Can you help me, What I should do now for typing the serial number in the text field and by pressing enter button or clicking search icon to get their pass, untested status on another view? I've bind the text field with named query, ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/f/6f8bdb01d1ae221b6a8248dcc9d08a3e02d51fde.png) @lrose ---
**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 21, 2023, 7:16am UTC](https://forum.inductiveautomation.com/t/show-tester-stations-for-particular-serial-number-in-flex-repeater-from-memory-tag/73459/38 "2023-05-21T07:16:22Z")
You _ **really** _ need to look at the Inductive University. Your questions are all answered there and will give you an introduction to working In Ignition ---
**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 21, 2023, 12:03pm UTC](https://forum.inductiveautomation.com/t/show-tester-stations-for-particular-serial-number-in-flex-repeater-from-memory-tag/73459/39 "2023-05-21T12:03:20Z")
![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/0/0/0052945bf3469b32b96c11018d51e0c4c9779dd0.png) This error is occurring, ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/9/194a9830fa50979d4642d94b84d412a90f973a2a.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 21, 2023, 1:03pm UTC](https://forum.inductiveautomation.com/t/show-tester-stations-for-particular-serial-number-in-flex-repeater-from-memory-tag/73459/40 "2023-05-21T13:03:28Z")
> [@Chowmya\_C](#): > > What I should do now for typing the serial number in the text field and by pressing enter button or clicking search icon to get their pass, untested status on another view? - Create a Perspective session variable in the Perspective Property Editor window under SESSION CUSTOM. Call it `sessSerialNum`. This is now, effectively, a global variable accessible to the session. - Create a property binding on the serial number text field. - Bind it to session.`custom.sessSerialNum`. - Make the binding Bidirectional. - Create a named query to retrieve TESTERNAME and PASSFAILSTATUS from the database. - In the WHERE clause use, `WHERE value = :serialNum`. - Set Query Type to 'Query'. - Add a parameter of Type = Value, Name = serialNum, Data Type = Int8. - Test the query on the Testing tab. - On the view where you want to look up the serieal number ... - Create a query property binding on the component. - You will be prompted to add the serialNum parameter. Create a property binding to `custom.sessSerialNum`. * * * **Tips** - Don't capitalise _everything_ in your SQL. It makes it very hard to read. I use lowercase for variables, etc. Some DBs don't allow capitals for column names. - In the forum, paste code, not pictures of code. Format it using the \ button to format it properly. - Use session variables to pass data between views but make sure that you are making a well designed user interface that will work in a similar fashion to Windows / Linux / Mac / Android interfaces that users are familiar with. ---
**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 21, 2023, 4:06pm UTC](https://forum.inductiveautomation.com/t/show-tester-stations-for-particular-serial-number-in-flex-repeater-from-memory-tag/73459/41 "2023-05-21T16:06:09Z")
Well... The error is pretty clear. The `text` property expects... text. And you're giving it a dataset. I suggest you do as Nick said and go through the university. It will teach you the basics, so you don't need to come here and ask for help on every little thing - this is frustrating for us, and it's also very inefficient for you. You shouldn't have to ask for help when the designer clearly tells you what's wrong with what you're doing. The community here is VERY helpful. You'll always find help and tips. But you also need to make an effort to not rely on it for everything. [Previous page](https://forum.inductiveautomation.com/t/show-tester-stations-for-particular-serial-number-in-flex-repeater-from-memory-tag/73459.md?page=1)