Jump to content
  • 0

Filtration Criteria


Go to solution Solved by sandy159,

Question

Hi

I am building a view from two tables. I have joined them correctly but I am not build the "Where Condition" filtration criteria on a date field. The interface doesn't provide any help

Basically,  I want to build this criteria

Select all records ( from the joined tables) Where Work_Date is blank  or Work_Date is not today's date

the problem is that it wants me to hardcode  today's date ; this will work for today and tomorrow my query will be useless

Is their a way to do it

Capture.PNG

Link to post
Share on other sites

5 answers to this question

Recommended Posts

  • 0
  • Solution

Hi @myName,

If I understood you correctly, you want to filter the records where Work_Date is blank  or Work_Date is not today's date.

Here is a workaround that I found.

You may add a Difference field in the Table and populate it with the Application Task. Then use this field to Filter the needed records in View.

Table (Difference - Number data type):

image.png

The Task can be set up to run every day and update the Difference field. Basically, it checks the difference in days. If it is today- then difference will be equal to 0.

image.png

In the View you may filter all the records where Difference field is not equal to 0.

image.png

Hope this helps!

Link to post
Share on other sites
  • 0

Thank you very much

I have tested the proposed solution

I need to filter out all records that match todays date. It looks like "Before Now and After Now" take  into consideration the time. So it will be evaluated to true if there is a record in the database before a second ago

an equivalent  Pseudocode sql statement would look similar to the following

Select *  from the joined result where Work_date  is NULL or work_date not equal to todays date

Thanks again

Link to post
Share on other sites
  • 0

Hi @sandy159 

Thank you very much for the detailed answer. I have read the details and I believe it is a correct solution (workaround).

Unfortunately, I was not able to try it out since my account is an education account and Tasks are not available in this current plan.

Thanks again

Ahmed

 

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...