topic Re: Sorting a Field using the ID of another Field in App Development

Sorting a Field using the ID of another Field

bmac1 — Wed, 11 Dec 2024 16:13:41 GMT

Let's say I have two similar fields: Product and Product_2.

PRODUCT	PRODUCT_2
B	B
D	D
A	A
F	F
C	C
G
H

Product has an associated #Product_ID used as the sort order [ex: A=1, B=2, C=3...]

Is there a way using sort order expression to sort Product_2 by #Product_ID, even though there is no backend relationship? Assume any value in Product_2 will be available in Product.

Re: Sorting a Field using the ID of another Field

Kushal_Chawda — Wed, 11 Dec 2024 16:57:30 GMT

@bmac1 try using dual(). Try using below expression in expression sort

= dual(Product2,ProductID)

Re: Sorting a Field using the ID of another Field

bmac1 — Wed, 11 Dec 2024 17:57:00 GMT

Returns null

Re: Sorting a Field using the ID of another Field

NoahF — Wed, 11 Dec 2024 19:57:32 GMT

Hi @bmac1 ,

you could just Map the #Product_ID onto your Product_2 as a "Sorting_ID".

Then use this Sorting_ID in your sort expression.