I'm trying to fetch records using the rbf_getViewPage API but I can't find a way to filter empty text fields. In the documentation, it was mentioned that we can use NUL opcode in filters to text fields. The error below is displayed whenever this filter is used:
I also tried EQ opCode where the value is an empty string but I'm getting all records instead. I'm using version 4.5.3.
HI
use the value of NUL as a string in the API and give an empty value for Value key
example
rbf_getViewPage("wIk-oviSTMGWo35tznBTUw", function (data) { }, {
"useLegacyDateFormat": false,
"startRow": 0,
"rowsPerPage": 100,
"fieldList": "Rollnum,Student_name,status,Intrested_subjects",
"filtering":
{
"filters":
[
{
"field": "Student_name",
"value":"",
"opCode": "NUL"
}
]
},
"sorting":
[
{
"field": "Student_name",
"order": "asc"
}
]
});
Thanks and Regards
Hariteja M
Hi
The value field for filter must be specified. i.e empty at least
Thanks and Regards
Hariteja M
HI
use the value of NUL as a string in the API and give an empty value for Value key
example
rbf_getViewPage("wIk-oviSTMGWo35tznBTUw", function (data) { }, {
"useLegacyDateFormat": false,
"startRow": 0,
"rowsPerPage": 100,
"fieldList": "Rollnum,Student_name,status,Intrested_subjects",
"filtering":
{
"filters":
[
{
"field": "Student_name",
"value":"",
"opCode": "NUL"
}
]
},
"sorting":
[
{
"field": "Student_name",
"order": "asc"
}
]
});
Thanks and Regards
Hariteja M
Hi Hariteja,
It worked!
Thanks much,
Godfrey