Skip to Content (Press Enter)
OutSystems.com
Personal Edition
Community
Support
Training
Training
Online Training
Developer Schools
Boot Camps
Certifications
Tech Talks
Documentation
Documentation
Overview
ODC
O11
Forums
Forge
Get Involved
Get Involved
Jobs
Ideas
Members
Mentorship
User Groups
Platform
Platform
ODC
O11
Search in OutSystems
Log in
Get Started
Back to Forums
Mark
0
Views
4
Comments
Auto Filter
Question
How do you automatically filter out results of a list view so some results never show up? I have a column labeled "arequest" and if the data in the field is "No" then I do not want that result to ever be visible in the list view.
Thanks,
Mark
Sérgio Oliveira
Staff
Hi Mark,
if i understood the question you want filter only the results of the list where the data in the "arequest" field is different from "No". So you can do that filtering on the query that fills the list, adding a condition like this :
" where Entity.arequest <> 'No' "
This way the records with value "No" will never be shown on the list view.
Hope it helps,
Regards
Sérgio Oliveira
Mark
Hi Sergio,
So if I open the main flow, click on the webpage down arrow, and open the preparation screen, I would double click on the main (and only in my case) "get deal" query....(START ----->GET DEAL------->End). It opens up the standard query screen. I then created a new condition and wrote in
where dealname.arequest <> 'No'
(where Entity.arequest <> 'No' )
It gives me an error, am I off a littel bit here..?
Thanks,
Mark
Sérgio Oliveira
Staff
Hi Mark,
can you specify the error?
i suppose that you are using a simple query, in this case you should add a new condition, like you said and put only
dealname.arequest <> "No"
regards,
Sérgio Oliveira
Mark
I copied and pasted that exactly and it worked!
Thanks So Much!
Mark
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
See the full guidelines
Loading...