Re: API:Only Data field names and Ids
Hi Misi, How to check the datatype of the field?? On 8/8/14, Misi Mladoniczky wrote: > Hi, > > The ARGetMultipleFields() which will give you enough details to figure out > which fieldids you want. > > You must look at the data type of the field to determine if it is a data > bearing field. > > If the data type is <= 14 the field can hold data. You should use the > constant > AR_MAX_STD_DATA_TYPE instead of 14 though. > > 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. > >> Hello List, >> >> It has been a quite long I haven't talked to you guys. Hoping all are good >> and >> enjoying. >> >> I want to fetch the list of data fields only with names and their ids. I >> have >> tried using method GetListField but it is giving me all the fields on the >> form >> including buttons, panels etc. I want to fetch only data field details >> from >> API. >> >> Any suggestions? >> >> Cheers! >> >> ___ >> 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"
Re: Service Action Example
Hi Laurent, If I want to retrieve the values from 10 different forms then I need to add 10 service actions in a single active link and 10 filters with service execution option correct? In this case an active link will invoke 10 filters having service exeution option and go to server to retrive values from 10 different forms in a single trip - correct? This is what I have understood till now. Slap me if you see me wrong anywhere. On Thu, Jun 5, 2014 at 2:55 AM, laurent matheo wrote: > ** > I guess what he meant is that if you do this this, you have "n" acls it > makes "n" trips/calls to the ARS server (internet, then internal network > between customer, mid-tier and ARS). > ACL1 (web browser) <--internet--> Mid-tier <---> ARS server (set field1) > ACL2 (web browser) <--internet--> Mid-tier <---> ARS server (set field2) > (...) > ACLn (web browser) <--internet--> Mid-tier <---> ARS server (set fieldn) > > > With service it would be kinda like this, one acl triggers one filter. > This way there is only one "trip" using the whole "internet, then internal > network between customer, mid-tier and ARS", everything else would stay at > ARS server level: > ACL1 which triggers service (web browser) >--internet--> Mid-tier >---> > ARS server (Triggering Filter with Service) > _Filter called by > "service" (ARS server) (set field 1) > _Filter called by > "service" (ARS server) (set field 2) > _(...) > _Filter called by > "service" (ARS server) (set field n) > > And once it's done, the filter "answers" (hence the callback) once all > actions are executed: > ACL1 which triggers service (web browser) <--internet--< Mid-tier <---< > ARS server (Triggering Filter with Service) > > If I understand his example correctly, it "just" means that you save the > trips user to mid-tier to ARS. > > Service is kinda like callback indeed in C++ for example where in your > software you call a dll, dll does all the "heavy work" and uses callback > function to update your software on the status. > It's also like Ajax if you code HTML. You don't submit the page to send > value to server, launch a code server side and gets its result. > > > At least that's how I see it. > > > > On 04 Jun, 2014,at 10:39 PM, Sweety wrote: > > Indeed, I am not able to understand how to implement that example. How can > service action perform the work of 10 active links at one server round trip? > > Imagine I am using 10 active links with 10 different forms to set fields, > how can I active this with single service action with just single server > trip? This is what that blog is saying, right? I am not getting any hint > how to prove and implement that example. > > I would appreciate if you help me to implement that code or give me an > idea to prove that statement. > > Cheers, > Sweety > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > "Where the Answers Are, and have been for 20 years" > > _ARSlist: "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"
Re: $LASTCOUNT$ keyword is not expanded when default values are set
Hello Misi, Just trying to understand what does that mean On 3/18/14, Misi Mladoniczky wrote: > Hi, > > What value were you expecting? > > The normal way to use $LASTCOUNT$ is within one or two ACTL firing on the > same > action: > > ACTION 1: > Set-Fields: (some query) > dummy = $1$ > ACTION 2: > Set-Fields: CURRENT FORM > records in search = $LASTCOUNT$ > > Best Regards - Misi, RRR AB, http://rrr.se > >> Hi List, >> >> Why $LASTCOUNT$ keyword is not expanded when default values are set? Can >> anybody give me a reason for this? >> >> Cheers, >> >> ___ >> 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"
Re: Currency table and Index table for a form
Hey Misi thanks for responding. I know how to find the tables from database and I also know how to use ar schema metadata form. Just wanted to know if ar system really creates individual tables for each regular form when we add a currency fields. As per your comments we it seems there is only a single table which stores indexes for all form - Please confirm this. Thank you Misi. On 3/6/14, Misi Mladoniczky wrote: > Hi, > > The two main currency forms are: > AR System Currency Codes - allowed currencies of your system > AR System Currency Ratios - dates and exchange rate > > To find out which table things are stored in, you can check the form "AR > System Metadata: arschema", or the arschema-table directly. It contain a > mapping between the Name and the SchemaId. > > The SchemaId is a number, for example 123. This means that the man table of > the form is T123. Note that the numbers for a specific form varies between > systems. > > All normal forms has at least one index for the request id field. They can > also have more indexes defined through Developer Studio under form > properties. > You can also find these indexes in the form "AR System Metadata: > schema_index" > table or the corresponding table schema_index. > 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, >> >> It is given in the docs as currency table under that they gave an >> explanation >> for a currency field. Just wondering does currency table really exist? I >> don't >> think so. Correct me I am thinking wrong. >> >> https://docs.bmc.com/docs/display/public/ars81/The+currency+table+for+a+form >> >> One more thing how can I find the index table for a corresponding form? >> Does >> AR System creates a separate index table for each regular form? >> >> Mercy, >> 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"
Re: Retrieve data from SQL Menus
Dim fieldValueList As New FieldValueList()
fieldValueList.Item(23009) = ""
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 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 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"
Re: Retrieve data from SQL Menus
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 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"
Re: OT: ServiceNow
Just a reduction in installation time is not enough to say that iSNow is better than remedy. Did you see the user interface of SNow ? It sucks... Its not at all user friendly. BMC Remedy is much better than SNow in all areas. I assume that BMC is working very hard to make it more powerful. It wont let its best product to go in vain. I love remedy. On 11/26/13, Joe Newmark wrote: > We have implemented SNOW in both hosted and on premise instances and we like > it. The average deployment time has dropped significantly from that of > installing Remedy. We are currently deploying both SNOW and Remedy on Demand > for two customers. I will take SNOW over RoD anytime... I am fighting BMC on > many fronts. The latest was getting them to understand that the AR server > needed to get out past the proxy server to deliver a web service. They had > set it up that way in development, but not in QA or production. It took > three critical tickets and four days to get this worked out. Couple that > with the hoops you need to jump through to get a simple customization like a > notification filter done makes and I am fed up. > > When I first heard about ServiceNow, I was not impressed, after all I was a > Remedy guy. However by the time the Berlin version came out I was impressed > by how easy it was to deploy even on premise. The average installation time > is under 20 minutes. That is installing both the database and the > application. To me ServiceNow is what Remedy 8 should have been. > Both products have their place, but BMC needs to step up their game to keep > their market share. > > Sent from my iPad > >> On Nov 26, 2013, at 4:34 PM, "Pierson, Shawn" >> wrote: >> >> ** >> My company has also recently taken a look at Service Now. I can also >> confirm hearing some deliberately false information being provided, but >> that’s likely typical for any sales presentation. That being said, I do >> have a cautiously positive view of their product. The techie part of my >> personality would like to make the switch just to learn something >> completely new and exciting, but in terms of doing what’s best for my >> organization I don’t think it’s fully matured enough yet to replace >> Remedy, plus not all companies are willing to have their private data out >> on “the cloud” yet. I’ve also come to the opinion that us Remedy folks >> are maybe more opposed to some of the people involved with ServiceNow and >> their marketing techniques than the anything else. Either way, I plan to >> keep my eye on them and if my management told me tomorrow that they signed >> me up for classes and that we’d be migrating to that product, I would >> treat it as an opportunity not treat it as the end of the world. >> >> Thanks, >> >> Shawn Pierson >> Remedy Developer | Energy Transfer >> >> From: Action Request System discussion list(ARSList) >> [mailto:arslist@ARSLIST.ORG] On Behalf Of arslist >> Sent: Tuesday, November 26, 2013 2:26 PM >> To: arslist@ARSLIST.ORG >> Subject: Re: OT: ServiceNow >> >> ** >> That is I was looking at SNOW in terms of knowing what’s good and what is >> bad. No product is the best at everything. >> I am certainly more open minded about the products than most folks I met >> at the SNOW conference were. >> >> To them [SNOW conference attendees, the ServiceNow employees and others] >> BMC Remedy is the enemy and it can do no right. There were many expressing >> blatantly false views, I kept my opinions mostly to myself. >> >> Well, I did have to correct former BMC employees who were saying Fred >> Luddy had something to do with creating Remedy. A view I heard enough >> times to consider it to be deliberate. >> >> Yes, the marketing is a direct steal from what Remedy Corp. said in the >> 1990s, and there is a tiny bit of truth to some of what they say. Mostly >> though, if the developer studio were sped up to the speed of the old Admin >> tool, It could easily be shown you can create robust custom apps faster >> and easier with Remedy than with ServiceNow. Real apps that is, with a >> real data model. They however, can show creating new fields and apps in >> minutes due to the simplicity of the system, the data model, what gets >> displayed and the simplistic development tool that does not show that all >> real development is done by working on java scripts. >> >> That being said, if you want quick and simple display of quick and simple >> data in a quick and simple data model, it arguably can. Then again, so can >> dozens of other light weight applications. RemedyForce would certainly >> seem the better direction for those that want a truly cloud built light >> weight system. >> >> Note: These opinions are mine. No one elses, not my employer, and possibly >> not mine next week if I get evidence that I am mistaken about any of the >> above. >> >> Daniel >> p.s. and they of course have nothing like the ARSlist J >> >> From: Action Request System discussion list(ARSList) >> [mailto:arslist@ARSLIST.ORG] On Behalf Of Sh
