Hello everyone,
I am trying to identify a list of people with a definite End Date entered for a specific constituency, thereby currently de-activating that constituency in their record. The majority of names on this list should have an open ended 00/00/0000 entry in this field. As I am not IT, and we do not have an internal IT department I would ideally be looking for a solution that does not involve writing a procedure, if at all possible.
Any guidance you may have is greatly appreciated!
Thanks,
Duane
Do you have access to your system table T_KEYWORD? If so you could add Constituency End Date as a List Builder option and then pull a list of anyone that has an end date (Between would probably work best). If not, as a bit of a work-around you could run the Manage Constituency utility in Review Only mode on a list of everyone with the desired Constituency. In the report that comes up sort by End Date to see those that have one.
I'm pretty sure when a constituency has an end date that is in the past they consituency inactivates itself. One shouldn't have to manually inactivate the constituency when its end date has passed. Or you want to inactivate the constituency for anyone who has any end date, regardless of whether it is in the past? If you use the manage constituency utility you should be able to inactivate the constituencies using a combination of a list of anyone with the constituency, and the end date parameter.
Hello Kjersten,
That's exactly what I was hoping I could do. My next issue then is that I have no idea what to put in the various columns for this parameter in T_KEYWORD (Detail Tbl, Detail Col, etc.) Do you have any advice there?
Hello Amanda,
Sorry, I realized my post isn't totally clear. The issue is that there currently is an End Date entered for the constituency in a number of records, but there shouldn't be. I actually want to re-activate this constituency in these records, change the End Date to 00/00/0000, and so this is the list of people that I am trying to identify.
So, then a list parameter as suggested by Kjersten would be a good way to go about it, yes?
To add Constituency End Date to T_KEYWORD we have:
Data Type and Edit Mask should be DateDetail Tbl = vxs_const_custDetail Col = !.end_dt
Of course I would recommend doing this in your Test system first and making sure it works because I tend to be overcautious. :-)
Once you've done this and have your list of patrons with an end date the Manage Constituency report lets you change it back to blank en masse if there are a lot. Good luck!
That did it. Much appreciated Kjersten.
You're very welcome. Glad to have helped!
Unknown said: That did it. Much appreciated Kjersten. Thanks, Duane