Hi all. I have some troubles to select node that not deleted. I have one node marked as deleted.
If i try [code]SELECT * FROM [nt:base] WHERE [mgnl:deleted] IS NULL[/code] i getting all nodes (deleted to) [code]SELECT * FROM [nt:base] WHERE [mgnl:deleted] = ''[/code] i getting no nodes at all but if i try [code]SELECT * FROM [nt:base] WHERE [mgnl:deleted] IS NOT NULL[/code] i getting my deleted node and for this to [code] SELECT * FROM [nt:base] WHERE [mgnl:deleted] <> ''[/code] How to select not deleted? -- Context is everything: http://forum.magnolia-cms.com/forum/thread.html?threadId=46624b7e-1ce2-491d-950c-8be79d3ba012 ---------------------------------------------------------------- For list details, see http://www.magnolia-cms.com/community/mailing-lists.html Alternatively, use our forums: http://forum.magnolia-cms.com/ To unsubscribe, E-mail to: <[email protected]> ----------------------------------------------------------------
