Platform
Learn
Community
Support
Partner Center
Sign up
or
Log in
logout
Account Settings
Profile
messages
Messages
logout
Logout
Platform
Home
Downloads
IPP
Licensing
Project Sizing
Learn
Training
Documentation
Evaluation Guide
What's New
Community
Home
Forums
Forge
Ideas
Members
Support
Partner Guide
Resources Library
Opportunities
Account Management
Sign up
or
Log in
Home
Forums
Forge
Ideas
Members
Dear ,
What would improve your OutSystems Community experience? Let us know by taking this 2-minute survey.
Pick up the survey
Community
›
Forums
›
Technology & Integration
Filter by "Not Like" in Aggregate
Community
›
Forums
›
Technology & Integration
Filter by "Not Like" in Aggregate
New Post
New Post
Karen McCarthy
Posted on 2016-04-14
Karen McCarthy
Rank: #1469
Posted on 2016-04-14
I am able to filter by "like" in an aggregate. This statement works:
AuditRequest.Attribute like "%Id%"
I am not able to use "not like". This statement causes an "Unexpected 'not' in expression" error:
AuditRequest.Attribute not like "%Id%"
What syntax should I use in an aggregate to filter by not like?
Thanks.
Carlos Henriques
Posted on 2016-04-14
Carlos Henriques
Rank: #50
Posted on 2016-04-14
Solution
You cannot use the "not like" operator in Aggregates:
http://www.outsystems.com/help/servicestudio/9.1/index.htm#t=Language_Reference%2FExpressions%2FExpression_Operators.htm
You can use it within a SQL element if you must use the Not Like expression.
Solution
Karen McCarthy
Posted on 2016-04-15
Karen McCarthy
Rank: #1469
Posted on 2016-04-15
Solution
I discovered that you can use "not" with "like". Instead of "not like", use not(...like...)
Here is an example:
not(AuditRequest.Attribute like "%Id%")
Solution
Kilian Hekhuis
mvp_badge
mvp_label
Posted on 2016-04-19
Kilian Hekhuis
mvp_badge
mvp_label
Rank: #9
Posted on 2016-04-19
Solution
Thanks for the tip Karen, very useful!
Solution
Quick Reply
attachment
Choose File
No file chosen
Submit
Login to reply
New Post
Available Forums
Technology & Integration
News and Announcements
Forge Discussions
Meta
Community Quick Guides
Usability
Installation Troubleshooting
Personal Environment Troubleshooting
Forum Notifications
Email Digest Settings
Loading...