Counting the number of returned results

[soundsessential]

Hey folks

Is it possible, after having executed the request and having the results in a variable, to count how many returned records there were?

I'm doing this with the online plugin using GetFirstFieldValue and setting the field name to be "CountResult".

Is something similar possible with the desktop plugin?

Many thanks

[soundsessential]

Managed to figure out one way:

PatternCount ( PCQB_SGetXML( "Response" ; "" ) ; "<AccountRet>" )

Couldn't figure out how to add the MetaDataOnly attribute to the request and then pull the retCount from that. Said the attribute wasn't valid and I couldn't find any examples. Any tips in this regard would be appreciated. Thanks again.

[PCIPal]

Hi soundsessential, 

       You can set the "metaData" attribute in the request and look for the retCount attribute in the response. Here is an example for Customer Query. 

      PCQB_RqNew("CustomerQuery" ;  "metaData=MetaDataOnly" );

      PCQB_BeginSession();

      PCQB_RqExecute();

      PCQB_RsGetResponseAttribute( "retCount" );

      Also, you should be using the latest version 11.0.0.1 of the FM Books Connector plug-in. There were bugs on setting the attributes in a request in version 10 and 11.0.0.0 of the plug-in. I've tested the confirmed that it is working on 11.0.0.1 of the plug-in. 

 

Sincerely, Carson

[soundsessential]

This is super helpful. Thanks very much.