We have a client that would like to put an IQA query on the web, which is easy enough. However, they'd like the results for to show accross two rows - for example, a company name and address on the first row, then the courses it offers underneath. I don't think this is possible (at leaset with 15.1.3) but if anyone knows otherwise it would be great to hear. Has anyone been able to modify how the results appear?
IQA
IQA Tabs
We have a client installation where it seems all the tabs for existing IQAs do not display correctly, and so can't be edited. Nor can new ones be created. If I open an existing query, or create a new one, then Summary/Sources/Filters/Display/Sorting appear as text, and won't function, so I can't navigate away from the start page of the IQA to edit/create it.
Has anyone come across this before?
Running an IQA with Multiple Parameters via SOA
I'm trying to run an IQA query via SOA and to pass through multiple parameters. I couldn't find any documentation though a found a couple of samples here in the community.
The base code I grabbed from Paul Rogers example is:
var em = new EntityManager(AppContext.CurrentIdentity.UserId);
var query = new QueryData("IQA");
// The first query criterion MUST be named "QueryName"
query.AddCriteria(CriteriaData.Equal("QueryName", "$/ContactManagement/DefaultSystem/Queries/SingleContact"));
Alternet IQA output view
Good Afternoon Everyone,
My customer is really not fond of the IQA output grid. Are there any options for displaying IQA results in another format? Even plain text is more preferrable for my customer.
Thanks in advance,
Philip
IQA with multi-select options that work
HI Guys,
I am looking to use an IQA which can interrogate a multi-select field and actually show results. eg. field contains "GCSE,IBMYP" if you filter on field equals you get a drop down list which never gewts results as there are 2 entries. If you use the m,ulti function you still don't get results. What I need is a way to have teh multi-select interface but with teh contains option. Ot better still get a check box display to show all possible options and OR the results so you will get multiple results.
IQA variables
Hello,
Does anyone happen to have a full list of all the IQA variables that are available and the actual values returned by those variables? I have found five variables but not much documentation detailing their use or what actual values each variable returns. Here is what I found so far:
@LoggedInUser - filter by the currently logged in user
@Me - filter by the currently logged in user
@SubjectContact - Filters by a selected contact, such as contacts selected through user impersonation
@Date - Filters by the current date
@Now - Filters by the current date and time
Finding no supporting documentation, I assumed @LoggedInUser and @Me would give me a contact's imis ID so I could use it to filter records from ibos such as CsContact. I was wrong, those both return lovely GUIDs which do not help. Does anyone have information on all available variables for IQAs? More specifically, a variable that returns the actual imis user ID of the member logged into the website so it can be used within an IQA filter? Unless there is some other way to access the current logged in users imis ID inside an IQA...
Concatenating Fields for Lookup
I have a many to many situation in a business object I am trying to use for a query (IQA) We created a UDT with a field called "District". In this field is a number. This number is not unique - for example, someone could be in dictrict 4 in one county and someone else could be in district 4 in another county. I want to create a lookup where the District field in a particular record is concatenated with the County field so that when the user goes to run the IQA, they can choose the district by county. E.G. I want the lookup table to look something like this:
Multiple select filter on Gen_Table - possible?
I need to allow the user to select multiple values for a field in a user-defined table that uses a GEN_TABLES lookup but when I create the filter for that field, there is no multiple checkbox. I tried creating a query to give me just the values I need, but couldn't get it to work. I've looked in all the IQA documentation on ASI's web site but can't find a solution. Any help would be greatly appreciated.
IQA - SQL Expression FIeld
Well I have canvassed Tech Support and NiuG and cannot seem to get an answer or else no-one is using SQL Expressions with IQA reports.
Here is what I would like to do with an example:
1 -- Gender field has M or F
2 - Need to have a field Called Gender on my IQA which shows 2 if its an M and 1 if its an F
Surely that is something thats possible?
Using a Query as a source for IQA
I have a client who wants a list of a particular member type (REG) who reside in Canada or in Washington State.
This is really easy to do with SQL: SELECT Full_Name, ID, State_Province, Country, Member_Type FROM Name WHERE STATE_PROVINCE = 'WA' OR COUNTRY = 'Canada'
I tried using IQA in the following ways:
- Create a query where I use the CsContact BO and Filter Member Type = "Regular" AND State Province = "Washington" OR Member Type = "Regular" AND Country = "Canada" Depending on the order, I either get all Washington or All Canada, but never both. If I try Member Type = "Regular" and State Province = "Washington" or Country = "Canada" I get the same results, depending on the order
- I tried creating two queries - one where Member Type = "Regular" and Country = "Canada" and one where Member Type = "Regular" and State Province = "Washington" then used left outer joins to the CsContact BO for each of them, but got multiple lines for each result and only ID numbers, no other fields
- I created a query to just show Member Type = "Regular" and then used it as my source for a query where Country = "Canada" or State Province = "Washington" and was able to get only Canada and Washington but for every member type.
The only solution I could find was to use State Province and select all the Canadian provinces as well as Washington. This works for now, but in the future they will be asking me for this type of thing again and it may not be possible to make the filtering selections from one field. Did I do something wrong with my joins or my filters?