Hello! I thought I had this working but for some reason I cannot get it to work. What I am attempting is to get an index for a list of projects sorted by their due date. I created an index that seems to be working as expected when I test it in the dashboard. I then need get the ref from that index and so I used Join() and a ‘refByRef’ index as described in the Core FQL Concepts blog series. I need to do this so I can run Difference() with my other indexes all before I Paginate(). I get a list of projects at the end with no errors but they are not in order by due date. Can you see what I have so far below and let me know if more information is needed in order to get my list to return in date order. Thanks!
Map( Paginate( Difference( Join( Match(Index("projectsByDueDate")), Lambda(["value", "ref"], Match(Index("projectsRefByRef"), Var("ref"))) ), Match(Index("getActiveProjects"), false), Match(Index("projectsByStatus"), "Closed"), Match(Index("projectsByStatus"), "Pending") ) ), Lambda("ref", Get(Var("ref"))) )