Re: How to random get 100 entries form a table list.

[Eric Cleereman (IT)]

Title: Mail

** Hi Likun,   I haven't had a need to try this, but the following approach may work:   - Create a table called Random, with the following fields:   - Random Number - Contains a number between 0 and 1, to X decimal places.   - Status of "not yet used" or "used".   - Import random numbers to this table, 1 per row.   - Create workflow to loop the Random table 100 times, using the first record each time whose status is "not yet used", then setting the status to "used".   - Use the number retrieved from Random to determine which record to retrieve from your table, using the result of the random number and the number of rows in your table.  Example: if your table has 100,000 records, and your first random number is .748567527589, your first random entry retrieved would from row 74,857.   Eric Cleereman -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of [EMAIL PROTECTED] Sent: Monday, August 14, 2006 11:08 AM To: arslist@ARSLIST.ORG Subject: Re: How to random get 100 entries form a table list.      Thank you，carey        I am designing a Configuration Management program now.The customer want to implement a audit function as follows.      First,The User search the CI from CMDB through some search conditiones.      The second, he set the number of the CI that he want to audit,then the system random get those form  searching rusult of the first step.      The problem that  I have no idea  to implement the random getting.                                      [EMAIL PROTECTED] 2006-08-14 ----- Original Message ----- From: Carey Matthew Black To: arslist Sent: 2006-08-14, 22:26:48 Subject: Re: How to random get 100 entries form a table list. I have no exact suggestion for the stated question. However, if you can describe what your going to use 100 random records for then I might be able to provide some idea. Most processes that require "random" input are for things like Customer Satisfaction Surveys and other "data analysis" type processes. And how you approach such functions are generally related to why your doing what your doing. Not to mention that "random" actually means different things depending on what your doing too. (Random strings for password generation, PKI key generation and Customer Satisfaction Surveys all have various degrees of "randomness" that is needed.) -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Solution = People + Process + Tools Fast, Accurate, Cheap.... Pick two. Never ascribe to malice, that which can be explained by incompetence. On 8/14/06, 李坤 <[EMAIL PROTECTED]> wrote: > > > ARSLISTDear Listers, > > I am sorry to trouble you,there is some question with my work. > How to random get 100 entry form a table list. > > Thanks a lot ! > > > > [EMAIL PROTECTED] __20060125_______________________This posting was submitted with HTML in it___