AnsweredAssumed Answered

CHECK  IF ATTTACHMENT'S IDEA  ARE PRESENT OR NOT

Question asked by gaetano.diluca.1 on Mar 21, 2013
Latest reply on Mar 26, 2013 by Nicolas.Sanzana-CAChile
Hello everyone;

I created the attachment field in the object "Idea" which stores the file in the "file store directory" on the Linux machine and NOT in DB.

I would like to create the report in which shows me whether the idea has the attachment or not. I mean there must exist 3 cases:

1.when the idea has NOT the attachment, the query must return NULL

2. when the idea has the attachment, the query must return the folder ID or the folder Name.

3. when the idea HAD the attachment BEFORE and it has been REMOVED, the query must return NULL.(because the current situation is without attachment)

Now, my problem is the 3rd case which return the result the same as the first case ,while I would like it to return NULL.

I guess this problem is related to storing the attachment in Machine (because it is not stored in DB, once I remove it in Clarity, it still exist on the machine and that is why the query doeas not return NULL.)

I do appreciate you if help me overcome this problem

Best
Gaetano

Outcomes