Display all records of a TE after a filter

[Lotfi 0]

Hello everyone,
 
I have two questions:

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

 

Thank you
 

Edited October 30, 2015 by Lotfi

[GisMo 7]

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 October 30, 2015 by GisMo

[comment 1,711]

1/ How to display all  records of a TO after a 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.