Hi I have this issue that I really don't know why its happening. It seems my @dblookup is not returning a multiple value. I does retrieve a value but its only one.This is my whole formula code:
class:= "";
mode:= "";
server:= "";
db:= "";
lkpView:= "AllExpenseItem";
key:= @Text(CVNo);
colNum:= 2;
fieldName:="Product_Category";
list:= @Explode(@DbLookup(class:mode;server:db;lkpView;key;fieldName);";");
@If(@IsError(list);@Unavailable;list);
the lkpView's 1st column is sorted and categorized.Is there a problem on my code or did I miss something that's why its not working? Thanks in advance.
I solved the my problem by making the lkpView not hidden, I don't know why its not working on hidden views though. Now it returns a multiple value as expected.