Hi,
I've just started using iQA's to make life of data entry staff a lot easier. But it'll be great if I could have some help from the pros.
We are looking to display only registrants who have registered online for a particular event. I'm sure there's no out of the box report in iMIS but I tried to look around for BOs that might do this and after some help.
Thanks,
Viggi
Having had a look at the database for one customer, it looks like Orders.ENTERED_BY stores the ID of the web user instead of their username. You might want to confirm that though...
Hi Leo,
Thnx for your help. I included the field ENTERED_BY in to the CsRegistration table and manually hardcoded the ID of the staff members (only 2 of them) but it produces an error when I run the iQA - "Error: The Selected data source encountered an error. Invalid coumn name 'ENTERED_BY'".
I'm guessing this is because I didn't join any tables while I included the field from Orders to vCsRegistration? I hardcoded the filter "Entered by not equal" to both ID and also tried their username but still produces the error.
When you say you included ENTERED_BY into the CsRegistration table, do you mean the vCsRegistration view?
Also where did you hardcode the IDs?
The steps should be:
1. Add a column Orders.ENTERED_BY to the
vCsRegistration view
2. Modify the CsRegistration business object to then include the field ENTERED_BY (you need to add it as a property). Then save and publish the business object.
3. Then in the IQA query you can use the ENTERED_BY field to exlude certain IDs (in the filters tab of IQA)
Leo
Leo,
Yes, I meant vCsRegistration table. Sorry. I entered the ID's in the query as a value (Am I right?)
1. Tools --> BO designer (CsRegistration --> edit)
2. Under databases tab, initially you see only vCsRegistration (Primary) table, I went add, and selected Orders
3. From the available columns, I selected Orders.ENTERED_BY and hit "Add as Properties"
4. Save, Compile, Publish
5. Back to the BO designer and Publish CsRegistration
6. Back to the iQA and edit the query, to add the filter (CsRegistration.Entered By) property with not equal Comparison and then enter the IDs in the Value fiels
Hope the above steps are reasonable. Please correct me if wrong.
Thnx,
Vignesh
Hi Vignesh,
You need to modify the vCsRegistration VIEW in SQL and add the column Orders.ENTERED_BY. So at this stage we are not in iMIS at all. So you are doing an ALTER VIEW...
After you do that, you can edit the CsRegistration business object. The ENTERED_BY field should now show, and you can add it as a property (so you don't need to add the orders table in the business object).
Then you can save, publish etc.
Also in the IQA query you won't be able to have multiple IDs in the one value field. I would think you would need a separate filter for each ID.
i.e. CsRegistration.Entered By not equal 1000
AND
CsRegistration.Entered By not equal 1001
etc...
Hi Leo,
Did exactly what you advised by editing the VIEW and later the CsRegistration BO. Still no luck. Same error.
Entered the ID's in two seperate filters earlier too and still no luck and receive the same error. Any other suggestions?
Thanks,
Vignesh
Hard to say without looking at it. You might want to try copy and paste the SQL query generated from the IQA into SQL management studio and try work out why it is failing.
Leo
Thnx Leo,
It's silly of me. I got it to work finally!! There were two properties sitting in the iQA Cs.Registration.Entered By and also another one by the same name (This was picked by when I manually added the table yesterday!) and this time I tried the second one and it worked.
Thank you so much. Great help.
Vignesh
There is an IQA that gets
There is an IQA that gets installed out of the box that finds registrants for a particular event. It is called "Specific Event" and is found in the event module under IQA.
It basically uses the CsEvent and CsRegistration BOs. It has a parameter to search by event title, but you could also use event code if you wanted do.
In terms of only displaying the online registrations, that is where it starts getting tricky. Not sure what the best way to do this would be, but one way would be to look at the Orders.ENTERED_BY field. If you exclude any staff users, then technically the rest should be web users.
To do this you would need to modify the view, vCsRegistration to include the field Orders.ENTERED_BY. Then modify the CsRegistration business object to include this field. You can then use it in your IQA query. You might want to then also include the CsWebUser business object which will let you link that web login back to the record which should help you determine if they are staff (or you could just hardcode logins you want to exclude).
Hope that helps.
Regards,
Leo