A similar issue was started quite some time ago for the CCK project (actually, I think it was started in the Views issues, then moved to CCK for integration with Views).
I'm surprised it still hasn't made it into CCK in D7. I figured perhaps this issue should be mentioned for core, since most of CCK ended up in there.
This is about integration with the Views Module. We can sort results in views randomly at the node level (for instance, sorting content of type Gallery into a random order). However, we cannot sort at the field level (for instance, sorting the images in each Gallery's image field randomly).
My use case is that I have a bunch of short 'tips' on certain subjects. It would be ugly to create a separate piece of content for each one, so I have them all housed in a single piece of content, as separate entries in a text field. I would like to create a view that will display a single random entry.
I can create a view that will only display the first entry, or the last entry, because the field entries can be reversed under Multiple Field Settings in Configure Field. It would be great if the entries could be randomized.
Please see a similar issue in the CCK module: http://drupal.org/node/439230
Test request sent.
Previous result: PASSED: [[SimpleTest]]: [MySQL] 1,658 pass(es).
PASSED: [[SimpleTest]]: [MySQL] 1,603 pass(es).
FAILED: [[SimpleTest]]: [MySQL] Unable to apply patch views-random-sort-1190900-0_2.patch. Unable to apply patch. See the log in the details link for more information.
FAILED: [[SimpleTest]]: [MySQL] Unable to apply patch views-random-sort-1190900-0_1.patch. Unable to apply patch. See the log in the details link for more information.