Sort items by picture/no picture

(0) Share

Report

Posted on by Frode Kristiansen

Hi! I`m trying to filter my items by the ones who has an image attached and not, but i dont know how to. I read somwhere in theese forums that the image column can be filtered by "0" or "1", but i get the message (translated from Norwegian)

"Filter 1 is not valid for the image field in the item table. Invalid GUID-string format. Correct GUID-string format is CDEF890-ABCD-0123-1234-467890ABCDEF, where 0-9, A-F symbols hexadecimal characters."

I have the same question (0)

All responses (4)

Answers (0)

Grzegorz Szwed 55 on at

Like (0)

Report

Please try by replacing

0 -> ''

1 -> *

Was this reply helpful? Yes No
Frode Kristiansen 5 on at

Like (0)

Report

Doesn't seem to work. Not sure what you ment but I am getting the same error when i try just replacing 0 and 1 for " and *. I also tried the whole string, which i belive is not what you ment. And by putting 1->* in the filter field, I get the error "The filter 1->* is not valid for the for the field Image in the Item table. > unexpected.

Was this reply helpful? Yes No
Grzegorz Szwed 55 on at

Like (0)

Report

I just tried in my Navision to do what you want to do so I have typed in the filter as follows

Was this reply helpful? Yes No
Frode Kristiansen 5 on at

Like (0)

Report

For some reason, it is not working here:

Was this reply helpful? Yes No