Skip to Content (Press Enter)
2022-04-19 10-22-17
MFR
31Views
5Comments
static entity ID
Discussion
How-to
Static entities used it in other entities, if I haven't assign a record on the other entity, the ID for the static entity should be nullidentifier. The thing is that somestimes I get 0 instead of nullidentifier(). Can anyone help me on this unexpected behavior.

 
0
0
22 May 2015
Copy Link
2017-07-05 18-13-21
Tiago Neves
Hi,

In OutSystems Platform there is no NULL, its equivalent is 0 or 1900-01-01 for dates.
When you say you get 0 sometimes, instead of nullidentifier(), what do you mean: where are you seeing this? While debugging?
0
0
22 May 2015
Copy Link
2022-04-19 10-22-17
MFR
I want to adapt a web block using an ID of a static entity (NullIdentifier, Record1, Record2, etc). When i compare it to nullidentifier() it doesn't work. I made a query to the atribute and it is 0, Even tougth I haven't assigned to any record of the static entity table so it should null. Did I make it clear? Thanks.
0
0
22 May 2015
Copy Link
2015-04-10 17-57-05
Pedro Coelho
 
MVP
Can you attach an example of your description?

BTW this should be in the Technology & Integration Forum, not Guides & How-Tos

Best regards,
PC
0
0
22 May 2015
Copy Link
2022-04-19 10-22-17
MFR
Now i understand the problem. The thing hapens when doing an advance query with an input parameter in the where clause. When the input parameter is nullidentifier() the query doesn't work. If I use an aggregate with the same parameter and used the same way in the filter (equivalent to the where clause) the query works fine. Don't know how to do the same query in advance query. Can any one help me?
0
0
26 May 2015
Copy Link
2017-07-05 18-13-21
Tiago Neves
Are you using a query parameter in the SQL and passing nullidentifier() as argument?
What exactly do you have in your SQL for that where clause?
0
0
02 Jun 2015
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.