Data Manager Field Sort Order Issues on Front End Sheet

Delestia — Tue, 13 Oct 2020 22:13:25 GMT

Hello All,

I am trying to use the data manager to sync my tables and then sort my field by 'Open', 'Working', then 'Closed' however whenever I use the Order tab in the field manager it changes my values to '?' in the sheet views. Example load script below. I am loading in a dual field which has repeating values due to another business constraint. Example tables below.

SOURCE A
Status_ID	Display
1	Open
2	Open
3	Working
4	Working
5	Closed
6	Closed

SOURCE B
Item	Item Status	User ID
A	1	4326
B	2	4326
C	3	4326
D	4	4211
E	5	4211
F	6	4211
G	1	4875
H	2	4875
J	3	4875

[tmp_Status]: LOAD DUAL(Display, Status_ID) AS [Item Status] FROM SOURCE A; [tmp_Main]: LOAD * FROM SOURCE B; DROP TABLE [tmp_Status] [Main]: Load *, TEXT([Item Status]) AS [Status] RESIDENT [tmp_Main]; DROP TABLE [tmp_Main]; DROP Field [Item Status];

topic Data Manager Field Sort Order Issues on Front End Sheet in App Development

Data Manager Field Sort Order Issues on Front End Sheet