I am having trouble with a!queryFilter( field: &quo

mokhtarc970 over 9 years ago

I am having trouble with
a!queryFilter(
field: "hasBeenFittedSuccessfully",
operator: "<>",
value: true()
),
I have a data row that has NULL for "hasBeenFittedSuccessfully". So it not displayed even if it is different from "true".
How can I handle that?

Discussion posts and replies are publicly visible

Parents

0 mokhtarc970 over 9 years ago

I am already using the queryLogicalExpression with an AND,

a!query(
logicalExpression:
a!queryLogicalExpression(
operator: "AND",
filters: {
a!queryFilter(
field: "FK_FFCaseId",
operator: "=",
value: ri!ffCaseId
),
a!queryFilter(
field: "productStatus",
operator: "<>",
value: cons!HFA_STATUS_DELETED
),
/*a!queryFilter(*/
/* field: "hasBeenFittedSuccessfully",*/
/* operator: "<>",*/
/* value: true()*/
/*),*/
a!queryFilter(
field: "hasBeenFittedSuccessfully",
operator: "is null"
)
}
),
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 mokhtarc970 over 9 years ago

I am already using the queryLogicalExpression with an AND,

a!query(
logicalExpression:
a!queryLogicalExpression(
operator: "AND",
filters: {
a!queryFilter(
field: "FK_FFCaseId",
operator: "=",
value: ri!ffCaseId
),
a!queryFilter(
field: "productStatus",
operator: "<>",
value: cons!HFA_STATUS_DELETED
),
/*a!queryFilter(*/
/* field: "hasBeenFittedSuccessfully",*/
/* operator: "<>",*/
/* value: true()*/
/*),*/
a!queryFilter(
field: "hasBeenFittedSuccessfully",
operator: "is null"
)
}
),
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data