filterLogData ( ultraLogField ; fieldName )

Return rows from the UltraLog LogData field for changes to a specific field.

Be the first to rate this function Log in to vote

Josh Ormond - Show more from this author
Iozax, LLC
http://iozax.com

Sample input:

filterLogData ( people::LogData ; "firstName" )

Sample output:

1/3/2019 9:55:09 AM jormond firstName L -» Luke
1/2/2019 3:01:47 PM cdoe firstName Lucas -» L
1/2/2019 7:25:27 AM ovale firstName [---] -» Lucas

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

/*************************************** 
*
*	Function Name:		filterLogData ( logField ; field )
*	Parameters:		ultraLogField  = Fully Qualified field name of the LogData field used by UltraLog.
*					fieldName = the name of the field to filter for. For example if looking for changes to the Price field, enter "Price".
*
*	Dependencies:		CustomList ( ) custom function by Agnes Barouh. https://www.briandunning.com/cf/868
*
*	Purpose:			Return rows from the UltraLog LogData field for changes to a specific field.
*
*	Notes:			Special thanks to Nightwing Enterprises and Ray Cologon for releasing UltraLog.
*
*	Change log:		2019-01-02 Josh Ormond 
*						- Initial build.
*
*					2019-01-17 Josh Ormond ( thank you Jerry Salem, Josh Willing, and Kevin Frank )
*						- added a switch for when a space preceeds the field name in the log.
*						- vertical list of fields in the UltraLog function generates an extra character in the log.
*						- converted variables back to calculation variables, except as needed by Custom List.
*						- cleaned up the local variables to avoid collisions outside of the function.
*
*****************************************/

Let ( 

[

theField = GetFieldName ( ultraLogField ) ;
$_ul_theLog = GetField ( theField ) ; 
theSearchField = fieldName ; 

$_ul_theSearch = 
	Case ( 

		Position ( $_ul_theLog ; "	" & theSearchField & "	" ; 1 ; 1 ) > 0 ; 
			"	" & theSearchField & "	" ; 

			"	 " & theSearchField & "	" 
	
	) ;

theValueCount = PatternCount ( $_ul_TheLog ; $_ul_theSearch ) ; 

thePosString = Evaluate ( Quote ( "Position ( $_ul_theLog ; $_ul_theSearch ; 1 ; [n] )" ) ) ;
$_ul_pos = CustomList ( 1 ; theValueCount ; thePosString ) ; 

theValuePositionString = Evaluate ( Quote ( "ValueCount ( Left ( $_ul_TheLog ; GetValue ( $_ul_pos ; [n] ) ) )" ) ) ;
$_ul_ValuePosition = CustomList ( 1 ; theValueCount ; theValuePositionString ) ; 

theValueString = Evaluate ( Quote ( "GetValue ( $_ul_TheLog ; GetValue ( $_ul_ValuePosition ; [n] ) )" ) ) ;
theValue = CustomList ( 1 ; theValueCount ; theValueString ) ; 


result = theValue ; 

// Clean up the variables used for CustomList
$_ul_TheLog = "" ; 
$_ul_theSearch = "" ;  
$_ul_pos = "" ; 
$_ul_ValuePosition = "" 

] ; 

result

)

Return rows from the UltraLog LogData field for changes to a specific field.

Comments

		Josh Ormond, Iozax, LLC Feb 21, 2019
I have found that depending on how you list the fields using the UltraLog function, it will affect the characters used between the fields. If you find something not working, post a sample of the text you have in your log field, and I can make an adjustment to how the function works.

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

filterLogData ( ultraLogField ; fieldName )

Comments

Support this website.

Support this website.