[Location] Id not Integer

[Location] Id not Integer

  
Forge Component
(9)
Published on 9 Oct by Labs
9 votes
Published on 9 Oct by Labs

Hi everyone,

We are using this component and we are puzzled about the reason of the Country Entity to have a Id as Text. This implies difficulties in using it on queries.

We are using Code instead. However having a Numerical Id would be easier.

Solution

Hello Helena :)

I really don't know why the team that created the Location decide to use the International Country Code as the identifier. IT is possible, as each country has a unique code, and an application is not meant to create countries, so the fact it is a TEXT identifier should not have impact.

While I agree that a numerical identifier would be simples, could I ask what type of problems are you facing with the identifier?

If you need to compare against NULL (like in a LEFT joining, for example), you can use NullTextIdentifier().

Cheers.

Solution

Hi Eduardo :-)! My problem exactly!