I tried to use the gorup function inside a view to get like records to display together. When I go through the returned list, not all of the records are showing up in the same place. In this example, I am grouping by a field called Applies to branch.
When I look at the results on the view, it doesn't appear to be grouping them correctly as there are multiple groups with the same value.
It seems pretty straight forward. Do I have something setup incorrectly?
Hi Jason,
Can you please check the IDs of branch 0255? I'm suspecting these branches are 2 different records with the same record name (e.g. 0255, 0202).
Thanks,
Godfrey
What is type of "Applies to branch" field?
It is a picklist field.
Do you have duplicate values in your picklist?
no
Hello,
I cannot replicate the issue in 3.0.2. May I know what version you're using? Can you try creating a view with only the grouping function enabled? remove the sorting and other filters etc. You cannot add duplicate values in a pick list field either.
Thank you,
Gian
Is this an OE service object? Also, please create a formula on quicklist object with the below formula body:
"{!yourPicklistField#id} => {!yourPicklistField#code} => {!yourPicklistField#value}"
Then, include it in the original view which you posted earlier.
The formula will display the system IDs of the picklist fields.
Have you tried unloading the zone?
Note: Unloading a customer tenant from the production cache will log out all users currently logged into that tenant, including any API sessions.
Also, can you provide me the query log for this tenant? I will be using it to compare the results from my private instance. You can filter the results of this log from the master zone via System Console -> System -> Debug. Simply provide the object definition ID of quicklist object.
PHONE: 781.280.4904
MOBILE: 774.922.2758
TWITTER: @RobOnProducts
Flag this post as spam/abuse.
In theory there shouldn't be. These are values being pulled from our ERP and are all coming from the same table in the DB. I guess it is possible something in our query and transfer process is adding them. I'll see if I can get the data out in a way I can look at it.
Hi Jason,
Were you able to check if there are errant spaces in some of the values that are being grouped?
Thanks,
Godfrey