Query Entity Issue

prakharg over 7 years ago

I have a Query Entity rule which accepts input as appId of multiple type, from my SAIL UI I am calling this rule with appIds for example {1;2;3;4}, but query entity is not returning result in same order rather it is returning CDT in Random fashion as given below:

Actual Result - [Id =3, name="Tom"];[Id=4, name="Dan"];[Id=1, name="John"];[Id=2, name="David"]
Expected Result - [Id=1, name="John"];[Id=2, name="David"];[Id =3, name="Tom"];[Id=4, name="Dan"]
appIds are passed in sequence {1;2;3;4}

This issue is creating data mismatch on UI.
Is there a way to handle this?
Thanks in Advance

Discussion posts and replies are publicly visible

Parents

0 sikhivahans over 7 years ago

I believe, the following could be another option:

fn!apply(
          fn!displayvalue(
                    _,
                    local!ds.data.id,
                    local!ds.data,
                    null
          ),
          ri!ids
)

Also, I guess you may need to remove null values in the resultant output if you are following the strategies mentioned (by me and I think @stefanh's approach as well) above, as you might not be having the results always for a given set of inputs.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 sikhivahans over 7 years ago

I believe, the following could be another option:

fn!apply(
          fn!displayvalue(
                    _,
                    local!ds.data.id,
                    local!ds.data,
                    null
          ),
          ri!ids
)

Also, I guess you may need to remove null values in the resultant output if you are following the strategies mentioned (by me and I think @stefanh's approach as well) above, as you might not be having the results always for a given set of inputs.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data