IQA

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

BACKGROUND:
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:
\imis\displayInformation.aspx?ID=256354

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

SOLUTION?
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.

Display an iQA in Matrix

Hi,

Trying to display member type and chapter in a matrix style derived from an iQA. Could you please shed some light in this?

We would like to have member types as rows and chapters as columns.

Is it possible in an iQA or should I go with SSRS?

Thanks,
Vignesh

iQA Paid through without time entry

Hi,

Is it possible to have an IQA display the PAID_THRU date without the time?

For e.g. PAID_THRU date displays the result as 31/08/2016 12:00:00 AM. Can we have them as 31/08/2016 (omitting the 12:00:00 AM)?

Thanks,
Vignesh

Looking for a good example of how to use the "@url:" dynamic filter

Has anyone had success using the "@url:" filter in IQA?  The documentation at docs.imis.com is sorely lacking on this feature.  I added two columns to a query - Committe Group Code, with a column heading of 'Code', and Group Name.  A second IQA query is called by the first query that receives the group code from the first query, clicked on by the user.  The second query then attempts to filter the results using the code from the first query with the syntax of CsCommittee.TheGroup = "@url:Code" on the Filters tab.  However, the second query displays all committees, not just the ones for the selected group.  Can anyone provide assistance on this one?  Thanks.

IQA hyperlink transfers to Page 2; how to have it open Page 2 in a pop-up window?

Hi all,

I've created an IQA with the last column being a "Comments" link, which transfers to a different page that shows that comment text area for the User ID on that report line. The comments will probably often be several paragraphs long.

When the user clicks the browser's back-arrow, the IQA report reverts to its initial "no run params typed in, no results displayed" state.

Is there any way to make the link pop up a pop-up window? This would leave the original window unchanged.

IQA Date Filters

Hello All, 

I'm trying to create an IQA for Informz that will pull IDs only for company records that expired on the last day of previous month.  Does anyone know a way this can be acomplished?  It's appears that SQL cannot be used as a filter. 

Mapping IQA Results

Hello all

I'm creating an IQA for public use that displays the results on a map. Initially the results of the IQA were limited to 10 records. When the map was generated, the zoom level was sensible, i.e. in and around the region of the results. However, when I increased the number of results in the IQA to 20 records, the zoom level of the map was changed so that it displayed the whole world, even though the results of the IQA were all within 10 miles of each other.

Picture in iQA

We are looking to present an iQA in WCM where a list is generated based on active company members along with their logo and a brief description.

I can probably use the picture tab in iMIS to upload their company logo but not sure what field / table is actually referenced for the picture in iMIS and how to drag them on to an iQA. Any ideas / suggestions?

How to retrieve profile image file name

In the mini profile iPart of iMIS20, users can upload an image of themselves, if this feature is enabled.  By default, these images are stored at /net/images/profile.  Each file seems to follow the format id#_random#.jpg (or gif, or png, or bmp, presumably) or id#_random#_T.jpg (gif, png, bmp).  An example for someone having the id of 61525 might be 61525_489866.jpg.  My question is whether this file name is referenced in any of the iMIS tables.  If not, how does iMIS know which file to use when displaying a person's profile?  I was hoping to reference that file name in an IQA.  Can the name be derived through some formula?  I also thought about writing some code that populated Name_Picture.Description or maybe a custom table with the file path.