Skip to Content (Press Enter)
Back to Ideas
58
Like
Follow Idea
Autocomplete on Foreign Keys to Static Entity
1501Views
16Comments
On our RadarOn our Radar
Service Studio

If you're writing expressions where you're comparing a certain attribute which happens to be a Foreign Key to a Static Entity, then Autocomplete (Ctrl+Space) could show a list of the possible values.


Example: 


How it could be:

01 Mar 2020
Copy link to comment

Good ideia! 

06 Mar 2020
Copy link to comment
Changed the category to
Service Studio
23 Mar 2020
Copy link to comment

Good idea, the code would be cleaner.

09 Feb 2021
Copy link to comment

A no-brainer, have thought of this myself quite often. The expression editor could be a lot smarter than it is currently, and this would be one very welcome improvement.

01 Feb 2023
Copy link to comment
Merged this idea with 'Syntax Completion for Static Entities' (created on 14 Sep 2018 21:22:03 by PJ M)
01 Feb 2023
Copy link to comment
UserImage.jpg
PJ M

In this case, we know the FrequencyId is a Static Entity of PaymentScheduleFrequency, therefore, the Syntax completer could, at the SPACE after the = sign, automatically type for me "Entities.PaymentScheduleFrequency." and let me choose which of those static entities I want in this case.

14 Sep 2018
Copy link to comment

You could be setting it equal to a local value or something else.

But I *would* like to see the right one at the top of the list.

J.Ja

16 Sep 2018
Copy link to comment
Changed the category to
Backend
26 Sep 2018
Copy link to comment

Automatically putting the "right one" at the top would great!

26 Oct 2018
Copy link to comment
Merged this idea with 'Suggested static entity when comparing StaticEntityId with Entities.StaticEntity.Record' (created on 08 Jul 2019 10:52:21 by Xavier Reis)
23 Jul 2019
Copy link to comment

Imagine that I have the static entity BuildingType with records Villa, Office and ParkingLot. If I have an entity with attribute BuildingTypeId, when comparing like:


MyEntity.BuildingTypeId = Entities.StaticEntity.Record


the suggestion default should be BuildingType instead of all other static entities like MenuItem, MenuSubItem, etc.



This comment was:
- originally posted on idea 'Suggested static entity when comparing StaticEntityId with Entities.StaticEntity.Record' (created on 08 Jul 2019 by Xavier Reis)
- merged to idea 'Syntax Completion for Static Entities' on 23 Jul 2019 07:12:07 by Kilian Hekhuis
08 Jul 2019
Copy link to comment

Must have!



This comment was:
- originally posted on idea 'Suggested static entity when comparing StaticEntityId with Entities.StaticEntity.Record' (created on 08 Jul 2019 by Xavier Reis)
- merged to idea 'Syntax Completion for Static Entities' on 23 Jul 2019 07:12:07 by Kilian Hekhuis
08 Jul 2019
Copy link to comment

Makes sense that the IDE should be able to predict this



This comment was:
- originally posted on idea 'Suggested static entity when comparing StaticEntityId with Entities.StaticEntity.Record' (created on 08 Jul 2019 by Xavier Reis)
- merged to idea 'Syntax Completion for Static Entities' on 23 Jul 2019 07:12:07 by Kilian Hekhuis
09 Jul 2019
Copy link to comment

Yes, a common annoyance. With strong typing, this is a no-brainer.



This comment was:
- originally posted on idea 'Suggested static entity when comparing StaticEntityId with Entities.StaticEntity.Record' (created on 08 Jul 2019 by Xavier Reis)
- merged to idea 'Syntax Completion for Static Entities' on 23 Jul 2019 07:12:07 by Kilian Hekhuis
23 Jul 2019
Copy link to comment

This has annoyed me many times, but i never considered this idea before. Funny!


Must have.

04 Sep 2019
Copy link to comment
UserImage.jpg
Francisco Reis
Changed the status to
On our RadarOn our radar

Hello Mariano,

Thank you so much for your idea. 

The IDE group believes it will bring value to all of our community, currently, it is not on our roadmap but we will keep a close eye on it and prioritize it according to the support it gains from the Community.

If you have more ideas, please share them.

Thank you.

02 Feb 2023
Copy link to comment