Data Manager Field Sort Order Issues on Front End Sheet
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];