You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Currently if you try to add Query.selectField('FORMAT(Amount) Amount') the Query formating fails on: checkFieldLevelSecurity(Schema.SObjectType objType, String fieldPath) because it tries to get the whole String from fieldMap.
FunctionFieldTuples are supported only in aggregate queries.
Either there should be regexp that would support FORMAT() in checkFieldLevelSecurity or there should be some more advanced mechanism to allow FunctionFieldTuples in non-aggregation queries ... though SOQL supports only FORMAT() as function call in non-aggregation queries?
What do you think?
Cheers,
O.
The text was updated successfully, but these errors were encountered:
Hi @aranwe, I think we should allow FunctionFieldTuple in non-aggregation queries. Actually, I believe if we add a function that does functionFieldList.add(new FunctionFieldTuple('FORMAT', field, alias)), it will work. It's just the method name formAggregateString creates confusion and makes people think FunctionFieldTuple are only used in aggregation queries. So it'd be better if we rename the method name also.
Oh, you're right, I haven't noticed that the formAggregateString is called in all Query Strings (as long as there are functionFields). Thought there was separate method for aggregation queries and normal for some reason. :)
Then yeah, it makes sense.
I can create PR but in ~a month, I'll be OOO, if anyone feels like playing with it - go ahead :)
Currently if you try to add
Query.selectField('FORMAT(Amount) Amount')
the Query formating fails on:checkFieldLevelSecurity(Schema.SObjectType objType, String fieldPath)
because it tries to get the whole String from fieldMap.FunctionFieldTuple
s are supported only in aggregate queries.Either there should be regexp that would support FORMAT() in checkFieldLevelSecurity or there should be some more advanced mechanism to allow FunctionFieldTuples in non-aggregation queries ... though SOQL supports only FORMAT() as function call in non-aggregation queries?
What do you think?
Cheers,
O.
The text was updated successfully, but these errors were encountered: