Filters on Record Type data by its length

Question

Hi, 
 I am using a Record Type, and it has years of existing data. Unfortunately, the active data is identified by the length of the column name "uniqueFieldId", which is a text value so there is no consistency. Note, this is not a primary key in the table. T he active field length must be 5 characters long . Anything greater or less is not considered active. Since it has years of existing data, we do not want to insert a new column, as I was thinking the easiest solution would be run a sql inserting an isActive column and then running the filter on it. 
 Now, my requirement is to use a record type, and filter the data. I am unsure how I can use record filters to ignore data by the length of the characters in the uniqueFieldId. 
 The record type is then being used in a readonly grid. A gist of the code below, the aggregation below is necessary as there are other fields and calculations I am doing using relationships to this record type. 
 
 In a gist, is there a way, I can filter a column data by its length. 
 
 Code - 
 
 a!queryRecordType( 
 recordType: recordType!DataTest, 
 fields: { 
 a!aggregationFields( 
 groupings: a!grouping( 
 field: recordType!DataTest.Relationship.DataTest2.UniqueFieldId, 
 alias: "UniqueFieldId" 
 ) 
 ) 
 } 
 )

Mathieu Drouin · Accepted Answer

Create a custom record field and use the len() function on the field you want to calculate the length of. You can then create a query to filter on a specific length.

Mathieu Drouin · Answer

Adding a filter on the related record type doesn't work? 
 a!queryRecordType(
 recordType: recordType!recordTypeD,
 filters : {
 a!queryFilter(
 field: recordType!recordTypeD.relationships.recordTypeA.fieldLength,
 operator: "=",
 value: <value>
 )
 },
 pagingInfo: a!pagingInfo(1, 5000) 
)

Mathieu Drouin · Answer

Yeah, you won't be able to filter it out on a source filter which does not give you access to the custom record fields. But it is available if you do a query.

Filters on Record Type data by its length

Top Replies