Hi,
The problem is that the ExpandMenu should not take a fieldValueList as
argument. I think.
In the C-API it takes an ARCharMenuStruct as input.
To expand it, you must do something like this:
1. MENUDEF = ARGetCharMenu()
2. find and set values for the qualification deap down in the MENUDEF
3. MENUEXPEANDED = ARGetCharMenu(MENUDEF)
In your position, I would skip the menu altogether, and do a similar search
instead using the qualification:
(('CategorizationSchemaKeyword' = $230000009$) OR ($230000009$ = " ")) AND
(('Asset Class' = $300483500$) OR ($300483500$ = $NULL$)) AND ('Status' =
"Enabled")
1. Replace the $xxx$ with an appropriate "string" or integer.
2. Use ARLoadARQualifierStruct to convert the string to internal format
3. Use ARGetListEntryWithFields to perform the search and retrieve the result
Best Regards - Misi, RRR AB, http://rrr.se
> Dim fieldValueList As New FieldValueList()
>
> fieldValueList.Item(230000009) = ""
>
> fieldValueList.Item(300483500) = ""
>
> fieldValueList.Item(7) = "Enabled"
>
>
>
> Dim menuItems
>
> menuItems = Access.server.ExpandMenu("PCT:PDC:P1_CIType-Q",
> fieldValueList)
>
> Dim menuItem
>
> For Each menuItem In menuItems
>
> MsgBox(menuItem.ToString)
>
> Next
>
>
> I tried this but I am getting error "(313) data types are not appropriate
> for relational operation"
>
>
> On Wed, Nov 27, 2013 at 3:59 PM, Misi Mladoniczky <m...@rrr.se> wrote:
>
>> Hi,
>>
>> You got what you need. The name of the API-call. Then you can read about
>> what
>> it does. I am just pointing you to a procedure where you can determine the
>> API-calls needed by yourself instead of needing our help.
>>
>> If you are running MidTier, the ARGetCharMenu might have been done earlier
>> when the mid-tier server cached information about how the menu was
>> constructed.
>>
>> If you run ARUser, you will this might also have been cached into ARF/ARV
>> files before hand...
>>
>> If things exists in the C-API it has an equivalent in the Java-API and any
>> other wrapper on top of these two core API:s.
>>
>> Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
>>
>> Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13):
>> * RRR|License - Not enough Remedy licenses? Save money by optimizing.
>> * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
>> Find these products, and many free tools and utilities, at http://rrr.se.
>>
>> > Hi Misi,
>> >
>> > I did not get much information in log, the only thing which I got in the
>> > low file is the below line
>> >
>> > +EXPQRY ARExpandQueryMenu from Remedy User (protocol 14) at IP address
>> ****
>> >
>> >
>> >
>> > On Wed, Nov 27, 2013 at 4:05 AM, Misi Mladoniczky <m...@rrr.se> wrote:
>> >
>> >> Hi,
>> >>
>> >> I the C-API, it would be a combination of doing first a ARGetCharMenu()
>> >> followed by a ARExpandCharMenu().
>> >>
>> >> It becomes complex if it is a context sensitive menu, where you need to
>> >> insert
>> >> a values into the structs. It should be straight forward for SQL menus,
>> as
>> >> it
>> >> only contains a "string" with the sqlcommand. If it has a $536870913$ or
>> >> similar field id in it, it must be replaced with a string or integer.
>> >>
>> >> I suggest that you browse through the C-API-documentation to get an
>> idea of
>> >> what kind of calls there is.
>> >>
>> >> You can also turn on API-logging to see which API-calls are executed
>> for a
>> >> certain kind of operation. This can be done with Client-side-logs while
>> >> enabling logging for Server-API in the AR System User Preferences form.
>> >>
>> >> Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP
>> 2011)
>> >>
>> >> Ask the Remedy Licensing Experts (Best R.O.I. Award at
>> WWRUG10/11/12/13):
>> >> * RRR|License - Not enough Remedy licenses? Save money by optimizing.
>> >> * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy
>> logs.
>> >> Find these products, and many free tools and utilities, at
>> http://rrr.se.
>> >>
>> >> > Hi List,
>> >> >
>> >> > How can I retrive the data from SQL Menus through .Net API
>> programming ?
>> >> Any
>> >> > sample code would be great.
>> >> >
>> >> > Regards,
>> >> > Sweety
>> >> >
>> >> >
>> >>
>> _______________________________________________________________________________
>> >> > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>> >> > "Where the Answers Are, and have been for 20 years"
>> >> >
>> >>
>> >>
>> >>
>> _______________________________________________________________________________
>> >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>> >> "Where the Answers Are, and have been for 20 years"
>> >>
>> >
>> >
>> _______________________________________________________________________________
>> > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>> > "Where the Answers Are, and have been for 20 years"
>> >
>>
>>
>> _______________________________________________________________________________
>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>> "Where the Answers Are, and have been for 20 years"
>>
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> "Where the Answers Are, and have been for 20 years"
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"
