IQA Query for Marketing

I have yet another IQA question...

I am trying to pull a list of contacts from iMIS that does the following:

If one person at an organization is registered for a specific event, the query should exclude all staff at that organization.
or, in reverse,
Only pull contacts linked to organizations that don't have anyone registered for a specific event.

I have the basic skeleton of the query complete, I just can't figure out how to do this.

PrimaryOrganizationSelect IQA Query

So, I accidentally deleted the custom SQL expression from the PrimaryOrganizationSelect query - which is making the Primary Organization field at account creation not display any results. I'm just wondering if someone could share with me the text for the SQL expression so I can fix this!


Dynamically reference a tab from IQA

I am trying to dynamically reference a tab in a content collector iPart. So from the results of an IQA, I'd like to link it to a RISE page that has that iPart on it and open the second tab. I am sure this can be done but I am drawing a blank. Can anyone assist?

Populating profile photos

Our client has uploaded the profile photos into member records using either PV or the iMIS Desktop, so there are values in the Name_Picture table for a myriad of their records - or should I say copious amounts of records. It's a significant number of records.

However, we're currently working in RiSE and the images do not exist on the server in the images/Profile folder. We've got an IQA query that is pulling the information and the images are not loading because while the information is in the Name_Picture table, the actual image does not reside on the server.

Custom Join options ("Relations") as defaults for custom business objects

When attempting to join a custom business object based on the Trans table to a standard business object that has ID while choosing sources for an IQA, I want it to automatically join ID = ST ID. Does anyone know how to do this? What forces that dynamism?

How to get linked-to IQA report to pop up in new window?

Hi all,

We have a working IQA in which the person’s name is a link to go to another IQA query to show details about the person. In the IQA definition, that column’s Link value is:
~/MyAPWA/DCS/Mentor_Profile.aspx?MentorID=[code_ID] like you'd think; of course our ID column has that alias of "code_ID".

However, this opens the next IQA in the same window. So, when the user clicks the browser’s back arrow to return to the list of people, s/he must select the run criteria again and click a button, which is the like worst thing in the world apparently.

IQA Query to pull all contacts who have not attended an event within a specific timeframe?

Hi everyone,

I'm recently self-taught in IQA and I've been able to write almost any query I can think of... except for this one.  I don't know what I'm missing, or if it's even possible, but here is the end result that I'm looking for:

I would like to pull the IDs and names for all contacts in iMIS who have neither registered for nor attended an event within a specified timeframe (for example: those who have not registered/attended in the last 6 months).

Letters - Dealing with Bulk using IQA, Mail Merge, Letter System???

We have a requirement for having a definite class of letters to be printed/emailed ideally from a list again generated by an IQA preferably.

How can we use the current Letter system and/or replicate its functionality but with going bulk and scheduled to happen overnight (for the emailing)

Your thoughts on how this has been implemented at your company or your client would be definitely helpful.

Any way to use a hidden form field in the results of an IQA? (Rather than pass data on the QueryString?)

We have the an IQA that returns a roster of people.
Each link carries the ID on the QueryString in the URL
Clicking on the link sends the user to another page using a URL such as:

This makes the ID visible and "modifiable" by the user.

Is it possible to tell IQA to hide this ID and to NOT pass the ID as visible on the queryString? Or is passing the URL on the QueryString the only way to pass an ID from the results of the IQA to the new page?

Upgraded to 20.2.19, and now new IQAs won't save

Hi all,

We haven’t created an IQA since we upgraded to 20.2, and now it won’t let me save a simple IQA. It's a pretty vanilla case...

1) In our test/dev SQL Server DB, I created a simple database view (unobjectionable code is below);

In our RISE development site which points to that database, in both Chrome and FireFox, I…

2) Created and published a RISE biz object from the view.