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 <[email protected]> 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 <[email protected]> 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"
