Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (4)

Resolved Unable to separate two search fields

  1. How-to
0
Votes
Undo
  1. Milan Jovanovic
    Milan Jovanovic
  2. InfoMaker
  3. Tuesday, 18 June 2024 10:09 AM UTC

Hello Support Team,

 

I'm making a report and this is a criteria screen for the report. Next to a fields (squares) are a search icons that when the report is imported back into ConceptOne work as a search.

 

I'm having an issue where, I'm unable to make parm_entity_name and parm_entity_name2 function separately. At the moment only parm_entity_name search works when imported back into the ConceptOne. While parm_entity_name2 search is currently not working but when name is entered and I press tab that name is populated in both parm_entity_name and parm_entity_name2. I believe the issue is that both parm_entity_name  and parm_entity_name2 are pulling information from a same column. They are pulling information from a same column but I need them to display different information. Do you know how can I resolve this issue?

 

 

Please reach out if you have any additional questions.

Thank you,

Milan

  1. InfoMaker
Rich Text Format - How to display
Issues with Query "Convert to Syntax" and using no...
Responses (4)
John Fauss
John Fauss Accepted Answer Pending Moderation
  1. Tuesday, 18 June 2024 15:12 PM UTC
  2. InfoMaker
  3. # 1

If I understand correctly, this report is performing the team role reassignment task correctly, as intended. The problem/issue is the search functionality that is performed by ConceptOne, which I assume is an application that can interface and interact with InfoMaker reports.

If this is the case, then I concur with you that ConceptOne does not seem able to handle this case where you are supplying one or two values for a single column. If I were coding this in a PowerBuilder application, I would be dynamically altering the SQL SELECT statement that gets executed for the search to support the three possible variations (only name supplied, only name2 supplied, name and name2 supplied). Since I have no familiarity with ConceptOne, I think you have only two possible avenues open to you:

1. Remove one of the "search" boxes from the InfoMaker report and thereby search on only one value.
2. Contact the technical support team at ConceptOne to see what alternative solutions may be possible.

Best regards, John

Comment
Milan Jovanovic
  1. Milan Jovanovic
  2. Tuesday, 18 June 2024 15:39 PM UTC
Hi John,



Thank you , this was helpful.



Best regards,

Milan
  1. Helpful
There are no comments made yet.
John Fauss
John Fauss Accepted Answer Pending Moderation
  1. Tuesday, 18 June 2024 12:59 PM UTC
  2. InfoMaker
  3. # 2

Hi, Milan -

Please post the SQL used by this report. It will not be possible to help you unless we can see the SQL.

Best regards, John

Comment
Milan Jovanovic
  1. Milan Jovanovic
  2. Tuesday, 18 June 2024 13:27 PM UTC
Hi John,



I might have misunderstood you. I have provided you with the source code that runs the report but I forgot to provide you with Infomaker SQL, so here is is:



EXEC esauthor.upx_ReassignTeamRoles :parm_contract_id, :parm_entity_id, :parm_entity_id2, :parm_partysubtype, :parm_preview

WITH RESULT SETS (

(

Result NVARCHAR(100)

)

);

  1. Helpful
There are no comments made yet.
Milan Jovanovic
Milan Jovanovic Accepted Answer Pending Moderation
  1. Tuesday, 18 June 2024 13:10 PM UTC
  2. InfoMaker
  3. # 3

Hi John,

The source code I used for this report is in an attachment.

 

Thank you,

Milan

Attachments (1)
ReassigningTeamRoles.zip
Comment
There are no comments made yet.
Milan Jovanovic
Milan Jovanovic Accepted Answer Pending Moderation
  1. Thursday, 20 June 2024 09:18 AM UTC
  2. InfoMaker
  3. # 4

Hello Support Team,

 

I have another question for you, how can I tell search field parm_entity_name2 to look for ID at parm_entity_id2 instead of parm_entity_id? It seems that both fields are looking at the same ID field.

I'm asking this because when I populate parm_entity_name2 the same information is populated in parm_entity_name as well. This refers to the same issue.

 

Thank you,

Milan

Attachments (1)
Screenshot 2024-06-20 111636.png Screenshot 2024-06-20 111636.png
Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.