I am filtering a portal where one method works and other other does not. 

 

WORKS

Case (
	IsEmpty ( table::globalTextField ) ; db_payment::id > 0 ;

	PatternCount ( table::globalTextField ; "/" ) > 1 ; 
	db_payment::date = GetAsDate ( table::globalTextField ) ;

	db_payment::invoice =  table::globalTextField or
	PatternCount ( db_payment::reference ; table::globalTextField ) > 0
)

 

 

DOES NOT WORK  

line 1 and 2 of case work but not line 3 

Let ( [
		txt = GetAsText ( table::globalTextField ) ;
		num = GetAsNumber ( table::globalTextField ) ;
		dte = GetAsDate ( txt ) ;
		dt = PatternCount ( txt ; "/" ) > 1
	] ;

	Case (
		IsEmpty ( txt ) ; db_payment::id > 0 ;
		dt = 1 ; db_payment::date = dte ;
		db_payment::invoice = num  or PatternCount ( db_payment::reference ; txt ) > 0
	)

)

 

I have simplified examples but ultimately I would prefer a Let function to allow for further options in my filter

 

Portal_filter_with_Let_function.zip

Edited September 15, 201510 yr by rivet

What is filter? It's not a field, and it's not defined as a variable.

oops, It is a global text field, I have modified the original post

I just attached a sample file to original post

Edited September 15, 201510 yr by rivet