Jump to content

Display all records of a TE after a filter


This topic is 1713 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

Hello everyone,
 
I have two questions:

1/ How to display all  records of a TO after filter;
 
2/ How to update the field Number of sanctions according to the filter dates.

 

Thank you
 

30-10-2015 11-50-42.jpg

Edited by Lotfi
Link to post
Share on other sites
  • Replies 2
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Posts

That's a very confusing question. If you have a filter, then why - or under what conditions -  do you want to display all records?   If that field is a summary field, defined in the child table, pl

Posted Images

Are you using a portal filter or a filter on the TO itself?

If you're creating a portal filter and want to show all records, you can use an IF statement within a let like this(you will need to adjust the variables and fields):

Let(

[

dateStart = if(isempty($startDate)=1;date(1;1;1901);$startDate);
dateEnd = if(ismpty($EndDate)=1;date(12;31;2900);$endDate)

];

dateField >= dateStart And dateField<=dateEnd;

)

 

You can add your sanctions filter logic into this Let statement as well 

Edited by GisMo
Link to post
Share on other sites

1/ How to display all  records of a TO after filter;

That's a very confusing question. If you have a filter, then why - or under what conditions -  do you want to display all records?

 

2/ How to update the field Number of sanctions according to the filter dates.

If that field is a summary field, defined in the child table, place it in a one-row portal to the same TO and with the same filter as your existing portal.

 

dateStart = if(isempty($startDate)=1;date(1;1;1901);$startDate);
dateEnd = if(ismpty($EndDate)=1;date(12;31;2900);$endDate)

Filemaker can handle dates in the range from Jan 1, 0001 to Dec 31, 4000.

  • Like 1
Link to post
Share on other sites

This topic is 1713 days old. Please don't post here. Open a new topic instead.

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
Reply to this topic...

×   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.


×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.