# Flex Repeater Instances in the property shows Texts values but it doesn't show on the view **URL:** \ **Category:** Ignition\ **Tags:** ignition80\ **Created:** [May 26, 2020, 3:37am UTC](https://forum.inductiveautomation.com/t/flex-repeater-instances-in-the-property-shows-texts-values-but-it-doesnt-show-on-the-view/35030 "2020-05-26T03:37:09Z")\ **Posts on this page:** 17\ **Page:** 1
**Author:** ![rohan.baravkar](https://avatars.discourse-cdn.com/v4/letter/r/ed8c4c/32.png) [@rohan.baravkar](https://forum.inductiveautomation.com/u/rohan.baravkar)\ **Post date:** [May 26, 2020, 3:37am UTC](https://forum.inductiveautomation.com/t/flex-repeater-instances-in-the-property-shows-texts-values-but-it-doesnt-show-on-the-view/35030/1 "2020-05-26T03:37:10Z")
I am trying to show values for the instances with flex repeater and the path is given to another view. on that view I want to get values from the database and when binding the flex repeater instances to names query, I can see those values in the Instances properties and on the view, it showing for example - “Name 1” 3 times instead of different values which are coming from the database. I have a property bound that is used in the query to filter out the result. Am I missing something in the design or is there any bug with Flex repeater? Because I tried all possibilities and went all Ignition articles but no fixes. Please suggest. ---
**Author:** ![cmallonee](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/cmallonee/32/6416_2.png) [@cmallonee](https://forum.inductiveautomation.com/u/cmallonee)\ **Post date:** [May 26, 2020, 4:15pm UTC](https://forum.inductiveautomation.com/t/flex-repeater-instances-in-the-property-shows-texts-values-but-it-doesnt-show-on-the-view/35030/2 "2020-05-26T16:15:05Z")
The Flex Repeater is working correctly in this regard, so it’s likely something is not set up correctly. It sounds like you’re passing a unique parameter value to each instance of the Flex Repeater, with the expectation that the View being instanced will determine the View’s name based on a query. In the following screenshot, I’ve set up a Flex Repeater with two instances which use the path of a View on which there is a param with a key of `id`. The instanced View has a Label which has a property binding which makes use of the View’s `id` param. Note that each instance has its own unique value for `id`, which is placed at the `props.instances[x]` level. ![Screen Shot 2020-05-26 at 9.05.21 AM](https://us1.discourse-cdn.com/inductiveautomation/original/2X/8/81d53d92bc9949ffe3a788c3fd82a20d8924c5cf.png) Make sure also that the param for the instanced View is set to be an “Input” param: ![Screen Shot 2020-05-26 at 9.09.41 AM](https://us1.discourse-cdn.com/inductiveautomation/original/2X/b/b93f4315e1432f592cf0e1251e69d99de206fd29.png) For your specific example, there are a couple of items which could be causing your issue: 1. You are passing the same value to all three instances. 2. You are not passing the param correctly, and so the View is falling back to the default value you’ve supplied; if the View is not supplied the params it expects, it falls back to the default value you’ve supplied (which I’m guessing is probably `1`). ---
**Author:** ![rohan.baravkar](https://avatars.discourse-cdn.com/v4/letter/r/ed8c4c/32.png) [@rohan.baravkar](https://forum.inductiveautomation.com/u/rohan.baravkar)\ **Post date:** [May 27, 2020, 2:19am UTC](https://forum.inductiveautomation.com/t/flex-repeater-instances-in-the-property-shows-texts-values-but-it-doesnt-show-on-the-view/35030/3 "2020-05-27T02:19:12Z")
@cmallonee Thank you for the quick response. I tried this method without query binding and it worked. But I am not able to figure it out with the database information. I have attached some of the screen captures. ![Test_view_Column](https://us1.discourse-cdn.com/inductiveautomation/original/2X/c/c145309e3576dc1e38ce01d1cb442dd392032998.jpeg) ![Flex_repeater_Query_Binding for Instances](https://us1.discourse-cdn.com/inductiveautomation/original/2X/3/35e1fec87426bf0bdb0b386a40240a66360942da.jpeg) ![Tab_view_properties](https://us1.discourse-cdn.com/inductiveautomation/original/2X/3/39f701e51c2153c6f9eaba532ceb761eaa02502d.jpeg) ![Test_query](https://us1.discourse-cdn.com/inductiveautomation/original/2X/9/968f7898ce6a7fba3f2618638185317f912052ad.jpeg) ![books_1](https://us1.discourse-cdn.com/inductiveautomation/original/2X/c/c665658bd89e0e0f43e87b1984fe98e7fb7283a2.jpeg) I am trying to filter the books with an input text field with Author’s First name. I have a column container where I am going to show the Name of the book, Published year, Author’s name, and quantity in Stock, Label for each item. This view I am going to repeat in Tab View using Flex Repeater when the user wanted to find out about a specific author name. So, I am not understanding how I am going to bind instances with as per user input and because instances will not be constant, this will be bound with the query with parameter coming from the external text field. Thank you. -Ron ---
**Author:** ![cmallonee](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/cmallonee/32/6416_2.png) [@cmallonee](https://forum.inductiveautomation.com/u/cmallonee)\ **Post date:** [May 27, 2020, 2:51pm UTC](https://forum.inductiveautomation.com/t/flex-repeater-instances-in-the-property-shows-texts-values-but-it-doesnt-show-on-the-view/35030/4 "2020-05-27T14:51:22Z")
Everything you’ve posted looks fine except for the most important part, which you didn’t post! Your Flex Repeater looks correct and has the correct data, so the fault must be in the binding on the View. In the View with the Column layout, you have a Label with a binding on `props.text`. That binding is what I need to see. That binding should be against the `view.params.title` property. ![Screen Shot 2020-05-27 at 7.49.42 AM](https://us1.discourse-cdn.com/inductiveautomation/original/2X/9/90d038ce59571eeb8f72fd79c017d48067844a4a.png) ---
**Author:** ![rohan.baravkar](https://avatars.discourse-cdn.com/v4/letter/r/ed8c4c/32.png) [@rohan.baravkar](https://forum.inductiveautomation.com/u/rohan.baravkar)\ **Post date:** [May 28, 2020, 3:14am UTC](https://forum.inductiveautomation.com/t/flex-repeater-instances-in-the-property-shows-texts-values-but-it-doesnt-show-on-the-view/35030/5 "2020-05-28T03:14:24Z")
Thank you @cmallonee for your help. It worked as you suggested! 🙂 👍 ---
**Author:** ![rohan.baravkar](https://avatars.discourse-cdn.com/v4/letter/r/ed8c4c/32.png) [@rohan.baravkar](https://forum.inductiveautomation.com/u/rohan.baravkar)\ **Post date:** [May 29, 2020, 3:21am UTC](https://forum.inductiveautomation.com/t/flex-repeater-instances-in-the-property-shows-texts-values-but-it-doesnt-show-on-the-view/35030/6 "2020-05-29T03:21:04Z")
@cmallonee one issue came up when I tried to show time on those Flex repeater and it is showing integer value ‘1,561,493,696,000’. When I bind this flexrepeater view (Column View) with a query I kept JSON settings so that I get instances from the database. is there any I can get values in this format “2020-05-12 10:02:40”? Thank you. - Ron ---
**Author:** ![cmallonee](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/cmallonee/32/6416_2.png) [@cmallonee](https://forum.inductiveautomation.com/u/cmallonee)\ **Post date:** [May 29, 2020, 3:36pm UTC](https://forum.inductiveautomation.com/t/flex-repeater-instances-in-the-property-shows-texts-values-but-it-doesnt-show-on-the-view/35030/7 "2020-05-29T15:36:03Z")
The easiest way is going to be to cast that value by using an Expression. Assuming you’re using a Label to display this date and your View’s param is called `t_stamp`, configure your binding like so: Bind `Label.props.text` to `self.view.params.t_stamp`. Add an expression transform: `toDate({value})` ---
**Author:** ![rohan.baravkar](https://avatars.discourse-cdn.com/v4/letter/r/ed8c4c/32.png) [@rohan.baravkar](https://forum.inductiveautomation.com/u/rohan.baravkar)\ **Post date:** [May 30, 2020, 1:51pm UTC](https://forum.inductiveautomation.com/t/flex-repeater-instances-in-the-property-shows-texts-values-but-it-doesnt-show-on-the-view/35030/8 "2020-05-30T13:51:15Z")
I tried this one too but it is giving me error. But if I put toDate({value},0), it is giving me a value in date and time format but it is like Fail-over Value which means constant value. ![PropertBindingOnLabel_with0](https://us1.discourse-cdn.com/inductiveautomation/original/2X/3/3e739c00718e5f0aae92a09e59d15c10d7304af6.jpeg) ![Error_on_ColumView_Label](https://us1.discourse-cdn.com/inductiveautomation/original/2X/a/a35986d3fea23195b898952d5f21ef3fce6d66e9.jpeg) ![Time_Property_Binding](https://us1.discourse-cdn.com/inductiveautomation/original/2X/b/bca7e24975d2229c913c29d5ad23b0885cf3a996.jpeg) ---
**Author:** ![cmallonee](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/cmallonee/32/6416_2.png) [@cmallonee](https://forum.inductiveautomation.com/u/cmallonee)\ **Post date:** [May 30, 2020, 7:11pm UTC](https://forum.inductiveautomation.com/t/flex-repeater-instances-in-the-property-shows-texts-values-but-it-doesnt-show-on-the-view/35030/9 "2020-05-30T19:11:57Z")
That’s because the default value you have for the `Time` param is a string (“value”) which the expression can’t cast to a date. Consider changing the `Time` param to have a default date as a placeholder, or check the Overlay Opt-Out checkbox. Applying that checkbox will result in the Label not displaying the overlay and will also result in the Label displaying `null` until the binding and transform are able to execute to completion. If you’d like the Label to display no value until a valid value is supplied, you could use the following setup: ![Screen Shot 2020-05-30 at 12.05.54 PM](https://us1.discourse-cdn.com/inductiveautomation/original/2X/d/dbfae22e9a4238c71772f7f30d290eb291c0b038.png) ---
**Author:** ![rohan.baravkar](https://avatars.discourse-cdn.com/v4/letter/r/ed8c4c/32.png) [@rohan.baravkar](https://forum.inductiveautomation.com/u/rohan.baravkar)\ **Post date:** [June 8, 2020, 5:19pm UTC](https://forum.inductiveautomation.com/t/flex-repeater-instances-in-the-property-shows-texts-values-but-it-doesnt-show-on-the-view/35030/10 "2020-06-08T17:19:39Z")
Hi @cmallonee I configured this way, but this is configuration still not helping me what I am looking for. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/b/b87e29d6f4211e8982b3ea641a21bc0c73dd63b9.png) It’s giving me repeated DateTime values on the Flex Repeater screen which is ‘2020-05-28 23:21:41’. Please let me know what I am missing in the config. Thank you. ---
**Author:** ![cmallonee](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/cmallonee/32/6416_2.png) [@cmallonee](https://forum.inductiveautomation.com/u/cmallonee)\ **Post date:** [June 8, 2020, 5:30pm UTC](https://forum.inductiveautomation.com/t/flex-repeater-instances-in-the-property-shows-texts-values-but-it-doesnt-show-on-the-view/35030/11 "2020-06-08T17:30:49Z")
That’s what it’s giving you because that’s what your’re telling it to supply when an actual timestamp isn’t supplied. Your Binding is interpreted as "Bind against `view.params.Assigned_Date`, but cast that value which could be almost anything as a Date type value. If casting fails, return a value of ‘2020-05-28 23:21:41’ ". What you’re encountering is that you’re not supplying the param, so the cast is failing, so you’re receiving the hard-coded date you supplied. If the date param is not found or is not supplied, what value DO you want displayed? Do you want NO date? ---
**Author:** ![rohan.baravkar](https://avatars.discourse-cdn.com/v4/letter/r/ed8c4c/32.png) [@rohan.baravkar](https://forum.inductiveautomation.com/u/rohan.baravkar)\ **Post date:** [June 8, 2020, 5:39pm UTC](https://forum.inductiveautomation.com/t/flex-repeater-instances-in-the-property-shows-texts-values-but-it-doesnt-show-on-the-view/35030/12 "2020-06-08T17:39:38Z")
Yes, I want to display " NO DATE" if there is not DateTime or “null” values in the database. I am binding that that Label Text property to the View parameter - ‘Assigned\_Date’ which is acting as Input. And that parameter in the Flex Repeater is taking values from the Database but it is showing in the following format - “1,561,503,166,000” or “null”. ---
**Author:** ![cmallonee](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/cmallonee/32/6416_2.png) [@cmallonee](https://forum.inductiveautomation.com/u/cmallonee)\ **Post date:** [June 8, 2020, 5:49pm UTC](https://forum.inductiveautomation.com/t/flex-repeater-instances-in-the-property-shows-texts-values-but-it-doesnt-show-on-the-view/35030/13 "2020-06-08T17:49:22Z")
If you want it to display “NO DATE”, then change the return value in your script from the hard-coded date to “NO DATE”. ---
**Author:** ![rohan.baravkar](https://avatars.discourse-cdn.com/v4/letter/r/ed8c4c/32.png) [@rohan.baravkar](https://forum.inductiveautomation.com/u/rohan.baravkar)\ **Post date:** [June 8, 2020, 5:57pm UTC](https://forum.inductiveautomation.com/t/flex-repeater-instances-in-the-property-shows-texts-values-but-it-doesnt-show-on-the-view/35030/14 "2020-06-08T17:57:41Z")
![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/1/11b53995f43e5b9b979fd68e71fb61d4300e228c.png) ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/c/c7765e264c2ab9c59762af52f9284355d3d07bf1.png) So, it’s still not converting values “1,561,503,166,000” to DateTime format. the expression in the binding still failing and giving me “NO DATE” Values. ---
**Author:** ![cmallonee](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/cmallonee/32/6416_2.png) [@cmallonee](https://forum.inductiveautomation.com/u/cmallonee)\ **Post date:** [June 8, 2020, 6:00pm UTC](https://forum.inductiveautomation.com/t/flex-repeater-instances-in-the-property-shows-texts-values-but-it-doesnt-show-on-the-view/35030/15 "2020-06-08T18:00:06Z")
Because `Assign_Date` - which is what you’re supplying as a param - is not the same as `Assigned_Date` - which is what you’re binding against. ![Screen Shot 2020-06-08 at 10.59.55 AM](https://us1.discourse-cdn.com/inductiveautomation/original/2X/2/251c8873d753444d703a41968821185d08b17532.png) ![Screen Shot 2020-06-08 at 11.00.03 AM](https://us1.discourse-cdn.com/inductiveautomation/original/2X/d/dcf9af659346a20c4c84f5da60240665fd981fe6.png) Fix your binding. ---
**Author:** ![rohan.baravkar](https://avatars.discourse-cdn.com/v4/letter/r/ed8c4c/32.png) [@rohan.baravkar](https://forum.inductiveautomation.com/u/rohan.baravkar)\ **Post date:** [June 8, 2020, 6:05pm UTC](https://forum.inductiveautomation.com/t/flex-repeater-instances-in-the-property-shows-texts-values-but-it-doesnt-show-on-the-view/35030/16 "2020-06-08T18:05:45Z")
Oh okay. I got it. Thank you so much @cmallonee for your support and bearing with me! Have a great day! ---
**Author:** ![cmallonee](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/cmallonee/32/6416_2.png) [@cmallonee](https://forum.inductiveautomation.com/u/cmallonee)\ **Post date:** [June 8, 2020, 6:06pm UTC](https://forum.inductiveautomation.com/t/flex-repeater-instances-in-the-property-shows-texts-values-but-it-doesnt-show-on-the-view/35030/17 "2020-06-08T18:06:09Z")
Happy to help.