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. The 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"
)
}
Discussion posts and replies are publicly visible
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.
Thanks Mathieu, but I am facing restrictions using the queryfilter. The custom field value does not populate while I try creating a Source record filter. So unable to put a source filter. And I am also getting a pink screen while I try filtering it on the a!queryRecordType, says that the filters does not exist on the queried record type. Only fields from the queried record type are allowed to be filter. Would you know what I am missing ?
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.
Hmm okay, but I am using recordTypeD and the data in question is in recordTypeA. recordTypeD is the main queryRecordType and there are relationships, groupings and measures which I have defined for it to be used in a readOnly grid. I am unsure how I can query the field value and avoid displaying the complete row based on this length condition.
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) )
Actually it worked today! I am unsure why it kept giving me the pink screen yesterday. I was trying to do the same. It kept giving me the error, unsure if it was maybe not synced, I am unable to reproduce the error - "a!queryRecordType, the filters does not exist on the queried record type. Only fields from the queried record type are allowed to be filter"
Anyways, thank You for the help Mathieu!