Howto show only those gridview or listview rows where emailaddress column matches log

Imar · September 14th, 2014, 07:54 AM

Quote:

So they might want to randomly pick 26 of the 2000m

Randomly? Or based on some query logic?

In the later case, like I suggest earlier, create a query UI that lets them find the right customers. Then provide a button like "add current" and then rerun the query again on the server and insert the IDs of the records found in your junction table. That way you can add multiple selections for the same report and even provide a way to remove specific users again afterwards.

Cheers,

Imar

DatabaseGoddess · September 14th, 2014, 10:53 AM

Thanks, I appreciate your continued help. Yes, I'm afraid the choice by the users will be random. Not randomized but random based on whoever they want to select for whatever reason they have at the time. Really not based on anything I can use to subset the list of choices.

I was hoping that I could convince them to embed something in the file names to be uploaded so that they could merely upload all the files while I would have code to grab the token from the filename and add it to a column in the database table so that it could be used to filter the files so that each recipient could see only his own files (on another page).

The users who would upload the files en masse for the recipients are using a utility program that splits their Microsoft Access reports by recipient so I was hoping they could name their files so that the recipient name would be part of the file name like:

Qtrly_Report_Card_Jones_Kelly_2014Q2.pdf

but they have been noncommittal so far.

Thanks again.

Imar · September 14th, 2014, 11:00 AM

>> ot randomized but random based on whoever they want to select for whatever reason they have at the time. Really not based on anything I can use to subset the list of choices.

Then give them a filter to find these users and an "add to selection" button that adds the selected users' IDs to the junction table.

Imar