IKs there a way to filter and order the in non-saved entities?

Question

I would like to know if there is a simple way to filter and order the non-saved entities, because when you are in a grid the New records are not affected by filters or orders :(

Thanks

---

SebaXOR

Answer 1

Hi sebaxor,

Now i'm not entirely sure what you are asking, but i think the answer might be on of these 2:

Now the first on is that when you import a database table from your database you can change the properties of you table and the display name etc. While doing that you can lets say you want to put the country flag on top of the list so that it shows as the first item in a default "detail" screen, like the ones that pop up when you make an entity into a link. the order that you leave the entities in the database table after editing the everything will also be the default order that your details show up in on a newly created screen.

The second is that you can by right-clicking the databasetable choose to create a query. In this query you can set a filter, or a method of sorting. After creating such a query, you may when creating a new screen, base the new screen on not only the database table but also on the query, which makes the selected sorting and/or sorting the default sorting of you new screen.

i hope this was helpful

Abuggie

Answer 2

Is not none of them...

Look, do this

1. Create a Table with 3 or 4 fields type string

2. Create an editable grid Screen with the entity

3. Run the app and add 3 entities with wathever, Save.

4. Refresh, filter and order (When enable) it works fine

5. Add 2 more entities... try to order or filter.. the saved entities will work fine, but the new non-saved ones won't, the will be there being unaffected by filters or orders, 

I know this happends because LS goes to the server, do the query and returns the list of elements.. not considering the ones that are not in the database... but my question is... is there a way to make this non-saved elements to be affected by queries and orderns??

Thanks

---

SebaXOR

Answer 3

No, there's not.

---

Yann - LightSwitch Central - Click here for FREE Themes, Controls, Types and Commands

If you find a reply helpful, please click "Vote as Helpful", if a reply answers your question, please click "Mark as Answer"

By doing this you'll help people find answers faster.